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 2022-05-28 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 |
---|---|---|---|---|---|---|---|---|---|
268698 | 268698 | Alamo | Alamo | 2022-05-28 | Contra Costa | 13 | 1736 | 14750 | |
268699 | 268699 | Antioch | Antioch | 2022-05-28 | Contra Costa | 13 | 27047 | 112520 | |
268700 | 268700 | Bay Point | Bay Point | 2022-05-28 | Contra Costa | 13 | 6504 | 22639 | |
268701 | 268701 | Bethel Island | Bethel Island | 2022-05-28 | Contra Costa | 13 | 279 | 2137 | |
268702 | 268702 | Brentwood | Brentwood | 2022-05-28 | Contra Costa | 13 | 12396 | 65118 | |
268703 | 268703 | Byron | Byron | 2022-05-28 | Contra Costa | 13 | 261 | 1325 | |
268704 | 268704 | Clayton | Clayton | 2022-05-28 | Contra Costa | 13 | 1570 | 11337 | |
268705 | 268705 | Concord | Concord | 2022-05-28 | Contra Costa | 13 | 22348 | 130143 | |
268706 | 268706 | Crockett | Crockett | 2022-05-28 | Contra Costa | 13 | 502 | 3044 | |
268707 | 268707 | Danville | Danville | 2022-05-28 | Contra Costa | 13 | 6576 | 43876 | |
268708 | 268708 | Diablo | Diablo | 2022-05-28 | Contra Costa | 13 | 115 | 818 | |
268709 | 268709 | Discovery Bay | Discovery Bay | 2022-05-28 | Contra Costa | 13 | 2564 | 13352 | |
268710 | 268710 | El Cerrito | El Cerrito | 2022-05-28 | Contra Costa | 13 | 2928 | 24953 | |
268711 | 268711 | Hercules | Hercules | 2022-05-28 | Contra Costa | 13 | 4550 | 25530 | |
268712 | 268712 | Kensington | Kensington | 2022-05-28 | Contra Costa | 13 | 360 | 5077 | |
268713 | 268713 | Knightsen | Knightsen | 2022-05-28 | Contra Costa | 13 | 79 | 1500 | |
268714 | 268714 | Lafayette | Lafayette | 2022-05-28 | Contra Costa | 13 | 2698 | 25604 | |
268715 | 268715 | Martinez | Martinez | 2022-05-28 | Contra Costa | 13 | 7026 | 37106 | |
268716 | 268716 | Moraga | Moraga | 2022-05-28 | Contra Costa | 13 | 1494 | 16946 | |
268717 | 268717 | Oakley | Oakley | 2022-05-28 | Contra Costa | 13 | 10227 | 42461 | |
268718 | 268718 | Orinda | Orinda | 2022-05-28 | Contra Costa | 13 | 1861 | 19009 | |
268719 | 268719 | Pacheco | Pacheco | 2022-05-28 | Contra Costa | 13 | 717 | 3685 | |
268720 | 268720 | Pinole | Pinole | 2022-05-28 | Contra Costa | 13 | 3504 | 19505 | |
268721 | 268721 | Pittsburg | Pittsburg | 2022-05-28 | Contra Costa | 13 | 17507 | 74321 | |
268722 | 268722 | Pleasant Hill | Pleasant Hill | 2022-05-28 | Contra Costa | 13 | 4840 | 34267 | |
268723 | 268723 | Richmond | Richmond | 2022-05-28 | Contra Costa | 13 | 29785 | 111217 | |
268724 | 268724 | Rodeo | Rodeo | 2022-05-28 | Contra Costa | 13 | 1963 | 8679 | |
268725 | 268725 | San Pablo | San Pablo | 2022-05-28 | Contra Costa | 13 | 12593 | 31413 | |
268726 | 268726 | San Ramon | San Ramon | 2022-05-28 | Contra Costa | 13 | 9630 | 83118 | |
268727 | 268727 | Walnut Creek | Walnut Creek | 2022-05-28 | Contra Costa | 13 | 10802 | 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 );