latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
30 rows where county = "Contra Costa", "date" is on date 2021-10-09 and fips = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
562285 | 562285 | Alamo | Alamo | 2021-10-09 | Contra Costa | 13 | 719 | 14750 | |
562286 | 562286 | Antioch | Antioch | 2021-10-09 | Contra Costa | 13 | 14182 | 112520 | |
562287 | 562287 | Bay Point | Bay Point | 2021-10-09 | Contra Costa | 13 | 3719 | 22639 | |
562288 | 562288 | Bethel Island | Bethel Island | 2021-10-09 | Contra Costa | 13 | 160 | 2137 | |
562289 | 562289 | Brentwood | Brentwood | 2021-10-09 | Contra Costa | 13 | 6029 | 65118 | |
562290 | 562290 | Byron | Byron | 2021-10-09 | Contra Costa | 13 | 176 | 1325 | |
562291 | 562291 | Clayton | Clayton | 2021-10-09 | Contra Costa | 13 | 646 | 11337 | |
562292 | 562292 | Concord | Concord | 2021-10-09 | Contra Costa | 13 | 10928 | 130143 | |
562293 | 562293 | Crockett | Crockett | 2021-10-09 | Contra Costa | 13 | 216 | 3044 | |
562294 | 562294 | Danville | Danville | 2021-10-09 | Contra Costa | 13 | 2424 | 43876 | |
562295 | 562295 | Diablo | Diablo | 2021-10-09 | Contra Costa | 13 | 50 | 818 | |
562296 | 562296 | Discovery Bay | Discovery Bay | 2021-10-09 | Contra Costa | 13 | 1408 | 13352 | |
562297 | 562297 | El Cerrito | El Cerrito | 2021-10-09 | Contra Costa | 13 | 995 | 24953 | |
562298 | 562298 | Hercules | Hercules | 2021-10-09 | Contra Costa | 13 | 1835 | 25530 | |
562299 | 562299 | Kensington | Kensington | 2021-10-09 | Contra Costa | 13 | 91 | 5077 | |
562300 | 562300 | Knightsen | Knightsen | 2021-10-09 | Contra Costa | 13 | 34 | 1500 | |
562301 | 562301 | Lafayette | Lafayette | 2021-10-09 | Contra Costa | 13 | 945 | 25604 | |
562302 | 562302 | Martinez | Martinez | 2021-10-09 | Contra Costa | 13 | 3071 | 37106 | |
562303 | 562303 | Moraga | Moraga | 2021-10-09 | Contra Costa | 13 | 462 | 16946 | |
562304 | 562304 | Oakley | Oakley | 2021-10-09 | Contra Costa | 13 | 5107 | 42461 | |
562305 | 562305 | Orinda | Orinda | 2021-10-09 | Contra Costa | 13 | 571 | 19009 | |
562306 | 562306 | Pacheco | Pacheco | 2021-10-09 | Contra Costa | 13 | 323 | 3685 | |
562307 | 562307 | Pinole | Pinole | 2021-10-09 | Contra Costa | 13 | 1557 | 19505 | |
562308 | 562308 | Pittsburg | Pittsburg | 2021-10-09 | Contra Costa | 13 | 9317 | 74321 | |
562309 | 562309 | Pleasant Hill | Pleasant Hill | 2021-10-09 | Contra Costa | 13 | 1775 | 34267 | |
562310 | 562310 | Richmond | Richmond | 2021-10-09 | Contra Costa | 13 | 14771 | 111217 | |
562311 | 562311 | Rodeo | Rodeo | 2021-10-09 | Contra Costa | 13 | 858 | 8679 | |
562312 | 562312 | San Pablo | San Pablo | 2021-10-09 | Contra Costa | 13 | 6427 | 31413 | |
562313 | 562313 | San Ramon | San Ramon | 2021-10-09 | Contra Costa | 13 | 3118 | 83118 | |
562314 | 562314 | Walnut Creek | Walnut Creek | 2021-10-09 | Contra Costa | 13 | 4160 | 70860 |
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 );