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

4 rows where project = "UHJvamVjdDoyMjYzOTRiYy1kMmNhLTRjMGItYjcxMC1jMjdhZDJjMTNiOTU="

View and edit SQL

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

Link project ext createdAt name updatedAt size etag
AHA_Hospital_beds UHJvamVjdDoyMjYzOTRiYy1kMmNhLTRjMGItYjcxMC1jMjdhZDJjMTNiOTU= csv 2020-04-28T21:50:58.167000+00:00 CoronavirusHospitalCapacity_metros.csv 2020-04-28T21:50:58.167000+00:00 60534 "ae45bd74bea546183328f77f55107d50"
AHA_Hospital_beds UHJvamVjdDoyMjYzOTRiYy1kMmNhLTRjMGItYjcxMC1jMjdhZDJjMTNiOTU= csv 2020-03-15T18:21:12.640000+00:00 CoronavirusHospitalCapacity_states.csv 2020-03-15T18:21:12.640000+00:00 7252 "79f8d836e8682cd8efc5ba9513f83521"
AHA_Hospital_beds UHJvamVjdDoyMjYzOTRiYy1kMmNhLTRjMGItYjcxMC1jMjdhZDJjMTNiOTU= md 2020-04-28T21:50:55.831000+00:00 README.md 2020-04-28T21:50:55.831000+00:00    
AHA_Hospital_beds UHJvamVjdDoyMjYzOTRiYy1kMmNhLTRjMGItYjcxMC1jMjdhZDJjMTNiOTU= pdf 2020-04-28T21:50:57.560000+00:00 README.pdf 2020-04-28T21:50:57.560000+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])
);