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-27 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 |
---|---|---|---|---|---|---|---|---|---|
656709 | 656709 | Alamo | Alamo | 2021-07-27 | Contra Costa | 13 | 536 | 14750 | |
656710 | 656710 | Antioch | Antioch | 2021-07-27 | Contra Costa | 13 | 10784 | 112520 | |
656711 | 656711 | Bay Point | Bay Point | 2021-07-27 | Contra Costa | 13 | 2980 | 22639 | |
656712 | 656712 | Bethel Island | Bethel Island | 2021-07-27 | Contra Costa | 13 | 91 | 2137 | |
656713 | 656713 | Brentwood | Brentwood | 2021-07-27 | Contra Costa | 13 | 4273 | 65118 | |
656714 | 656714 | Byron | Byron | 2021-07-27 | Contra Costa | 13 | 117 | 1325 | |
656715 | 656715 | Clayton | Clayton | 2021-07-27 | Contra Costa | 13 | 469 | 11337 | |
656716 | 656716 | Concord | Concord | 2021-07-27 | Contra Costa | 13 | 8711 | 130143 | |
656717 | 656717 | Crockett | Crockett | 2021-07-27 | Contra Costa | 13 | 147 | 3044 | |
656718 | 656718 | Danville | Danville | 2021-07-27 | Contra Costa | 13 | 1803 | 43876 | |
656719 | 656719 | Diablo | Diablo | 2021-07-27 | Contra Costa | 13 | 40 | 818 | |
656720 | 656720 | Discovery Bay | Discovery Bay | 2021-07-27 | Contra Costa | 13 | 982 | 13352 | |
656721 | 656721 | El Cerrito | El Cerrito | 2021-07-27 | Contra Costa | 13 | 768 | 24953 | |
656722 | 656722 | Hercules | Hercules | 2021-07-27 | Contra Costa | 13 | 1404 | 25530 | |
656723 | 656723 | Kensington | Kensington | 2021-07-27 | Contra Costa | 13 | 52 | 5077 | |
656724 | 656724 | Knightsen | Knightsen | 2021-07-27 | Contra Costa | 13 | 27 | 1500 | |
656725 | 656725 | Lafayette | Lafayette | 2021-07-27 | Contra Costa | 13 | 689 | 25604 | |
656726 | 656726 | Martinez | Martinez | 2021-07-27 | Contra Costa | 13 | 2174 | 37106 | |
656727 | 656727 | Moraga | Moraga | 2021-07-27 | Contra Costa | 13 | 360 | 16946 | |
656728 | 656728 | Oakley | Oakley | 2021-07-27 | Contra Costa | 13 | 3670 | 42461 | |
656729 | 656729 | Orinda | Orinda | 2021-07-27 | Contra Costa | 13 | 446 | 19009 | |
656730 | 656730 | Pacheco | Pacheco | 2021-07-27 | Contra Costa | 13 | 262 | 3685 | |
656731 | 656731 | Pinole | Pinole | 2021-07-27 | Contra Costa | 13 | 1230 | 19505 | |
656732 | 656732 | Pittsburg | Pittsburg | 2021-07-27 | Contra Costa | 13 | 7493 | 74321 | |
656733 | 656733 | Pleasant Hill | Pleasant Hill | 2021-07-27 | Contra Costa | 13 | 1331 | 34267 | |
656734 | 656734 | Richmond | Richmond | 2021-07-27 | Contra Costa | 13 | 12443 | 111217 | |
656735 | 656735 | Rodeo | Rodeo | 2021-07-27 | Contra Costa | 13 | 656 | 8679 | |
656736 | 656736 | San Pablo | San Pablo | 2021-07-27 | Contra Costa | 13 | 5581 | 31413 | |
656737 | 656737 | San Ramon | San Ramon | 2021-07-27 | Contra Costa | 13 | 2314 | 83118 | |
656738 | 656738 | Walnut Creek | Walnut Creek | 2021-07-27 | Contra Costa | 13 | 3156 | 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 );