binder

5 rows where origin = "gke2.mybinder.org" and provider = "Zenodo"

View and edit SQL

Suggested facets: spec, resolved_ref, timestamp (date)

provider

  • Zenodo · 5

origin

  • gke2.mybinder.org · 5
Link rowid ▼ timestamp version provider spec ref origin repo resolved_ref org
2616922 2020-09-25T16:41:00+00:00 4 Zenodo 10.5281/zenodo.3402938   gke2.mybinder.org   3402938  
2646724 2020-09-24T20:23:00+00:00 4 Zenodo 10.5281/zenodo.3242074   gke2.mybinder.org   3242074  
2647285 2020-09-24T21:00:00+00:00 4 Zenodo 10.22002/d1.1634   gke2.mybinder.org   1634  
2673783 2020-09-23T21:13:00+00:00 4 Zenodo 10.22002/d1.1259   gke2.mybinder.org   1259  
2675685 2020-09-23T23:30:00+00:00 4 Zenodo 10.22002/d1.1259   gke2.mybinder.org   1259  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [binder] (
   [timestamp] TEXT,
   [version] INTEGER,
   [provider] TEXT,
   [spec] TEXT,
   [ref] TEXT,
   [origin] TEXT,
   [repo] TEXT,
   [resolved_ref] TEXT,
   [org] TEXT
);
CREATE INDEX [idx_binder_provider_origin_repo_org_ref_resolved_ref_timestamp]
                ON [binder] ([provider], [origin], [repo], [org], [ref], [resolved_ref], [timestamp]);
Powered by Datasette · Query took 26.794ms