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-06 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 |
---|---|---|---|---|---|---|---|---|---|
604393 | 604393 | Alamo | Alamo | 2021-09-06 | Contra Costa | 13 | 667 | 14750 | |
604394 | 604394 | Antioch | Antioch | 2021-09-06 | Contra Costa | 13 | 13410 | 112520 | |
604395 | 604395 | Bay Point | Bay Point | 2021-09-06 | Contra Costa | 13 | 3540 | 22639 | |
604396 | 604396 | Bethel Island | Bethel Island | 2021-09-06 | Contra Costa | 13 | 135 | 2137 | |
604397 | 604397 | Brentwood | Brentwood | 2021-09-06 | Contra Costa | 13 | 5640 | 65118 | |
604398 | 604398 | Byron | Byron | 2021-09-06 | Contra Costa | 13 | 163 | 1325 | |
604399 | 604399 | Clayton | Clayton | 2021-09-06 | Contra Costa | 13 | 587 | 11337 | |
604400 | 604400 | Concord | Concord | 2021-09-06 | Contra Costa | 13 | 10295 | 130143 | |
604401 | 604401 | Crockett | Crockett | 2021-09-06 | Contra Costa | 13 | 200 | 3044 | |
604402 | 604402 | Danville | Danville | 2021-09-06 | Contra Costa | 13 | 2230 | 43876 | |
604403 | 604403 | Diablo | Diablo | 2021-09-06 | Contra Costa | 13 | 48 | 818 | |
604404 | 604404 | Discovery Bay | Discovery Bay | 2021-09-06 | Contra Costa | 13 | 1303 | 13352 | |
604405 | 604405 | El Cerrito | El Cerrito | 2021-09-06 | Contra Costa | 13 | 957 | 24953 | |
604406 | 604406 | Hercules | Hercules | 2021-09-06 | Contra Costa | 13 | 1735 | 25530 | |
604407 | 604407 | Kensington | Kensington | 2021-09-06 | Contra Costa | 13 | 84 | 5077 | |
604408 | 604408 | Knightsen | Knightsen | 2021-09-06 | Contra Costa | 13 | 32 | 1500 | |
604409 | 604409 | Lafayette | Lafayette | 2021-09-06 | Contra Costa | 13 | 866 | 25604 | |
604410 | 604410 | Martinez | Martinez | 2021-09-06 | Contra Costa | 13 | 2814 | 37106 | |
604411 | 604411 | Moraga | Moraga | 2021-09-06 | Contra Costa | 13 | 430 | 16946 | |
604412 | 604412 | Oakley | Oakley | 2021-09-06 | Contra Costa | 13 | 4698 | 42461 | |
604413 | 604413 | Orinda | Orinda | 2021-09-06 | Contra Costa | 13 | 542 | 19009 | |
604414 | 604414 | Pacheco | Pacheco | 2021-09-06 | Contra Costa | 13 | 303 | 3685 | |
604415 | 604415 | Pinole | Pinole | 2021-09-06 | Contra Costa | 13 | 1482 | 19505 | |
604416 | 604416 | Pittsburg | Pittsburg | 2021-09-06 | Contra Costa | 13 | 8819 | 74321 | |
604417 | 604417 | Pleasant Hill | Pleasant Hill | 2021-09-06 | Contra Costa | 13 | 1629 | 34267 | |
604418 | 604418 | Richmond | Richmond | 2021-09-06 | Contra Costa | 13 | 14239 | 111217 | |
604419 | 604419 | Rodeo | Rodeo | 2021-09-06 | Contra Costa | 13 | 789 | 8679 | |
604420 | 604420 | San Pablo | San Pablo | 2021-09-06 | Contra Costa | 13 | 6217 | 31413 | |
604421 | 604421 | San Ramon | San Ramon | 2021-09-06 | Contra Costa | 13 | 2888 | 83118 | |
604422 | 604422 | Walnut Creek | Walnut Creek | 2021-09-06 | Contra Costa | 13 | 3888 | 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 );