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-17 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 |
---|---|---|---|---|---|---|---|---|---|
707749 | 707749 | Alamo | Alamo | 2021-06-17 | Contra Costa | 13 | 496 | 14750 | |
707750 | 707750 | Antioch | Antioch | 2021-06-17 | Contra Costa | 13 | 9895 | 112520 | |
707751 | 707751 | Bay Point | Bay Point | 2021-06-17 | Contra Costa | 13 | 2819 | 22639 | |
707752 | 707752 | Bethel Island | Bethel Island | 2021-06-17 | Contra Costa | 13 | 75 | 2137 | |
707753 | 707753 | Brentwood | Brentwood | 2021-06-17 | Contra Costa | 13 | 3921 | 65118 | |
707754 | 707754 | Byron | Byron | 2021-06-17 | Contra Costa | 13 | 106 | 1325 | |
707755 | 707755 | Clayton | Clayton | 2021-06-17 | Contra Costa | 13 | 435 | 11337 | |
707756 | 707756 | Concord | Concord | 2021-06-17 | Contra Costa | 13 | 8175 | 130143 | |
707757 | 707757 | Crockett | Crockett | 2021-06-17 | Contra Costa | 13 | 132 | 3044 | |
707758 | 707758 | Danville | Danville | 2021-06-17 | Contra Costa | 13 | 1670 | 43876 | |
707759 | 707759 | Diablo | Diablo | 2021-06-17 | Contra Costa | 13 | 37 | 818 | |
707760 | 707760 | Discovery Bay | Discovery Bay | 2021-06-17 | Contra Costa | 13 | 890 | 13352 | |
707761 | 707761 | El Cerrito | El Cerrito | 2021-06-17 | Contra Costa | 13 | 718 | 24953 | |
707762 | 707762 | Hercules | Hercules | 2021-06-17 | Contra Costa | 13 | 1293 | 25530 | |
707763 | 707763 | Kensington | Kensington | 2021-06-17 | Contra Costa | 13 | 47 | 5077 | |
707764 | 707764 | Knightsen | Knightsen | 2021-06-17 | Contra Costa | 13 | 26 | 1500 | |
707765 | 707765 | Lafayette | Lafayette | 2021-06-17 | Contra Costa | 13 | 636 | 25604 | |
707766 | 707766 | Martinez | Martinez | 2021-06-17 | Contra Costa | 13 | 1994 | 37106 | |
707767 | 707767 | Moraga | Moraga | 2021-06-17 | Contra Costa | 13 | 343 | 16946 | |
707768 | 707768 | Oakley | Oakley | 2021-06-17 | Contra Costa | 13 | 3322 | 42461 | |
707769 | 707769 | Orinda | Orinda | 2021-06-17 | Contra Costa | 13 | 414 | 19009 | |
707770 | 707770 | Pacheco | Pacheco | 2021-06-17 | Contra Costa | 13 | 250 | 3685 | |
707771 | 707771 | Pinole | Pinole | 2021-06-17 | Contra Costa | 13 | 1163 | 19505 | |
707772 | 707772 | Pittsburg | Pittsburg | 2021-06-17 | Contra Costa | 13 | 7005 | 74321 | |
707773 | 707773 | Pleasant Hill | Pleasant Hill | 2021-06-17 | Contra Costa | 13 | 1239 | 34267 | |
707774 | 707774 | Richmond | Richmond | 2021-06-17 | Contra Costa | 13 | 11797 | 111217 | |
707775 | 707775 | Rodeo | Rodeo | 2021-06-17 | Contra Costa | 13 | 606 | 8679 | |
707776 | 707776 | San Pablo | San Pablo | 2021-06-17 | Contra Costa | 13 | 5355 | 31413 | |
707777 | 707777 | San Ramon | San Ramon | 2021-06-17 | Contra Costa | 13 | 2148 | 83118 | |
707778 | 707778 | Walnut Creek | Walnut Creek | 2021-06-17 | Contra Costa | 13 | 2914 | 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 );