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-07-26 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 |
---|---|---|---|---|---|---|---|---|---|
657985 | 657985 | Alamo | Alamo | 2021-07-26 | Contra Costa | 13 | 535 | 14750 | |
657986 | 657986 | Antioch | Antioch | 2021-07-26 | Contra Costa | 13 | 10717 | 112520 | |
657987 | 657987 | Bay Point | Bay Point | 2021-07-26 | Contra Costa | 13 | 2969 | 22639 | |
657988 | 657988 | Bethel Island | Bethel Island | 2021-07-26 | Contra Costa | 13 | 90 | 2137 | |
657989 | 657989 | Brentwood | Brentwood | 2021-07-26 | Contra Costa | 13 | 4240 | 65118 | |
657990 | 657990 | Byron | Byron | 2021-07-26 | Contra Costa | 13 | 116 | 1325 | |
657991 | 657991 | Clayton | Clayton | 2021-07-26 | Contra Costa | 13 | 464 | 11337 | |
657992 | 657992 | Concord | Concord | 2021-07-26 | Contra Costa | 13 | 8674 | 130143 | |
657993 | 657993 | Crockett | Crockett | 2021-07-26 | Contra Costa | 13 | 147 | 3044 | |
657994 | 657994 | Danville | Danville | 2021-07-26 | Contra Costa | 13 | 1794 | 43876 | |
657995 | 657995 | Diablo | Diablo | 2021-07-26 | Contra Costa | 13 | 40 | 818 | |
657996 | 657996 | Discovery Bay | Discovery Bay | 2021-07-26 | Contra Costa | 13 | 971 | 13352 | |
657997 | 657997 | El Cerrito | El Cerrito | 2021-07-26 | Contra Costa | 13 | 767 | 24953 | |
657998 | 657998 | Hercules | Hercules | 2021-07-26 | Contra Costa | 13 | 1397 | 25530 | |
657999 | 657999 | Kensington | Kensington | 2021-07-26 | Contra Costa | 13 | 52 | 5077 | |
658000 | 658000 | Knightsen | Knightsen | 2021-07-26 | Contra Costa | 13 | 26 | 1500 | |
658001 | 658001 | Lafayette | Lafayette | 2021-07-26 | Contra Costa | 13 | 689 | 25604 | |
658002 | 658002 | Martinez | Martinez | 2021-07-26 | Contra Costa | 13 | 2163 | 37106 | |
658003 | 658003 | Moraga | Moraga | 2021-07-26 | Contra Costa | 13 | 360 | 16946 | |
658004 | 658004 | Oakley | Oakley | 2021-07-26 | Contra Costa | 13 | 3622 | 42461 | |
658005 | 658005 | Orinda | Orinda | 2021-07-26 | Contra Costa | 13 | 442 | 19009 | |
658006 | 658006 | Pacheco | Pacheco | 2021-07-26 | Contra Costa | 13 | 259 | 3685 | |
658007 | 658007 | Pinole | Pinole | 2021-07-26 | Contra Costa | 13 | 1225 | 19505 | |
658008 | 658008 | Pittsburg | Pittsburg | 2021-07-26 | Contra Costa | 13 | 7458 | 74321 | |
658009 | 658009 | Pleasant Hill | Pleasant Hill | 2021-07-26 | Contra Costa | 13 | 1325 | 34267 | |
658010 | 658010 | Richmond | Richmond | 2021-07-26 | Contra Costa | 13 | 12414 | 111217 | |
658011 | 658011 | Rodeo | Rodeo | 2021-07-26 | Contra Costa | 13 | 656 | 8679 | |
658012 | 658012 | San Pablo | San Pablo | 2021-07-26 | Contra Costa | 13 | 5577 | 31413 | |
658013 | 658013 | San Ramon | San Ramon | 2021-07-26 | Contra Costa | 13 | 2303 | 83118 | |
658014 | 658014 | Walnut Creek | Walnut Creek | 2021-07-26 | Contra Costa | 13 | 3136 | 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 );