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-07-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 |
---|---|---|---|---|---|---|---|---|---|
670745 | 670745 | Alamo | Alamo | 2021-07-16 | Contra Costa | 13 | 512 | 14750 | |
670746 | 670746 | Antioch | Antioch | 2021-07-16 | Contra Costa | 13 | 10308 | 112520 | |
670747 | 670747 | Bay Point | Bay Point | 2021-07-16 | Contra Costa | 13 | 2885 | 22639 | |
670748 | 670748 | Bethel Island | Bethel Island | 2021-07-16 | Contra Costa | 13 | 85 | 2137 | |
670749 | 670749 | Brentwood | Brentwood | 2021-07-16 | Contra Costa | 13 | 4083 | 65118 | |
670750 | 670750 | Byron | Byron | 2021-07-16 | Contra Costa | 13 | 113 | 1325 | |
670751 | 670751 | Clayton | Clayton | 2021-07-16 | Contra Costa | 13 | 449 | 11337 | |
670752 | 670752 | Concord | Concord | 2021-07-16 | Contra Costa | 13 | 8429 | 130143 | |
670753 | 670753 | Crockett | Crockett | 2021-07-16 | Contra Costa | 13 | 135 | 3044 | |
670754 | 670754 | Danville | Danville | 2021-07-16 | Contra Costa | 13 | 1728 | 43876 | |
670755 | 670755 | Diablo | Diablo | 2021-07-16 | Contra Costa | 13 | 39 | 818 | |
670756 | 670756 | Discovery Bay | Discovery Bay | 2021-07-16 | Contra Costa | 13 | 930 | 13352 | |
670757 | 670757 | El Cerrito | El Cerrito | 2021-07-16 | Contra Costa | 13 | 742 | 24953 | |
670758 | 670758 | Hercules | Hercules | 2021-07-16 | Contra Costa | 13 | 1347 | 25530 | |
670759 | 670759 | Kensington | Kensington | 2021-07-16 | Contra Costa | 13 | 49 | 5077 | |
670760 | 670760 | Knightsen | Knightsen | 2021-07-16 | Contra Costa | 13 | 26 | 1500 | |
670761 | 670761 | Lafayette | Lafayette | 2021-07-16 | Contra Costa | 13 | 652 | 25604 | |
670762 | 670762 | Martinez | Martinez | 2021-07-16 | Contra Costa | 13 | 2064 | 37106 | |
670763 | 670763 | Moraga | Moraga | 2021-07-16 | Contra Costa | 13 | 347 | 16946 | |
670764 | 670764 | Oakley | Oakley | 2021-07-16 | Contra Costa | 13 | 3480 | 42461 | |
670765 | 670765 | Orinda | Orinda | 2021-07-16 | Contra Costa | 13 | 428 | 19009 | |
670766 | 670766 | Pacheco | Pacheco | 2021-07-16 | Contra Costa | 13 | 254 | 3685 | |
670767 | 670767 | Pinole | Pinole | 2021-07-16 | Contra Costa | 13 | 1192 | 19505 | |
670768 | 670768 | Pittsburg | Pittsburg | 2021-07-16 | Contra Costa | 13 | 7251 | 74321 | |
670769 | 670769 | Pleasant Hill | Pleasant Hill | 2021-07-16 | Contra Costa | 13 | 1274 | 34267 | |
670770 | 670770 | Richmond | Richmond | 2021-07-16 | Contra Costa | 13 | 12112 | 111217 | |
670771 | 670771 | Rodeo | Rodeo | 2021-07-16 | Contra Costa | 13 | 628 | 8679 | |
670772 | 670772 | San Pablo | San Pablo | 2021-07-16 | Contra Costa | 13 | 5460 | 31413 | |
670773 | 670773 | San Ramon | San Ramon | 2021-07-16 | Contra Costa | 13 | 2209 | 83118 | |
670774 | 670774 | Walnut Creek | Walnut Creek | 2021-07-16 | Contra Costa | 13 | 3005 | 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 );