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-01 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 |
---|---|---|---|---|---|---|---|---|---|
572493 | 572493 | Alamo | Alamo | 2021-10-01 | Contra Costa | 13 | 705 | 14750 | |
572494 | 572494 | Antioch | Antioch | 2021-10-01 | Contra Costa | 13 | 14000 | 112520 | |
572495 | 572495 | Bay Point | Bay Point | 2021-10-01 | Contra Costa | 13 | 3654 | 22639 | |
572496 | 572496 | Bethel Island | Bethel Island | 2021-10-01 | Contra Costa | 13 | 152 | 2137 | |
572497 | 572497 | Brentwood | Brentwood | 2021-10-01 | Contra Costa | 13 | 5935 | 65118 | |
572498 | 572498 | Byron | Byron | 2021-10-01 | Contra Costa | 13 | 169 | 1325 | |
572499 | 572499 | Clayton | Clayton | 2021-10-01 | Contra Costa | 13 | 638 | 11337 | |
572500 | 572500 | Concord | Concord | 2021-10-01 | Contra Costa | 13 | 10761 | 130143 | |
572501 | 572501 | Crockett | Crockett | 2021-10-01 | Contra Costa | 13 | 213 | 3044 | |
572502 | 572502 | Danville | Danville | 2021-10-01 | Contra Costa | 13 | 2367 | 43876 | |
572503 | 572503 | Diablo | Diablo | 2021-10-01 | Contra Costa | 13 | 48 | 818 | |
572504 | 572504 | Discovery Bay | Discovery Bay | 2021-10-01 | Contra Costa | 13 | 1384 | 13352 | |
572505 | 572505 | El Cerrito | El Cerrito | 2021-10-01 | Contra Costa | 13 | 984 | 24953 | |
572506 | 572506 | Hercules | Hercules | 2021-10-01 | Contra Costa | 13 | 1813 | 25530 | |
572507 | 572507 | Kensington | Kensington | 2021-10-01 | Contra Costa | 13 | 90 | 5077 | |
572508 | 572508 | Knightsen | Knightsen | 2021-10-01 | Contra Costa | 13 | 34 | 1500 | |
572509 | 572509 | Lafayette | Lafayette | 2021-10-01 | Contra Costa | 13 | 923 | 25604 | |
572510 | 572510 | Martinez | Martinez | 2021-10-01 | Contra Costa | 13 | 3012 | 37106 | |
572511 | 572511 | Moraga | Moraga | 2021-10-01 | Contra Costa | 13 | 454 | 16946 | |
572512 | 572512 | Oakley | Oakley | 2021-10-01 | Contra Costa | 13 | 5027 | 42461 | |
572513 | 572513 | Orinda | Orinda | 2021-10-01 | Contra Costa | 13 | 565 | 19009 | |
572514 | 572514 | Pacheco | Pacheco | 2021-10-01 | Contra Costa | 13 | 317 | 3685 | |
572515 | 572515 | Pinole | Pinole | 2021-10-01 | Contra Costa | 13 | 1550 | 19505 | |
572516 | 572516 | Pittsburg | Pittsburg | 2021-10-01 | Contra Costa | 13 | 9172 | 74321 | |
572517 | 572517 | Pleasant Hill | Pleasant Hill | 2021-10-01 | Contra Costa | 13 | 1734 | 34267 | |
572518 | 572518 | Richmond | Richmond | 2021-10-01 | Contra Costa | 13 | 14625 | 111217 | |
572519 | 572519 | Rodeo | Rodeo | 2021-10-01 | Contra Costa | 13 | 834 | 8679 | |
572520 | 572520 | San Pablo | San Pablo | 2021-10-01 | Contra Costa | 13 | 6382 | 31413 | |
572521 | 572521 | San Ramon | San Ramon | 2021-10-01 | Contra Costa | 13 | 3052 | 83118 | |
572522 | 572522 | Walnut Creek | Walnut Creek | 2021-10-01 | Contra Costa | 13 | 4100 | 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 );