files

Table actions

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

2 rows where ext = "csv" and project = "UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ="

✎ 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
UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ=,SVI2018_US.csv COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= csv 2020-03-18T23:40:26.279000+00:00 SVI2018_US.csv 2020-03-18T23:40:26.279000+00:00 44704458 "34dc9bc76fc77f227af4d4ffe4e69c15"
UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ=,SVI2018_US_COUNTY.csv COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= csv 2020-03-18T23:40:02.307000+00:00 SVI2018_US_COUNTY.csv 2020-03-18T23:40:02.307000+00:00 1885419 "01ce905c04ddf3b7bff299f0dbc05543"

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])
);