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

12 rows where "createdAt" is on date 2021-01-09

View and edit SQL

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

createdAt (date)

  • 2021-01-09 · 12
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2021-01-09T05:30:46.746000+00:00 jhu_covid_time_series_20210109.zip 2021-01-09T05:30:46.746000+00:00    
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-09T01:29:20.999000+00:00 BLN_Mobility_Report_US_2021_01_05.csv 2021-01-09T01:29:20.999000+00:00 80544648  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-09T01:29:40.002000+00:00 BLN_Mobility_Report_nonUS_2021_01_05.csv 2021-01-09T01:29:40.002000+00:00 255766297  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-09T01:29:41.295000+00:00 Google_Mobility_Report_2021_01_05.csv 2021-01-09T01:29:41.295000+00:00 279689396  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= zip 2021-01-09T01:29:18.770000+00:00 Mobility_Report_2021_01_05.zip 2021-01-09T01:29:18.770000+00:00    
us_capitol_police_reports UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk= csv 2021-01-09T00:48:46.725000+00:00 capitol_arrests_012220-010521.csv 2021-01-09T00:48:46.725000+00:00 192651 "c442a933b7787a8008a4b1345b5f0b00"
us_capitol_police_reports UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk= xlsx 2021-01-09T00:48:46.659000+00:00 capitol_arrests_012220-010521.xlsx 2021-01-09T00:48:46.659000+00:00    
us_capitol_police_reports UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk= Rproj 2021-01-09T00:48:46.659000+00:00 capitol_police.Rproj 2021-01-09T00:48:46.659000+00:00    
us_capitol_police_reports UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk= MD 2021-01-09T00:48:46.662000+00:00 readme.MD 2021-01-09T00:48:46.662000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2021-01-09T05:16:32.233000+00:00 covidtracking_20210109.zip 2021-01-09T05:16:32.233000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2021-01-09T00:06:06.510000+00:00 covid_usafacts_2021_01_08.zip 2021-01-09T00:06:06.510000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2021-01-09T05:20:37.514000+00:00 ny_times_covid_20210109.zip 2021-01-09T05:20:37.514000+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])
);