latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
30 rows where "date" is on date 2022-11-23 and fips = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 13 · 30 ✖
county 1
- Contra Costa 30
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
43357 | 43357 | Alamo | Alamo | 2022-11-23 | Contra Costa | 13 | 2376 | 14750 | |
43358 | 43358 | Antioch | Antioch | 2022-11-23 | Contra Costa | 13 | 35389 | 112520 | |
43359 | 43359 | Bay Point | Bay Point | 2022-11-23 | Contra Costa | 13 | 8034 | 22639 | |
43360 | 43360 | Bethel Island | Bethel Island | 2022-11-23 | Contra Costa | 13 | 372 | 2137 | |
43361 | 43361 | Brentwood | Brentwood | 2022-11-23 | Contra Costa | 13 | 18259 | 65118 | |
43362 | 43362 | Byron | Byron | 2022-11-23 | Contra Costa | 13 | 345 | 1325 | |
43363 | 43363 | Clayton | Clayton | 2022-11-23 | Contra Costa | 13 | 2079 | 11337 | |
43364 | 43364 | Concord | Concord | 2022-11-23 | Contra Costa | 13 | 29158 | 130143 | |
43365 | 43365 | Crockett | Crockett | 2022-11-23 | Contra Costa | 13 | 627 | 3044 | |
43366 | 43366 | Danville | Danville | 2022-11-23 | Contra Costa | 13 | 9435 | 43876 | |
43367 | 43367 | Diablo | Diablo | 2022-11-23 | Contra Costa | 13 | 152 | 818 | |
43368 | 43368 | Discovery Bay | Discovery Bay | 2022-11-23 | Contra Costa | 13 | 3326 | 13352 | |
43369 | 43369 | El Cerrito | El Cerrito | 2022-11-23 | Contra Costa | 13 | 4299 | 24953 | |
43370 | 43370 | Hercules | Hercules | 2022-11-23 | Contra Costa | 13 | 6332 | 25530 | |
43371 | 43371 | Kensington | Kensington | 2022-11-23 | Contra Costa | 13 | 563 | 5077 | |
43372 | 43372 | Knightsen | Knightsen | 2022-11-23 | Contra Costa | 13 | 105 | 1500 | |
43373 | 43373 | Lafayette | Lafayette | 2022-11-23 | Contra Costa | 13 | 4201 | 25604 | |
43374 | 43374 | Martinez | Martinez | 2022-11-23 | Contra Costa | 13 | 10112 | 37106 | |
43375 | 43375 | Moraga | Moraga | 2022-11-23 | Contra Costa | 13 | 2231 | 16946 | |
43376 | 43376 | Oakley | Oakley | 2022-11-23 | Contra Costa | 13 | 13408 | 42461 | |
43377 | 43377 | Orinda | Orinda | 2022-11-23 | Contra Costa | 13 | 2720 | 19009 | |
43378 | 43378 | Pacheco | Pacheco | 2022-11-23 | Contra Costa | 13 | 979 | 3685 | |
43379 | 43379 | Pinole | Pinole | 2022-11-23 | Contra Costa | 13 | 4820 | 19505 | |
43380 | 43380 | Pittsburg | Pittsburg | 2022-11-23 | Contra Costa | 13 | 22006 | 74321 | |
43381 | 43381 | Pleasant Hill | Pleasant Hill | 2022-11-23 | Contra Costa | 13 | 6768 | 34267 | |
43382 | 43382 | Richmond | Richmond | 2022-11-23 | Contra Costa | 13 | 38398 | 111217 | |
43383 | 43383 | Rodeo | Rodeo | 2022-11-23 | Contra Costa | 13 | 2489 | 8679 | |
43384 | 43384 | San Pablo | San Pablo | 2022-11-23 | Contra Costa | 13 | 16109 | 31413 | |
43385 | 43385 | San Ramon | San Ramon | 2022-11-23 | Contra Costa | 13 | 14491 | 83118 | |
43386 | 43386 | Walnut Creek | Walnut Creek | 2022-11-23 | Contra Costa | 13 | 15035 | 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 );