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-23 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 |
---|---|---|---|---|---|---|---|---|---|
661813 | 661813 | Alamo | Alamo | 2021-07-23 | Contra Costa | 13 | 528 | 14750 | |
661814 | 661814 | Antioch | Antioch | 2021-07-23 | Contra Costa | 13 | 10563 | 112520 | |
661815 | 661815 | Bay Point | Bay Point | 2021-07-23 | Contra Costa | 13 | 2950 | 22639 | |
661816 | 661816 | Bethel Island | Bethel Island | 2021-07-23 | Contra Costa | 13 | 88 | 2137 | |
661817 | 661817 | Brentwood | Brentwood | 2021-07-23 | Contra Costa | 13 | 4198 | 65118 | |
661818 | 661818 | Byron | Byron | 2021-07-23 | Contra Costa | 13 | 114 | 1325 | |
661819 | 661819 | Clayton | Clayton | 2021-07-23 | Contra Costa | 13 | 459 | 11337 | |
661820 | 661820 | Concord | Concord | 2021-07-23 | Contra Costa | 13 | 8587 | 130143 | |
661821 | 661821 | Crockett | Crockett | 2021-07-23 | Contra Costa | 13 | 143 | 3044 | |
661822 | 661822 | Danville | Danville | 2021-07-23 | Contra Costa | 13 | 1770 | 43876 | |
661823 | 661823 | Diablo | Diablo | 2021-07-23 | Contra Costa | 13 | 40 | 818 | |
661824 | 661824 | Discovery Bay | Discovery Bay | 2021-07-23 | Contra Costa | 13 | 957 | 13352 | |
661825 | 661825 | El Cerrito | El Cerrito | 2021-07-23 | Contra Costa | 13 | 758 | 24953 | |
661826 | 661826 | Hercules | Hercules | 2021-07-23 | Contra Costa | 13 | 1376 | 25530 | |
661827 | 661827 | Kensington | Kensington | 2021-07-23 | Contra Costa | 13 | 51 | 5077 | |
661828 | 661828 | Knightsen | Knightsen | 2021-07-23 | Contra Costa | 13 | 26 | 1500 | |
661829 | 661829 | Lafayette | Lafayette | 2021-07-23 | Contra Costa | 13 | 682 | 25604 | |
661830 | 661830 | Martinez | Martinez | 2021-07-23 | Contra Costa | 13 | 2123 | 37106 | |
661831 | 661831 | Moraga | Moraga | 2021-07-23 | Contra Costa | 13 | 355 | 16946 | |
661832 | 661832 | Oakley | Oakley | 2021-07-23 | Contra Costa | 13 | 3574 | 42461 | |
661833 | 661833 | Orinda | Orinda | 2021-07-23 | Contra Costa | 13 | 439 | 19009 | |
661834 | 661834 | Pacheco | Pacheco | 2021-07-23 | Contra Costa | 13 | 259 | 3685 | |
661835 | 661835 | Pinole | Pinole | 2021-07-23 | Contra Costa | 13 | 1216 | 19505 | |
661836 | 661836 | Pittsburg | Pittsburg | 2021-07-23 | Contra Costa | 13 | 7393 | 74321 | |
661837 | 661837 | Pleasant Hill | Pleasant Hill | 2021-07-23 | Contra Costa | 13 | 1312 | 34267 | |
661838 | 661838 | Richmond | Richmond | 2021-07-23 | Contra Costa | 13 | 12303 | 111217 | |
661839 | 661839 | Rodeo | Rodeo | 2021-07-23 | Contra Costa | 13 | 638 | 8679 | |
661840 | 661840 | San Pablo | San Pablo | 2021-07-23 | Contra Costa | 13 | 5535 | 31413 | |
661841 | 661841 | San Ramon | San Ramon | 2021-07-23 | Contra Costa | 13 | 2274 | 83118 | |
661842 | 661842 | Walnut Creek | Walnut Creek | 2021-07-23 | Contra Costa | 13 | 3086 | 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 );