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", "date" is on date 2021-07-18 and fips = 37 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 |
---|---|---|---|---|---|---|---|---|
2826 | 2826 | Long Beach | Los Angeles | 37 | 2021-07-18 | 54395 | 948 | TRUE |
2827 | 2827 | Los Angeles | Los Angeles | 37 | 2021-07-18 | 1201958 | 23284 | |
2828 | 2828 | Pasadena | Los Angeles | 37 | 2021-07-18 | 11507 | 351 | 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 );