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-02 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 |
---|---|---|---|---|---|---|---|---|---|
726889 | 726889 | Alamo | Alamo | 2021-06-02 | Contra Costa | 13 | 493 | 14750 | |
726890 | 726890 | Antioch | Antioch | 2021-06-02 | Contra Costa | 13 | 9722 | 112520 | |
726891 | 726891 | Bay Point | Bay Point | 2021-06-02 | Contra Costa | 13 | 2802 | 22639 | |
726892 | 726892 | Bethel Island | Bethel Island | 2021-06-02 | Contra Costa | 13 | 74 | 2137 | |
726893 | 726893 | Brentwood | Brentwood | 2021-06-02 | Contra Costa | 13 | 3865 | 65118 | |
726894 | 726894 | Byron | Byron | 2021-06-02 | Contra Costa | 13 | 106 | 1325 | |
726895 | 726895 | Clayton | Clayton | 2021-06-02 | Contra Costa | 13 | 433 | 11337 | |
726896 | 726896 | Concord | Concord | 2021-06-02 | Contra Costa | 13 | 8123 | 130143 | |
726897 | 726897 | Crockett | Crockett | 2021-06-02 | Contra Costa | 13 | 130 | 3044 | |
726898 | 726898 | Danville | Danville | 2021-06-02 | Contra Costa | 13 | 1666 | 43876 | |
726899 | 726899 | Diablo | Diablo | 2021-06-02 | Contra Costa | 13 | 37 | 818 | |
726900 | 726900 | Discovery Bay | Discovery Bay | 2021-06-02 | Contra Costa | 13 | 879 | 13352 | |
726901 | 726901 | El Cerrito | El Cerrito | 2021-06-02 | Contra Costa | 13 | 717 | 24953 | |
726902 | 726902 | Hercules | Hercules | 2021-06-02 | Contra Costa | 13 | 1276 | 25530 | |
726903 | 726903 | Kensington | Kensington | 2021-06-02 | Contra Costa | 13 | 47 | 5077 | |
726904 | 726904 | Knightsen | Knightsen | 2021-06-02 | Contra Costa | 13 | 25 | 1500 | |
726905 | 726905 | Lafayette | Lafayette | 2021-06-02 | Contra Costa | 13 | 631 | 25604 | |
726906 | 726906 | Martinez | Martinez | 2021-06-02 | Contra Costa | 13 | 1980 | 37106 | |
726907 | 726907 | Moraga | Moraga | 2021-06-02 | Contra Costa | 13 | 336 | 16946 | |
726908 | 726908 | Oakley | Oakley | 2021-06-02 | Contra Costa | 13 | 3267 | 42461 | |
726909 | 726909 | Orinda | Orinda | 2021-06-02 | Contra Costa | 13 | 412 | 19009 | |
726910 | 726910 | Pacheco | Pacheco | 2021-06-02 | Contra Costa | 13 | 245 | 3685 | |
726911 | 726911 | Pinole | Pinole | 2021-06-02 | Contra Costa | 13 | 1151 | 19505 | |
726912 | 726912 | Pittsburg | Pittsburg | 2021-06-02 | Contra Costa | 13 | 6906 | 74321 | |
726913 | 726913 | Pleasant Hill | Pleasant Hill | 2021-06-02 | Contra Costa | 13 | 1229 | 34267 | |
726914 | 726914 | Richmond | Richmond | 2021-06-02 | Contra Costa | 13 | 11693 | 111217 | |
726915 | 726915 | Rodeo | Rodeo | 2021-06-02 | Contra Costa | 13 | 604 | 8679 | |
726916 | 726916 | San Pablo | San Pablo | 2021-06-02 | Contra Costa | 13 | 5291 | 31413 | |
726917 | 726917 | San Ramon | San Ramon | 2021-06-02 | Contra Costa | 13 | 2132 | 83118 | |
726918 | 726918 | Walnut Creek | Walnut Creek | 2021-06-02 | Contra Costa | 13 | 2894 | 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 );