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-09-13 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 |
---|---|---|---|---|---|---|---|---|---|
595461 | 595461 | Alamo | Alamo | 2021-09-13 | Contra Costa | 13 | 680 | 14750 | |
595462 | 595462 | Antioch | Antioch | 2021-09-13 | Contra Costa | 13 | 13672 | 112520 | |
595463 | 595463 | Bay Point | Bay Point | 2021-09-13 | Contra Costa | 13 | 3587 | 22639 | |
595464 | 595464 | Bethel Island | Bethel Island | 2021-09-13 | Contra Costa | 13 | 144 | 2137 | |
595465 | 595465 | Brentwood | Brentwood | 2021-09-13 | Contra Costa | 13 | 5763 | 65118 | |
595466 | 595466 | Byron | Byron | 2021-09-13 | Contra Costa | 13 | 168 | 1325 | |
595467 | 595467 | Clayton | Clayton | 2021-09-13 | Contra Costa | 13 | 599 | 11337 | |
595468 | 595468 | Concord | Concord | 2021-09-13 | Contra Costa | 13 | 10473 | 130143 | |
595469 | 595469 | Crockett | Crockett | 2021-09-13 | Contra Costa | 13 | 207 | 3044 | |
595470 | 595470 | Danville | Danville | 2021-09-13 | Contra Costa | 13 | 2276 | 43876 | |
595471 | 595471 | Diablo | Diablo | 2021-09-13 | Contra Costa | 13 | 48 | 818 | |
595472 | 595472 | Discovery Bay | Discovery Bay | 2021-09-13 | Contra Costa | 13 | 1336 | 13352 | |
595473 | 595473 | El Cerrito | El Cerrito | 2021-09-13 | Contra Costa | 13 | 964 | 24953 | |
595474 | 595474 | Hercules | Hercules | 2021-09-13 | Contra Costa | 13 | 1764 | 25530 | |
595475 | 595475 | Kensington | Kensington | 2021-09-13 | Contra Costa | 13 | 85 | 5077 | |
595476 | 595476 | Knightsen | Knightsen | 2021-09-13 | Contra Costa | 13 | 33 | 1500 | |
595477 | 595477 | Lafayette | Lafayette | 2021-09-13 | Contra Costa | 13 | 887 | 25604 | |
595478 | 595478 | Martinez | Martinez | 2021-09-13 | Contra Costa | 13 | 2917 | 37106 | |
595479 | 595479 | Moraga | Moraga | 2021-09-13 | Contra Costa | 13 | 438 | 16946 | |
595480 | 595480 | Oakley | Oakley | 2021-09-13 | Contra Costa | 13 | 4838 | 42461 | |
595481 | 595481 | Orinda | Orinda | 2021-09-13 | Contra Costa | 13 | 550 | 19009 | |
595482 | 595482 | Pacheco | Pacheco | 2021-09-13 | Contra Costa | 13 | 305 | 3685 | |
595483 | 595483 | Pinole | Pinole | 2021-09-13 | Contra Costa | 13 | 1509 | 19505 | |
595484 | 595484 | Pittsburg | Pittsburg | 2021-09-13 | Contra Costa | 13 | 8959 | 74321 | |
595485 | 595485 | Pleasant Hill | Pleasant Hill | 2021-09-13 | Contra Costa | 13 | 1671 | 34267 | |
595486 | 595486 | Richmond | Richmond | 2021-09-13 | Contra Costa | 13 | 14415 | 111217 | |
595487 | 595487 | Rodeo | Rodeo | 2021-09-13 | Contra Costa | 13 | 800 | 8679 | |
595488 | 595488 | San Pablo | San Pablo | 2021-09-13 | Contra Costa | 13 | 6307 | 31413 | |
595489 | 595489 | San Ramon | San Ramon | 2021-09-13 | Contra Costa | 13 | 2953 | 83118 | |
595490 | 595490 | Walnut Creek | Walnut Creek | 2021-09-13 | Contra Costa | 13 | 3962 | 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 );