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-06-16 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 |
---|---|---|---|---|---|---|---|---|---|
244701 | 244701 | Alamo | Alamo | 2022-06-16 | Contra Costa | 13 | 1814 | 14750 | |
244702 | 244702 | Antioch | Antioch | 2022-06-16 | Contra Costa | 13 | 28210 | 112520 | |
244703 | 244703 | Bay Point | Bay Point | 2022-06-16 | Contra Costa | 13 | 6714 | 22639 | |
244704 | 244704 | Bethel Island | Bethel Island | 2022-06-16 | Contra Costa | 13 | 293 | 2137 | |
244705 | 244705 | Brentwood | Brentwood | 2022-06-16 | Contra Costa | 13 | 12991 | 65118 | |
244706 | 244706 | Byron | Byron | 2022-06-16 | Contra Costa | 13 | 269 | 1325 | |
244707 | 244707 | Clayton | Clayton | 2022-06-16 | Contra Costa | 13 | 1655 | 11337 | |
244708 | 244708 | Concord | Concord | 2022-06-16 | Contra Costa | 13 | 23440 | 130143 | |
244709 | 244709 | Crockett | Crockett | 2022-06-16 | Contra Costa | 13 | 523 | 3044 | |
244710 | 244710 | Danville | Danville | 2022-06-16 | Contra Costa | 13 | 6945 | 43876 | |
244711 | 244711 | Diablo | Diablo | 2022-06-16 | Contra Costa | 13 | 122 | 818 | |
244712 | 244712 | Discovery Bay | Discovery Bay | 2022-06-16 | Contra Costa | 13 | 2651 | 13352 | |
244713 | 244713 | El Cerrito | El Cerrito | 2022-06-16 | Contra Costa | 13 | 3133 | 24953 | |
244714 | 244714 | Hercules | Hercules | 2022-06-16 | Contra Costa | 13 | 4840 | 25530 | |
244715 | 244715 | Kensington | Kensington | 2022-06-16 | Contra Costa | 13 | 389 | 5077 | |
244716 | 244716 | Knightsen | Knightsen | 2022-06-16 | Contra Costa | 13 | 82 | 1500 | |
244717 | 244717 | Lafayette | Lafayette | 2022-06-16 | Contra Costa | 13 | 2940 | 25604 | |
244718 | 244718 | Martinez | Martinez | 2022-06-16 | Contra Costa | 13 | 7482 | 37106 | |
244719 | 244719 | Moraga | Moraga | 2022-06-16 | Contra Costa | 13 | 1584 | 16946 | |
244720 | 244720 | Oakley | Oakley | 2022-06-16 | Contra Costa | 13 | 10668 | 42461 | |
244721 | 244721 | Orinda | Orinda | 2022-06-16 | Contra Costa | 13 | 2012 | 19009 | |
244722 | 244722 | Pacheco | Pacheco | 2022-06-16 | Contra Costa | 13 | 764 | 3685 | |
244723 | 244723 | Pinole | Pinole | 2022-06-16 | Contra Costa | 13 | 3715 | 19505 | |
244724 | 244724 | Pittsburg | Pittsburg | 2022-06-16 | Contra Costa | 13 | 18193 | 74321 | |
244725 | 244725 | Pleasant Hill | Pleasant Hill | 2022-06-16 | Contra Costa | 13 | 5157 | 34267 | |
244726 | 244726 | Richmond | Richmond | 2022-06-16 | Contra Costa | 13 | 30904 | 111217 | |
244727 | 244727 | Rodeo | Rodeo | 2022-06-16 | Contra Costa | 13 | 2051 | 8679 | |
244728 | 244728 | San Pablo | San Pablo | 2022-06-16 | Contra Costa | 13 | 13101 | 31413 | |
244729 | 244729 | San Ramon | San Ramon | 2022-06-16 | Contra Costa | 13 | 10493 | 83118 | |
244730 | 244730 | Walnut Creek | Walnut Creek | 2022-06-16 | Contra Costa | 13 | 11521 | 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 );