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-08 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 |
---|---|---|---|---|---|---|---|---|---|
138609 | 138609 | Alamo | Alamo | 2022-09-08 | Contra Costa | 13 | 2292 | 14750 | |
138610 | 138610 | Antioch | Antioch | 2022-09-08 | Contra Costa | 13 | 34040 | 112520 | |
138611 | 138611 | Bay Point | Bay Point | 2022-09-08 | Contra Costa | 13 | 7774 | 22639 | |
138612 | 138612 | Bethel Island | Bethel Island | 2022-09-08 | Contra Costa | 13 | 358 | 2137 | |
138613 | 138613 | Brentwood | Brentwood | 2022-09-08 | Contra Costa | 13 | 17606 | 65118 | |
138614 | 138614 | Byron | Byron | 2022-09-08 | Contra Costa | 13 | 330 | 1325 | |
138615 | 138615 | Clayton | Clayton | 2022-09-08 | Contra Costa | 13 | 2005 | 11337 | |
138616 | 138616 | Concord | Concord | 2022-09-08 | Contra Costa | 13 | 28012 | 130143 | |
138617 | 138617 | Crockett | Crockett | 2022-09-08 | Contra Costa | 13 | 596 | 3044 | |
138618 | 138618 | Danville | Danville | 2022-09-08 | Contra Costa | 13 | 9140 | 43876 | |
138619 | 138619 | Diablo | Diablo | 2022-09-08 | Contra Costa | 13 | 148 | 818 | |
138620 | 138620 | Discovery Bay | Discovery Bay | 2022-09-08 | Contra Costa | 13 | 3240 | 13352 | |
138621 | 138621 | El Cerrito | El Cerrito | 2022-09-08 | Contra Costa | 13 | 4013 | 24953 | |
138622 | 138622 | Hercules | Hercules | 2022-09-08 | Contra Costa | 13 | 6083 | 25530 | |
138623 | 138623 | Kensington | Kensington | 2022-09-08 | Contra Costa | 13 | 521 | 5077 | |
138624 | 138624 | Knightsen | Knightsen | 2022-09-08 | Contra Costa | 13 | 100 | 1500 | |
138625 | 138625 | Lafayette | Lafayette | 2022-09-08 | Contra Costa | 13 | 4018 | 25604 | |
138626 | 138626 | Martinez | Martinez | 2022-09-08 | Contra Costa | 13 | 9688 | 37106 | |
138627 | 138627 | Moraga | Moraga | 2022-09-08 | Contra Costa | 13 | 2128 | 16946 | |
138628 | 138628 | Oakley | Oakley | 2022-09-08 | Contra Costa | 13 | 13018 | 42461 | |
138629 | 138629 | Orinda | Orinda | 2022-09-08 | Contra Costa | 13 | 2610 | 19009 | |
138630 | 138630 | Pacheco | Pacheco | 2022-09-08 | Contra Costa | 13 | 940 | 3685 | |
138631 | 138631 | Pinole | Pinole | 2022-09-08 | Contra Costa | 13 | 4600 | 19505 | |
138632 | 138632 | Pittsburg | Pittsburg | 2022-09-08 | Contra Costa | 13 | 21118 | 74321 | |
138633 | 138633 | Pleasant Hill | Pleasant Hill | 2022-09-08 | Contra Costa | 13 | 6473 | 34267 | |
138634 | 138634 | Richmond | Richmond | 2022-09-08 | Contra Costa | 13 | 37144 | 111217 | |
138635 | 138635 | Rodeo | Rodeo | 2022-09-08 | Contra Costa | 13 | 2403 | 8679 | |
138636 | 138636 | San Pablo | San Pablo | 2022-09-08 | Contra Costa | 13 | 15600 | 31413 | |
138637 | 138637 | San Ramon | San Ramon | 2022-09-08 | Contra Costa | 13 | 13934 | 83118 | |
138638 | 138638 | Walnut Creek | Walnut Creek | 2022-09-08 | Contra Costa | 13 | 14421 | 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 );