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-22 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 |
---|---|---|---|---|---|---|---|---|---|
969463 | 969463 | Alamo | Alamo | 2020-11-22 | Contra Costa | 13 | 167 | 14750 | |
969464 | 969464 | Antioch | Antioch | 2020-11-22 | Contra Costa | 13 | 2983 | 112520 | |
969465 | 969465 | Bay Point | Bay Point | 2020-11-22 | Contra Costa | 13 | 1087 | 22639 | |
969466 | 969466 | Bethel Island | Bethel Island | 2020-11-22 | Contra Costa | 13 | 16 | 2137 | |
969467 | 969467 | Brentwood | Brentwood | 2020-11-22 | Contra Costa | 13 | 939 | 65118 | |
969468 | 969468 | Byron | Byron | 2020-11-22 | Contra Costa | 13 | 30 | 1325 | |
969469 | 969469 | Clayton | Clayton | 2020-11-22 | Contra Costa | 13 | 95 | 11337 | |
969470 | 969470 | Concord | Concord | 2020-11-22 | Contra Costa | 13 | 2872 | 130143 | |
969471 | 969471 | Crockett | Crockett | 2020-11-22 | Contra Costa | 13 | 27 | 3044 | |
969472 | 969472 | Danville | Danville | 2020-11-22 | Contra Costa | 13 | 509 | 43876 | |
969473 | 969473 | Diablo | Diablo | 2020-11-22 | Contra Costa | 13 | 0 | 818 | |
969474 | 969474 | Discovery Bay | Discovery Bay | 2020-11-22 | Contra Costa | 13 | 193 | 13352 | |
969475 | 969475 | El Cerrito | El Cerrito | 2020-11-22 | Contra Costa | 13 | 181 | 24953 | |
969476 | 969476 | Hercules | Hercules | 2020-11-22 | Contra Costa | 13 | 348 | 25530 | |
969477 | 969477 | Kensington | Kensington | 2020-11-22 | Contra Costa | 13 | 17 | 5077 | |
969478 | 969478 | Knightsen | Knightsen | 2020-11-22 | Contra Costa | 13 | 0 | 1500 | |
969479 | 969479 | Lafayette | Lafayette | 2020-11-22 | Contra Costa | 13 | 226 | 25604 | |
969480 | 969480 | Martinez | Martinez | 2020-11-22 | Contra Costa | 13 | 505 | 37106 | |
969481 | 969481 | Moraga | Moraga | 2020-11-22 | Contra Costa | 13 | 98 | 16946 | |
969482 | 969482 | Oakley | Oakley | 2020-11-22 | Contra Costa | 13 | 717 | 42461 | |
969483 | 969483 | Orinda | Orinda | 2020-11-22 | Contra Costa | 13 | 168 | 19009 | |
969484 | 969484 | Pacheco | Pacheco | 2020-11-22 | Contra Costa | 13 | 77 | 3685 | |
969485 | 969485 | Pinole | Pinole | 2020-11-22 | Contra Costa | 13 | 318 | 19505 | |
969486 | 969486 | Pittsburg | Pittsburg | 2020-11-22 | Contra Costa | 13 | 2393 | 74321 | |
969487 | 969487 | Pleasant Hill | Pleasant Hill | 2020-11-22 | Contra Costa | 13 | 376 | 34267 | |
969488 | 969488 | Richmond | Richmond | 2020-11-22 | Contra Costa | 13 | 4126 | 111217 | |
969489 | 969489 | Rodeo | Rodeo | 2020-11-22 | Contra Costa | 13 | 155 | 8679 | |
969490 | 969490 | San Pablo | San Pablo | 2020-11-22 | Contra Costa | 13 | 1878 | 31413 | |
969491 | 969491 | San Ramon | San Ramon | 2020-11-22 | Contra Costa | 13 | 573 | 83118 | |
969492 | 969492 | Walnut Creek | Walnut Creek | 2020-11-22 | Contra Costa | 13 | 816 | 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 );