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-06-05 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 |
---|---|---|---|---|---|---|---|---|
5449 | 5449 | Long Beach | Los Angeles | 37 | 2021-06-05 | 53437 | 941 | TRUE |
5450 | 5450 | Los Angeles | Los Angeles | 37 | 2021-06-05 | 1180183 | 23099 | |
5451 | 5451 | Pasadena | Los Angeles | 37 | 2021-06-05 | 11297 | 349 | 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 );