latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
110 rows where county = "San Diego" and "date" is on date 2020-04-24 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1218915 | 1218915 | 92155 | 92155: Coronado | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218916 | 1218916 | 92173 | 92173: San Ysidro | 2020-04-24 | San Diego | 73 | 83 | 27097 | |
1218917 | 1218917 | 92182 | 92182: San Diego | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218918 | 1218918 | 92536 | 92536: Aguanga | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218919 | 1218919 | 92672 | 92672: San Clemente | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218920 | 1218920 | 91901 | 91901: Alpine | 2020-04-24 | San Diego | 73 | 4 | 17985 | |
1218921 | 1218921 | 91902 | 91902: Bonita | 2020-04-24 | San Diego | 73 | 24 | 17631 | |
1218922 | 1218922 | 91905 | 91905: Boulevard | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218923 | 1218923 | 91906 | 91906: Campo | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218924 | 1218924 | 91910 | 91910: Chula Vista | 2020-04-24 | San Diego | 73 | 107 | 83834 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );