files

Table actions

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

4 rows where "createdAt" is on date 2021-01-04 and project = "UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y="

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Link project ext createdAt name updatedAt size etag
UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y=,BLN_Mobility_Report_US_2020_12_29.csv Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-04T17:24:13.765000+00:00 BLN_Mobility_Report_US_2020_12_29.csv 2021-01-04T17:24:13.765000+00:00 78712217  
UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y=,BLN_Mobility_Report_nonUS_2020_12_29.csv Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-04T17:24:37.822000+00:00 BLN_Mobility_Report_nonUS_2020_12_29.csv 2021-01-04T17:24:37.822000+00:00 249740091  
UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y=,Google_Mobility_Report_2020_12_29.csv Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-04T17:24:41.881000+00:00 Google_Mobility_Report_2020_12_29.csv 2021-01-04T17:24:41.881000+00:00 273203110  
UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y=,Mobility_Report_2020_12_29.zip Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= zip 2021-01-04T17:24:11.545000+00:00 Mobility_Report_2020_12_29.zip 2021-01-04T17:24:11.545000+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])
);