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

34 rows where project = "UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc=" and "updatedAt" is on date 2020-04-15

View and edit SQL

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

Link project ext createdAt name updatedAt size etag
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:27.560000+00:00 03_13_2020_covidtracking.zip 2020-04-15T00:12:27.560000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:29.929000+00:00 03_14_2020_covidtracking.zip 2020-04-15T00:12:29.929000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:31.971000+00:00 03_15_2020_covidtracking.zip 2020-04-15T00:12:31.971000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:34.010000+00:00 03_16_2020_covidtracking.zip 2020-04-15T00:12:34.010000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:36.164000+00:00 03_17_2020_covidtracking.zip 2020-04-15T00:12:36.164000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:38.145000+00:00 03_18_2020_covidtracking.zip 2020-04-15T00:12:38.145000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:39.891000+00:00 03_19_2020_covidtracking.zip 2020-04-15T00:12:39.891000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:41.828000+00:00 03_20_2020_covidtracking.zip 2020-04-15T00:12:41.828000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:20:46.717000+00:00 03_21_2020_covidtracking.zip 2020-04-15T00:20:46.717000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:45.080000+00:00 03_22_2020_covidtracking.zip 2020-04-15T00:12:45.080000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:48.064000+00:00 03_23_2020_covidtracking.zip 2020-04-15T00:12:48.064000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:21:22.281000+00:00 03_24_2020_covidtracking.zip 2020-04-15T00:21:22.281000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:50.945000+00:00 03_25_2020_covidtracking.zip 2020-04-15T00:12:50.945000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:54.005000+00:00 03_26_2020_covidtracking.zip 2020-04-15T00:12:54.005000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:56.613000+00:00 03_27_2020_covidtracking.zip 2020-04-15T00:12:56.613000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:12:59.471000+00:00 03_28_2020_covidtracking.zip 2020-04-15T00:12:59.471000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:02.622000+00:00 03_29_2020_covidtracking.zip 2020-04-15T00:13:02.622000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:08.493000+00:00 03_30_2020_covidtracking.zip 2020-04-15T00:13:08.493000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:11.900000+00:00 03_31_2020_covidtracking.zip 2020-04-15T00:13:11.900000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:14.821000+00:00 04_01_2020_covidtracking.zip 2020-04-15T00:13:14.821000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:18.090000+00:00 04_02_2020_covidtracking.zip 2020-04-15T00:13:18.090000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:21.468000+00:00 04_03_2020_covidtracking.zip 2020-04-15T00:13:21.468000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:24.630000+00:00 04_04_2020_covidtracking.zip 2020-04-15T00:13:24.630000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:27.654000+00:00 04_05_2020_covidtracking.zip 2020-04-15T00:13:27.654000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:30.668000+00:00 04_06_2020_covidtracking.zip 2020-04-15T00:13:30.668000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:33.670000+00:00 04_07_2020_covidtracking.zip 2020-04-15T00:13:33.670000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:36.529000+00:00 04_08_2020_covidtracking.zip 2020-04-15T00:13:36.529000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:39.507000+00:00 04_09_2020_covidtracking.zip 2020-04-15T00:13:39.507000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:41.999000+00:00 04_10_2020_covidtracking.zip 2020-04-15T00:13:41.999000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:44.138000+00:00 04_11_2020_covidtracking.zip 2020-04-15T00:13:44.138000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:46.278000+00:00 04_12_2020_covidtracking.zip 2020-04-15T00:13:46.278000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:48.579000+00:00 04_13_2020_covidtracking.zip 2020-04-15T00:13:48.579000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T00:13:52.274000+00:00 04_14_2020_covidtracking.zip 2020-04-15T00:13:52.274000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-15T23:15:15.447000+00:00 04_15_2020_covidtracking.zip 2020-04-15T23:15:15.447000+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])
);