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 2020-11-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 |
---|---|---|---|---|---|---|---|---|---|
993683 | 993683 | Alamo | Alamo | 2020-11-02 | Contra Costa | 13 | 129 | 14750 | |
993684 | 993684 | Antioch | Antioch | 2020-11-02 | Contra Costa | 13 | 2555 | 112520 | |
993685 | 993685 | Bay Point | Bay Point | 2020-11-02 | Contra Costa | 13 | 994 | 22639 | |
993686 | 993686 | Bethel Island | Bethel Island | 2020-11-02 | Contra Costa | 13 | 14 | 2137 | |
993687 | 993687 | Brentwood | Brentwood | 2020-11-02 | Contra Costa | 13 | 757 | 65118 | |
993688 | 993688 | Byron | Byron | 2020-11-02 | Contra Costa | 13 | 24 | 1325 | |
993689 | 993689 | Clayton | Clayton | 2020-11-02 | Contra Costa | 13 | 69 | 11337 | |
993690 | 993690 | Concord | Concord | 2020-11-02 | Contra Costa | 13 | 2557 | 130143 | |
993691 | 993691 | Crockett | Crockett | 2020-11-02 | Contra Costa | 13 | 23 | 3044 | |
993692 | 993692 | Danville | Danville | 2020-11-02 | Contra Costa | 13 | 402 | 43876 | |
993693 | 993693 | Diablo | Diablo | 2020-11-02 | Contra Costa | 13 | 0 | 818 | |
993694 | 993694 | Discovery Bay | Discovery Bay | 2020-11-02 | Contra Costa | 13 | 128 | 13352 | |
993695 | 993695 | El Cerrito | El Cerrito | 2020-11-02 | Contra Costa | 13 | 127 | 24953 | |
993696 | 993696 | Hercules | Hercules | 2020-11-02 | Contra Costa | 13 | 283 | 25530 | |
993697 | 993697 | Kensington | Kensington | 2020-11-02 | Contra Costa | 13 | 0 | 5077 | |
993698 | 993698 | Knightsen | Knightsen | 2020-11-02 | Contra Costa | 13 | 0 | 1500 | |
993699 | 993699 | Lafayette | Lafayette | 2020-11-02 | Contra Costa | 13 | 166 | 25604 | |
993700 | 993700 | Martinez | Martinez | 2020-11-02 | Contra Costa | 13 | 427 | 37106 | |
993701 | 993701 | Moraga | Moraga | 2020-11-02 | Contra Costa | 13 | 81 | 16946 | |
993702 | 993702 | Oakley | Oakley | 2020-11-02 | Contra Costa | 13 | 603 | 42461 | |
993703 | 993703 | Orinda | Orinda | 2020-11-02 | Contra Costa | 13 | 140 | 19009 | |
993704 | 993704 | Pacheco | Pacheco | 2020-11-02 | Contra Costa | 13 | 74 | 3685 | |
993705 | 993705 | Pinole | Pinole | 2020-11-02 | Contra Costa | 13 | 259 | 19505 | |
993706 | 993706 | Pittsburg | Pittsburg | 2020-11-02 | Contra Costa | 13 | 2161 | 74321 | |
993707 | 993707 | Pleasant Hill | Pleasant Hill | 2020-11-02 | Contra Costa | 13 | 322 | 34267 | |
993708 | 993708 | Richmond | Richmond | 2020-11-02 | Contra Costa | 13 | 3619 | 111217 | |
993709 | 993709 | Rodeo | Rodeo | 2020-11-02 | Contra Costa | 13 | 127 | 8679 | |
993710 | 993710 | San Pablo | San Pablo | 2020-11-02 | Contra Costa | 13 | 1647 | 31413 | |
993711 | 993711 | San Ramon | San Ramon | 2020-11-02 | Contra Costa | 13 | 441 | 83118 | |
993712 | 993712 | Walnut Creek | Walnut Creek | 2020-11-02 | Contra Costa | 13 | 683 | 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 );