files

Table actions

Data source: Big Local News · About: big-local-datasette

2 rows where project = "UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU=" and "updatedAt" is on date 2020-05-11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

Link project ext createdAt name updatedAt size etag
UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU=,Comparison of COVID-19 data - Source-OpenNews.pdf Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= pdf 2020-05-11T22:52:36.869000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:52:36.869000+00:00    
UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU=,jhu_covid_time_series_05_11_2020.zip Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-05-11T05:19:06.146000+00:00 jhu_covid_time_series_05_11_2020.zip 2020-05-11T05:19:06.146000+00:00    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "files" (
   [project] TEXT REFERENCES [projects]([id]),
   [ext] TEXT,
   [createdAt] TEXT,
   [name] TEXT,
   [updatedAt] TEXT,
   [size] INTEGER,
   [etag] TEXT,
   PRIMARY KEY ([project], [name])
);