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-03-27 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 |
---|---|---|---|---|---|---|---|---|---|
812381 | 812381 | Alamo | Alamo | 2021-03-27 | Contra Costa | 13 | 449 | 14750 | |
812382 | 812382 | Antioch | Antioch | 2021-03-27 | Contra Costa | 13 | 8989 | 112520 | |
812383 | 812383 | Bay Point | Bay Point | 2021-03-27 | Contra Costa | 13 | 2642 | 22639 | |
812384 | 812384 | Bethel Island | Bethel Island | 2021-03-27 | Contra Costa | 13 | 66 | 2137 | |
812385 | 812385 | Brentwood | Brentwood | 2021-03-27 | Contra Costa | 13 | 3564 | 65118 | |
812386 | 812386 | Byron | Byron | 2021-03-27 | Contra Costa | 13 | 97 | 1325 | |
812387 | 812387 | Clayton | Clayton | 2021-03-27 | Contra Costa | 13 | 391 | 11337 | |
812388 | 812388 | Concord | Concord | 2021-03-27 | Contra Costa | 13 | 7640 | 130143 | |
812389 | 812389 | Crockett | Crockett | 2021-03-27 | Contra Costa | 13 | 119 | 3044 | |
812390 | 812390 | Danville | Danville | 2021-03-27 | Contra Costa | 13 | 1530 | 43876 | |
812391 | 812391 | Diablo | Diablo | 2021-03-27 | Contra Costa | 13 | 33 | 818 | |
812392 | 812392 | Discovery Bay | Discovery Bay | 2021-03-27 | Contra Costa | 13 | 795 | 13352 | |
812393 | 812393 | El Cerrito | El Cerrito | 2021-03-27 | Contra Costa | 13 | 670 | 24953 | |
812394 | 812394 | Hercules | Hercules | 2021-03-27 | Contra Costa | 13 | 1190 | 25530 | |
812395 | 812395 | Kensington | Kensington | 2021-03-27 | Contra Costa | 13 | 44 | 5077 | |
812396 | 812396 | Knightsen | Knightsen | 2021-03-27 | Contra Costa | 13 | 22 | 1500 | |
812397 | 812397 | Lafayette | Lafayette | 2021-03-27 | Contra Costa | 13 | 581 | 25604 | |
812398 | 812398 | Martinez | Martinez | 2021-03-27 | Contra Costa | 13 | 1876 | 37106 | |
812399 | 812399 | Moraga | Moraga | 2021-03-27 | Contra Costa | 13 | 300 | 16946 | |
812400 | 812400 | Oakley | Oakley | 2021-03-27 | Contra Costa | 13 | 2965 | 42461 | |
812401 | 812401 | Orinda | Orinda | 2021-03-27 | Contra Costa | 13 | 396 | 19009 | |
812402 | 812402 | Pacheco | Pacheco | 2021-03-27 | Contra Costa | 13 | 225 | 3685 | |
812403 | 812403 | Pinole | Pinole | 2021-03-27 | Contra Costa | 13 | 1074 | 19505 | |
812404 | 812404 | Pittsburg | Pittsburg | 2021-03-27 | Contra Costa | 13 | 6492 | 74321 | |
812405 | 812405 | Pleasant Hill | Pleasant Hill | 2021-03-27 | Contra Costa | 13 | 1144 | 34267 | |
812406 | 812406 | Richmond | Richmond | 2021-03-27 | Contra Costa | 13 | 9863 | 111217 | |
812407 | 812407 | Rodeo | Rodeo | 2021-03-27 | Contra Costa | 13 | 552 | 8679 | |
812408 | 812408 | San Pablo | San Pablo | 2021-03-27 | Contra Costa | 13 | 5040 | 31413 | |
812409 | 812409 | San Ramon | San Ramon | 2021-03-27 | Contra Costa | 13 | 1946 | 83118 | |
812410 | 812410 | Walnut Creek | Walnut Creek | 2021-03-27 | Contra Costa | 13 | 2680 | 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 );