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

10 rows where project = "UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc=" and "updatedAt" is on date 2021-03-02

View and edit SQL

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

Link project ext createdAt name updatedAt size etag
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= md 2021-03-02T05:20:38.958000+00:00 BLN_README.md 2021-03-02T05:20:38.958000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= LICENSE 2021-03-02T05:20:21.861000+00:00 LICENSE 2021-03-02T05:20:21.861000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= md 2021-03-02T05:20:24.216000+00:00 NEW-YORK-DEATHS-METHODOLOGY.md 2021-03-02T05:20:24.216000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= md 2021-03-02T05:20:26.327000+00:00 PROBABLE-CASES-NOTE.md 2021-03-02T05:20:26.327000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= md 2021-03-02T05:20:28.416000+00:00 README.md 2021-03-02T05:20:28.416000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2021-03-02T05:20:41.414000+00:00 ny_times_covid_20210302.zip 2021-03-02T05:20:41.414000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= csv 2021-03-02T05:20:30.581000+00:00 us-counties-recent.csv 2021-03-02T05:20:30.581000+00:00 3974434 "6c85a49e8c709b21945894d55ada54fc"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= csv 2021-03-02T05:20:32.962000+00:00 us-counties.csv 2021-03-02T05:20:32.962000+00:00 43942710 "537756474c7a32035177b00a97ad3fbc"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= csv 2021-03-02T05:20:34.875000+00:00 us-states.csv 2021-03-02T05:20:34.875000+00:00 681378 "c0b232ab03443ffede40dcd5dc52d40c"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= csv 2021-03-02T05:20:36.951000+00:00 us.csv 2021-03-02T05:20:36.951000+00:00 9972 "2e6824fbb96bf9bc029d60aae551ba8d"

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