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-31 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 |
---|---|---|---|---|---|---|---|---|---|
651605 | 651605 | Alamo | Alamo | 2021-07-31 | Contra Costa | 13 | 549 | 14750 | |
651606 | 651606 | Antioch | Antioch | 2021-07-31 | Contra Costa | 13 | 11059 | 112520 | |
651607 | 651607 | Bay Point | Bay Point | 2021-07-31 | Contra Costa | 13 | 3056 | 22639 | |
651608 | 651608 | Bethel Island | Bethel Island | 2021-07-31 | Contra Costa | 13 | 96 | 2137 | |
651609 | 651609 | Brentwood | Brentwood | 2021-07-31 | Contra Costa | 13 | 4397 | 65118 | |
651610 | 651610 | Byron | Byron | 2021-07-31 | Contra Costa | 13 | 117 | 1325 | |
651611 | 651611 | Clayton | Clayton | 2021-07-31 | Contra Costa | 13 | 490 | 11337 | |
651612 | 651612 | Concord | Concord | 2021-07-31 | Contra Costa | 13 | 8923 | 130143 | |
651613 | 651613 | Crockett | Crockett | 2021-07-31 | Contra Costa | 13 | 155 | 3044 | |
651614 | 651614 | Danville | Danville | 2021-07-31 | Contra Costa | 13 | 1849 | 43876 | |
651615 | 651615 | Diablo | Diablo | 2021-07-31 | Contra Costa | 13 | 40 | 818 | |
651616 | 651616 | Discovery Bay | Discovery Bay | 2021-07-31 | Contra Costa | 13 | 1008 | 13352 | |
651617 | 651617 | El Cerrito | El Cerrito | 2021-07-31 | Contra Costa | 13 | 787 | 24953 | |
651618 | 651618 | Hercules | Hercules | 2021-07-31 | Contra Costa | 13 | 1436 | 25530 | |
651619 | 651619 | Kensington | Kensington | 2021-07-31 | Contra Costa | 13 | 56 | 5077 | |
651620 | 651620 | Knightsen | Knightsen | 2021-07-31 | Contra Costa | 13 | 27 | 1500 | |
651621 | 651621 | Lafayette | Lafayette | 2021-07-31 | Contra Costa | 13 | 698 | 25604 | |
651622 | 651622 | Martinez | Martinez | 2021-07-31 | Contra Costa | 13 | 2244 | 37106 | |
651623 | 651623 | Moraga | Moraga | 2021-07-31 | Contra Costa | 13 | 365 | 16946 | |
651624 | 651624 | Oakley | Oakley | 2021-07-31 | Contra Costa | 13 | 3763 | 42461 | |
651625 | 651625 | Orinda | Orinda | 2021-07-31 | Contra Costa | 13 | 453 | 19009 | |
651626 | 651626 | Pacheco | Pacheco | 2021-07-31 | Contra Costa | 13 | 267 | 3685 | |
651627 | 651627 | Pinole | Pinole | 2021-07-31 | Contra Costa | 13 | 1261 | 19505 | |
651628 | 651628 | Pittsburg | Pittsburg | 2021-07-31 | Contra Costa | 13 | 7638 | 74321 | |
651629 | 651629 | Pleasant Hill | Pleasant Hill | 2021-07-31 | Contra Costa | 13 | 1364 | 34267 | |
651630 | 651630 | Richmond | Richmond | 2021-07-31 | Contra Costa | 13 | 12639 | 111217 | |
651631 | 651631 | Rodeo | Rodeo | 2021-07-31 | Contra Costa | 13 | 673 | 8679 | |
651632 | 651632 | San Pablo | San Pablo | 2021-07-31 | Contra Costa | 13 | 5653 | 31413 | |
651633 | 651633 | San Ramon | San Ramon | 2021-07-31 | Contra Costa | 13 | 2370 | 83118 | |
651634 | 651634 | Walnut Creek | Walnut Creek | 2021-07-31 | Contra Costa | 13 | 3233 | 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 );