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 2022-07-21 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 |
---|---|---|---|---|---|---|---|---|---|
200496 | 200496 | Alamo | Alamo | 2022-07-21 | Contra Costa | 13 | 1958 | 14750 | |
200497 | 200497 | Antioch | Antioch | 2022-07-21 | Contra Costa | 13 | 30115 | 112520 | |
200498 | 200498 | Bay Point | Bay Point | 2022-07-21 | Contra Costa | 13 | 7138 | 22639 | |
200499 | 200499 | Bethel Island | Bethel Island | 2022-07-21 | Contra Costa | 13 | 314 | 2137 | |
200500 | 200500 | Brentwood | Brentwood | 2022-07-21 | Contra Costa | 13 | 14011 | 65118 | |
200501 | 200501 | Byron | Byron | 2022-07-21 | Contra Costa | 13 | 292 | 1325 | |
200502 | 200502 | Clayton | Clayton | 2022-07-21 | Contra Costa | 13 | 1786 | 11337 | |
200503 | 200503 | Concord | Concord | 2022-07-21 | Contra Costa | 13 | 25346 | 130143 | |
200504 | 200504 | Crockett | Crockett | 2022-07-21 | Contra Costa | 13 | 546 | 3044 | |
200505 | 200505 | Danville | Danville | 2022-07-21 | Contra Costa | 13 | 7568 | 43876 | |
200506 | 200506 | Diablo | Diablo | 2022-07-21 | Contra Costa | 13 | 130 | 818 | |
200507 | 200507 | Discovery Bay | Discovery Bay | 2022-07-21 | Contra Costa | 13 | 2835 | 13352 | |
200508 | 200508 | El Cerrito | El Cerrito | 2022-07-21 | Contra Costa | 13 | 3465 | 24953 | |
200509 | 200509 | Hercules | Hercules | 2022-07-21 | Contra Costa | 13 | 5328 | 25530 | |
200510 | 200510 | Kensington | Kensington | 2022-07-21 | Contra Costa | 13 | 441 | 5077 | |
200511 | 200511 | Knightsen | Knightsen | 2022-07-21 | Contra Costa | 13 | 90 | 1500 | |
200512 | 200512 | Lafayette | Lafayette | 2022-07-21 | Contra Costa | 13 | 3242 | 25604 | |
200513 | 200513 | Martinez | Martinez | 2022-07-21 | Contra Costa | 13 | 8182 | 37106 | |
200514 | 200514 | Moraga | Moraga | 2022-07-21 | Contra Costa | 13 | 1747 | 16946 | |
200515 | 200515 | Oakley | Oakley | 2022-07-21 | Contra Costa | 13 | 11400 | 42461 | |
200516 | 200516 | Orinda | Orinda | 2022-07-21 | Contra Costa | 13 | 2193 | 19009 | |
200517 | 200517 | Pacheco | Pacheco | 2022-07-21 | Contra Costa | 13 | 812 | 3685 | |
200518 | 200518 | Pinole | Pinole | 2022-07-21 | Contra Costa | 13 | 4071 | 19505 | |
200519 | 200519 | Pittsburg | Pittsburg | 2022-07-21 | Contra Costa | 13 | 19336 | 74321 | |
200520 | 200520 | Pleasant Hill | Pleasant Hill | 2022-07-21 | Contra Costa | 13 | 5700 | 34267 | |
200521 | 200521 | Richmond | Richmond | 2022-07-21 | Contra Costa | 13 | 32787 | 111217 | |
200522 | 200522 | Rodeo | Rodeo | 2022-07-21 | Contra Costa | 13 | 2213 | 8679 | |
200523 | 200523 | San Pablo | San Pablo | 2022-07-21 | Contra Costa | 13 | 13833 | 31413 | |
200524 | 200524 | San Ramon | San Ramon | 2022-07-21 | Contra Costa | 13 | 11743 | 83118 | |
200525 | 200525 | Walnut Creek | Walnut Creek | 2022-07-21 | Contra Costa | 13 | 12657 | 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 );