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-09-19 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 |
---|---|---|---|---|---|---|---|---|---|
1046416 | 1046416 | Alamo | Alamo | 2020-09-19 | Contra Costa | 13 | 99 | 14750 | |
1046417 | 1046417 | Antioch | Antioch | 2020-09-19 | Contra Costa | 13 | 2137 | 112520 | |
1046418 | 1046418 | Bay Point | Bay Point | 2020-09-19 | Contra Costa | 13 | 840 | 22639 | |
1046419 | 1046419 | Bethel Island | Bethel Island | 2020-09-19 | Contra Costa | 13 | 11 | 2137 | |
1046420 | 1046420 | Brentwood | Brentwood | 2020-09-19 | Contra Costa | 13 | 571 | 65118 | |
1046421 | 1046421 | Byron | Byron | 2020-09-19 | Contra Costa | 13 | 23 | 1325 | |
1046422 | 1046422 | Clayton | Clayton | 2020-09-19 | Contra Costa | 13 | 51 | 11337 | |
1046423 | 1046423 | Concord | Concord | 2020-09-19 | Contra Costa | 13 | 2103 | 130143 | |
1046424 | 1046424 | Crockett | Crockett | 2020-09-19 | Contra Costa | 13 | 15 | 3044 | |
1046425 | 1046425 | Danville | Danville | 2020-09-19 | Contra Costa | 13 | 275 | 43876 | |
1046426 | 1046426 | Diablo | Diablo | 2020-09-19 | Contra Costa | 13 | 0 | 818 | |
1046427 | 1046427 | Discovery Bay | Discovery Bay | 2020-09-19 | Contra Costa | 13 | 104 | 13352 | |
1046428 | 1046428 | El Cerrito | El Cerrito | 2020-09-19 | Contra Costa | 13 | 99 | 24953 | |
1046429 | 1046429 | Hercules | Hercules | 2020-09-19 | Contra Costa | 13 | 222 | 25530 | |
1046430 | 1046430 | Kensington | Kensington | 2020-09-19 | Contra Costa | 13 | 0 | 5077 | |
1046431 | 1046431 | Knightsen | Knightsen | 2020-09-19 | Contra Costa | 13 | 0 | 1500 | |
1046432 | 1046432 | Lafayette | Lafayette | 2020-09-19 | Contra Costa | 13 | 127 | 25604 | |
1046433 | 1046433 | Martinez | Martinez | 2020-09-19 | Contra Costa | 13 | 325 | 37106 | |
1046434 | 1046434 | Moraga | Moraga | 2020-09-19 | Contra Costa | 13 | 56 | 16946 | |
1046435 | 1046435 | Oakley | Oakley | 2020-09-19 | Contra Costa | 13 | 472 | 42461 | |
1046436 | 1046436 | Orinda | Orinda | 2020-09-19 | Contra Costa | 13 | 107 | 19009 | |
1046437 | 1046437 | Pacheco | Pacheco | 2020-09-19 | Contra Costa | 13 | 62 | 3685 | |
1046438 | 1046438 | Pinole | Pinole | 2020-09-19 | Contra Costa | 13 | 210 | 19505 | |
1046439 | 1046439 | Pittsburg | Pittsburg | 2020-09-19 | Contra Costa | 13 | 1770 | 74321 | |
1046440 | 1046440 | Pleasant Hill | Pleasant Hill | 2020-09-19 | Contra Costa | 13 | 271 | 34267 | |
1046441 | 1046441 | Richmond | Richmond | 2020-09-19 | Contra Costa | 13 | 3079 | 111217 | |
1046442 | 1046442 | Rodeo | Rodeo | 2020-09-19 | Contra Costa | 13 | 101 | 8679 | |
1046443 | 1046443 | San Pablo | San Pablo | 2020-09-19 | Contra Costa | 13 | 1376 | 31413 | |
1046444 | 1046444 | San Ramon | San Ramon | 2020-09-19 | Contra Costa | 13 | 322 | 83118 | |
1046445 | 1046445 | Walnut Creek | Walnut Creek | 2020-09-19 | Contra Costa | 13 | 565 | 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 );