2 rows where origin = "" and provider = "Zenodo" sorted by spec

View and edit SQL

Suggested facets: timestamp (date)


  • Zenodo · 2


  • · 2
Link rowid timestamp version provider spec ▼ ref origin repo resolved_ref org
2646737 2020-09-24T20:24:00+00:00 4 Zenodo 10.22002/d1.1250   1250  
2605687 2020-09-25T08:16:00+00:00 4 Zenodo 10.5281/zenodo.4032875   4032876  

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 14.598ms