latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
30 rows where "date" is on date 2021-02-20 and fips = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 13 · 30 ✖
county 1
- Contra Costa 30
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
857041 | 857041 | Alamo | Alamo | 2021-02-20 | Contra Costa | 13 | 422 | 14750 | |
857042 | 857042 | Antioch | Antioch | 2021-02-20 | Contra Costa | 13 | 8496 | 112520 | |
857043 | 857043 | Bay Point | Bay Point | 2021-02-20 | Contra Costa | 13 | 2535 | 22639 | |
857044 | 857044 | Bethel Island | Bethel Island | 2021-02-20 | Contra Costa | 13 | 63 | 2137 | |
857045 | 857045 | Brentwood | Brentwood | 2021-02-20 | Contra Costa | 13 | 3315 | 65118 | |
857046 | 857046 | Byron | Byron | 2021-02-20 | Contra Costa | 13 | 95 | 1325 | |
857047 | 857047 | Clayton | Clayton | 2021-02-20 | Contra Costa | 13 | 374 | 11337 | |
857048 | 857048 | Concord | Concord | 2021-02-20 | Contra Costa | 13 | 7244 | 130143 | |
857049 | 857049 | Crockett | Crockett | 2021-02-20 | Contra Costa | 13 | 111 | 3044 | |
857050 | 857050 | Danville | Danville | 2021-02-20 | Contra Costa | 13 | 1459 | 43876 | |
857051 | 857051 | Diablo | Diablo | 2021-02-20 | Contra Costa | 13 | 32 | 818 | |
857052 | 857052 | Discovery Bay | Discovery Bay | 2021-02-20 | Contra Costa | 13 | 744 | 13352 | |
857053 | 857053 | El Cerrito | El Cerrito | 2021-02-20 | Contra Costa | 13 | 622 | 24953 | |
857054 | 857054 | Hercules | Hercules | 2021-02-20 | Contra Costa | 13 | 1128 | 25530 | |
857055 | 857055 | Kensington | Kensington | 2021-02-20 | Contra Costa | 13 | 41 | 5077 | |
857056 | 857056 | Knightsen | Knightsen | 2021-02-20 | Contra Costa | 13 | 22 | 1500 | |
857057 | 857057 | Lafayette | Lafayette | 2021-02-20 | Contra Costa | 13 | 554 | 25604 | |
857058 | 857058 | Martinez | Martinez | 2021-02-20 | Contra Costa | 13 | 1750 | 37106 | |
857059 | 857059 | Moraga | Moraga | 2021-02-20 | Contra Costa | 13 | 282 | 16946 | |
857060 | 857060 | Oakley | Oakley | 2021-02-20 | Contra Costa | 13 | 2764 | 42461 | |
857061 | 857061 | Orinda | Orinda | 2021-02-20 | Contra Costa | 13 | 378 | 19009 | |
857062 | 857062 | Pacheco | Pacheco | 2021-02-20 | Contra Costa | 13 | 206 | 3685 | |
857063 | 857063 | Pinole | Pinole | 2021-02-20 | Contra Costa | 13 | 1005 | 19505 | |
857064 | 857064 | Pittsburg | Pittsburg | 2021-02-20 | Contra Costa | 13 | 6101 | 74321 | |
857065 | 857065 | Pleasant Hill | Pleasant Hill | 2021-02-20 | Contra Costa | 13 | 1075 | 34267 | |
857066 | 857066 | Richmond | Richmond | 2021-02-20 | Contra Costa | 13 | 9376 | 111217 | |
857067 | 857067 | Rodeo | Rodeo | 2021-02-20 | Contra Costa | 13 | 527 | 8679 | |
857068 | 857068 | San Pablo | San Pablo | 2021-02-20 | Contra Costa | 13 | 4807 | 31413 | |
857069 | 857069 | San Ramon | San Ramon | 2021-02-20 | Contra Costa | 13 | 1816 | 83118 | |
857070 | 857070 | Walnut Creek | Walnut Creek | 2021-02-20 | Contra Costa | 13 | 2517 | 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 );