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-13 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 |
---|---|---|---|---|---|---|---|---|---|
674573 | 674573 | Alamo | Alamo | 2021-07-13 | Contra Costa | 13 | 510 | 14750 | |
674574 | 674574 | Antioch | Antioch | 2021-07-13 | Contra Costa | 13 | 10232 | 112520 | |
674575 | 674575 | Bay Point | Bay Point | 2021-07-13 | Contra Costa | 13 | 2870 | 22639 | |
674576 | 674576 | Bethel Island | Bethel Island | 2021-07-13 | Contra Costa | 13 | 83 | 2137 | |
674577 | 674577 | Brentwood | Brentwood | 2021-07-13 | Contra Costa | 13 | 4052 | 65118 | |
674578 | 674578 | Byron | Byron | 2021-07-13 | Contra Costa | 13 | 112 | 1325 | |
674579 | 674579 | Clayton | Clayton | 2021-07-13 | Contra Costa | 13 | 448 | 11337 | |
674580 | 674580 | Concord | Concord | 2021-07-13 | Contra Costa | 13 | 8381 | 130143 | |
674581 | 674581 | Crockett | Crockett | 2021-07-13 | Contra Costa | 13 | 133 | 3044 | |
674582 | 674582 | Danville | Danville | 2021-07-13 | Contra Costa | 13 | 1715 | 43876 | |
674583 | 674583 | Diablo | Diablo | 2021-07-13 | Contra Costa | 13 | 38 | 818 | |
674584 | 674584 | Discovery Bay | Discovery Bay | 2021-07-13 | Contra Costa | 13 | 926 | 13352 | |
674585 | 674585 | El Cerrito | El Cerrito | 2021-07-13 | Contra Costa | 13 | 737 | 24953 | |
674586 | 674586 | Hercules | Hercules | 2021-07-13 | Contra Costa | 13 | 1337 | 25530 | |
674587 | 674587 | Kensington | Kensington | 2021-07-13 | Contra Costa | 13 | 48 | 5077 | |
674588 | 674588 | Knightsen | Knightsen | 2021-07-13 | Contra Costa | 13 | 26 | 1500 | |
674589 | 674589 | Lafayette | Lafayette | 2021-07-13 | Contra Costa | 13 | 649 | 25604 | |
674590 | 674590 | Martinez | Martinez | 2021-07-13 | Contra Costa | 13 | 2041 | 37106 | |
674591 | 674591 | Moraga | Moraga | 2021-07-13 | Contra Costa | 13 | 347 | 16946 | |
674592 | 674592 | Oakley | Oakley | 2021-07-13 | Contra Costa | 13 | 3456 | 42461 | |
674593 | 674593 | Orinda | Orinda | 2021-07-13 | Contra Costa | 13 | 427 | 19009 | |
674594 | 674594 | Pacheco | Pacheco | 2021-07-13 | Contra Costa | 13 | 253 | 3685 | |
674595 | 674595 | Pinole | Pinole | 2021-07-13 | Contra Costa | 13 | 1188 | 19505 | |
674596 | 674596 | Pittsburg | Pittsburg | 2021-07-13 | Contra Costa | 13 | 7214 | 74321 | |
674597 | 674597 | Pleasant Hill | Pleasant Hill | 2021-07-13 | Contra Costa | 13 | 1269 | 34267 | |
674598 | 674598 | Richmond | Richmond | 2021-07-13 | Contra Costa | 13 | 12022 | 111217 | |
674599 | 674599 | Rodeo | Rodeo | 2021-07-13 | Contra Costa | 13 | 622 | 8679 | |
674600 | 674600 | San Pablo | San Pablo | 2021-07-13 | Contra Costa | 13 | 5442 | 31413 | |
674601 | 674601 | San Ramon | San Ramon | 2021-07-13 | Contra Costa | 13 | 2196 | 83118 | |
674602 | 674602 | Walnut Creek | Walnut Creek | 2021-07-13 | Contra Costa | 13 | 2994 | 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 );