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 2022-09-24 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 |
---|---|---|---|---|---|---|---|---|---|
118401 | 118401 | Alamo | Alamo | 2022-09-24 | Contra Costa | 13 | 2313 | 14750 | |
118402 | 118402 | Antioch | Antioch | 2022-09-24 | Contra Costa | 13 | 34373 | 112520 | |
118403 | 118403 | Bay Point | Bay Point | 2022-09-24 | Contra Costa | 13 | 7857 | 22639 | |
118404 | 118404 | Bethel Island | Bethel Island | 2022-09-24 | Contra Costa | 13 | 360 | 2137 | |
118405 | 118405 | Brentwood | Brentwood | 2022-09-24 | Contra Costa | 13 | 17775 | 65118 | |
118406 | 118406 | Byron | Byron | 2022-09-24 | Contra Costa | 13 | 337 | 1325 | |
118407 | 118407 | Clayton | Clayton | 2022-09-24 | Contra Costa | 13 | 2023 | 11337 | |
118408 | 118408 | Concord | Concord | 2022-09-24 | Contra Costa | 13 | 28298 | 130143 | |
118409 | 118409 | Crockett | Crockett | 2022-09-24 | Contra Costa | 13 | 600 | 3044 | |
118410 | 118410 | Danville | Danville | 2022-09-24 | Contra Costa | 13 | 9206 | 43876 | |
118411 | 118411 | Diablo | Diablo | 2022-09-24 | Contra Costa | 13 | 149 | 818 | |
118412 | 118412 | Discovery Bay | Discovery Bay | 2022-09-24 | Contra Costa | 13 | 3257 | 13352 | |
118413 | 118413 | El Cerrito | El Cerrito | 2022-09-24 | Contra Costa | 13 | 4081 | 24953 | |
118414 | 118414 | Hercules | Hercules | 2022-09-24 | Contra Costa | 13 | 6144 | 25530 | |
118415 | 118415 | Kensington | Kensington | 2022-09-24 | Contra Costa | 13 | 526 | 5077 | |
118416 | 118416 | Knightsen | Knightsen | 2022-09-24 | Contra Costa | 13 | 103 | 1500 | |
118417 | 118417 | Lafayette | Lafayette | 2022-09-24 | Contra Costa | 13 | 4065 | 25604 | |
118418 | 118418 | Martinez | Martinez | 2022-09-24 | Contra Costa | 13 | 9776 | 37106 | |
118419 | 118419 | Moraga | Moraga | 2022-09-24 | Contra Costa | 13 | 2159 | 16946 | |
118420 | 118420 | Oakley | Oakley | 2022-09-24 | Contra Costa | 13 | 13098 | 42461 | |
118421 | 118421 | Orinda | Orinda | 2022-09-24 | Contra Costa | 13 | 2627 | 19009 | |
118422 | 118422 | Pacheco | Pacheco | 2022-09-24 | Contra Costa | 13 | 946 | 3685 | |
118423 | 118423 | Pinole | Pinole | 2022-09-24 | Contra Costa | 13 | 4661 | 19505 | |
118424 | 118424 | Pittsburg | Pittsburg | 2022-09-24 | Contra Costa | 13 | 21372 | 74321 | |
118425 | 118425 | Pleasant Hill | Pleasant Hill | 2022-09-24 | Contra Costa | 13 | 6553 | 34267 | |
118426 | 118426 | Richmond | Richmond | 2022-09-24 | Contra Costa | 13 | 37459 | 111217 | |
118427 | 118427 | Rodeo | Rodeo | 2022-09-24 | Contra Costa | 13 | 2423 | 8679 | |
118428 | 118428 | San Pablo | San Pablo | 2022-09-24 | Contra Costa | 13 | 15722 | 31413 | |
118429 | 118429 | San Ramon | San Ramon | 2022-09-24 | Contra Costa | 13 | 14066 | 83118 | |
118430 | 118430 | Walnut Creek | Walnut Creek | 2022-09-24 | Contra Costa | 13 | 14546 | 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 );