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 2021-09-17 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 |
---|---|---|---|---|---|---|---|---|---|
590357 | 590357 | Alamo | Alamo | 2021-09-17 | Contra Costa | 13 | 686 | 14750 | |
590358 | 590358 | Antioch | Antioch | 2021-09-17 | Contra Costa | 13 | 13794 | 112520 | |
590359 | 590359 | Bay Point | Bay Point | 2021-09-17 | Contra Costa | 13 | 3610 | 22639 | |
590360 | 590360 | Bethel Island | Bethel Island | 2021-09-17 | Contra Costa | 13 | 145 | 2137 | |
590361 | 590361 | Brentwood | Brentwood | 2021-09-17 | Contra Costa | 13 | 5813 | 65118 | |
590362 | 590362 | Byron | Byron | 2021-09-17 | Contra Costa | 13 | 168 | 1325 | |
590363 | 590363 | Clayton | Clayton | 2021-09-17 | Contra Costa | 13 | 612 | 11337 | |
590364 | 590364 | Concord | Concord | 2021-09-17 | Contra Costa | 13 | 10562 | 130143 | |
590365 | 590365 | Crockett | Crockett | 2021-09-17 | Contra Costa | 13 | 210 | 3044 | |
590366 | 590366 | Danville | Danville | 2021-09-17 | Contra Costa | 13 | 2305 | 43876 | |
590367 | 590367 | Diablo | Diablo | 2021-09-17 | Contra Costa | 13 | 48 | 818 | |
590368 | 590368 | Discovery Bay | Discovery Bay | 2021-09-17 | Contra Costa | 13 | 1351 | 13352 | |
590369 | 590369 | El Cerrito | El Cerrito | 2021-09-17 | Contra Costa | 13 | 971 | 24953 | |
590370 | 590370 | Hercules | Hercules | 2021-09-17 | Contra Costa | 13 | 1775 | 25530 | |
590371 | 590371 | Kensington | Kensington | 2021-09-17 | Contra Costa | 13 | 86 | 5077 | |
590372 | 590372 | Knightsen | Knightsen | 2021-09-17 | Contra Costa | 13 | 34 | 1500 | |
590373 | 590373 | Lafayette | Lafayette | 2021-09-17 | Contra Costa | 13 | 904 | 25604 | |
590374 | 590374 | Martinez | Martinez | 2021-09-17 | Contra Costa | 13 | 2953 | 37106 | |
590375 | 590375 | Moraga | Moraga | 2021-09-17 | Contra Costa | 13 | 447 | 16946 | |
590376 | 590376 | Oakley | Oakley | 2021-09-17 | Contra Costa | 13 | 4895 | 42461 | |
590377 | 590377 | Orinda | Orinda | 2021-09-17 | Contra Costa | 13 | 557 | 19009 | |
590378 | 590378 | Pacheco | Pacheco | 2021-09-17 | Contra Costa | 13 | 312 | 3685 | |
590379 | 590379 | Pinole | Pinole | 2021-09-17 | Contra Costa | 13 | 1533 | 19505 | |
590380 | 590380 | Pittsburg | Pittsburg | 2021-09-17 | Contra Costa | 13 | 9058 | 74321 | |
590381 | 590381 | Pleasant Hill | Pleasant Hill | 2021-09-17 | Contra Costa | 13 | 1693 | 34267 | |
590382 | 590382 | Richmond | Richmond | 2021-09-17 | Contra Costa | 13 | 14490 | 111217 | |
590383 | 590383 | Rodeo | Rodeo | 2021-09-17 | Contra Costa | 13 | 812 | 8679 | |
590384 | 590384 | San Pablo | San Pablo | 2021-09-17 | Contra Costa | 13 | 6331 | 31413 | |
590385 | 590385 | San Ramon | San Ramon | 2021-09-17 | Contra Costa | 13 | 2990 | 83118 | |
590386 | 590386 | Walnut Creek | Walnut Creek | 2021-09-17 | Contra Costa | 13 | 4009 | 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 );