latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
3 rows where county = "Los Angeles" and "date" is on date 2021-04-18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
8377 | 8377 | Long Beach | Los Angeles | 37 | 2021-04-18 | 52659 | 928 | TRUE |
8378 | 8378 | Los Angeles | Los Angeles | 37 | 2021-04-18 | 1165148 | 22355 | |
8379 | 8379 | Pasadena | Los Angeles | 37 | 2021-04-18 | 11190 | 340 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );