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-06-24 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 |
---|---|---|---|---|---|---|---|---|---|
698817 | 698817 | Alamo | Alamo | 2021-06-24 | Contra Costa | 13 | 499 | 14750 | |
698818 | 698818 | Antioch | Antioch | 2021-06-24 | Contra Costa | 13 | 9980 | 112520 | |
698819 | 698819 | Bay Point | Bay Point | 2021-06-24 | Contra Costa | 13 | 2830 | 22639 | |
698820 | 698820 | Bethel Island | Bethel Island | 2021-06-24 | Contra Costa | 13 | 76 | 2137 | |
698821 | 698821 | Brentwood | Brentwood | 2021-06-24 | Contra Costa | 13 | 3964 | 65118 | |
698822 | 698822 | Byron | Byron | 2021-06-24 | Contra Costa | 13 | 109 | 1325 | |
698823 | 698823 | Clayton | Clayton | 2021-06-24 | Contra Costa | 13 | 438 | 11337 | |
698824 | 698824 | Concord | Concord | 2021-06-24 | Contra Costa | 13 | 8219 | 130143 | |
698825 | 698825 | Crockett | Crockett | 2021-06-24 | Contra Costa | 13 | 132 | 3044 | |
698826 | 698826 | Danville | Danville | 2021-06-24 | Contra Costa | 13 | 1676 | 43876 | |
698827 | 698827 | Diablo | Diablo | 2021-06-24 | Contra Costa | 13 | 38 | 818 | |
698828 | 698828 | Discovery Bay | Discovery Bay | 2021-06-24 | Contra Costa | 13 | 899 | 13352 | |
698829 | 698829 | El Cerrito | El Cerrito | 2021-06-24 | Contra Costa | 13 | 720 | 24953 | |
698830 | 698830 | Hercules | Hercules | 2021-06-24 | Contra Costa | 13 | 1301 | 25530 | |
698831 | 698831 | Kensington | Kensington | 2021-06-24 | Contra Costa | 13 | 47 | 5077 | |
698832 | 698832 | Knightsen | Knightsen | 2021-06-24 | Contra Costa | 13 | 26 | 1500 | |
698833 | 698833 | Lafayette | Lafayette | 2021-06-24 | Contra Costa | 13 | 640 | 25604 | |
698834 | 698834 | Martinez | Martinez | 2021-06-24 | Contra Costa | 13 | 1999 | 37106 | |
698835 | 698835 | Moraga | Moraga | 2021-06-24 | Contra Costa | 13 | 342 | 16946 | |
698836 | 698836 | Oakley | Oakley | 2021-06-24 | Contra Costa | 13 | 3346 | 42461 | |
698837 | 698837 | Orinda | Orinda | 2021-06-24 | Contra Costa | 13 | 415 | 19009 | |
698838 | 698838 | Pacheco | Pacheco | 2021-06-24 | Contra Costa | 13 | 250 | 3685 | |
698839 | 698839 | Pinole | Pinole | 2021-06-24 | Contra Costa | 13 | 1165 | 19505 | |
698840 | 698840 | Pittsburg | Pittsburg | 2021-06-24 | Contra Costa | 13 | 7043 | 74321 | |
698841 | 698841 | Pleasant Hill | Pleasant Hill | 2021-06-24 | Contra Costa | 13 | 1243 | 34267 | |
698842 | 698842 | Richmond | Richmond | 2021-06-24 | Contra Costa | 13 | 11864 | 111217 | |
698843 | 698843 | Rodeo | Rodeo | 2021-06-24 | Contra Costa | 13 | 609 | 8679 | |
698844 | 698844 | San Pablo | San Pablo | 2021-06-24 | Contra Costa | 13 | 5379 | 31413 | |
698845 | 698845 | San Ramon | San Ramon | 2021-06-24 | Contra Costa | 13 | 2153 | 83118 | |
698846 | 698846 | Walnut Creek | Walnut Creek | 2021-06-24 | Contra Costa | 13 | 2929 | 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 );