latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
30 rows where county = "Contra Costa", "date" is on date 2022-06-09 and fips = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
253542 | 253542 | Alamo | Alamo | 2022-06-09 | Contra Costa | 13 | 1791 | 14750 | |
253543 | 253543 | Antioch | Antioch | 2022-06-09 | Contra Costa | 13 | 27814 | 112520 | |
253544 | 253544 | Bay Point | Bay Point | 2022-06-09 | Contra Costa | 13 | 6627 | 22639 | |
253545 | 253545 | Bethel Island | Bethel Island | 2022-06-09 | Contra Costa | 13 | 290 | 2137 | |
253546 | 253546 | Brentwood | Brentwood | 2022-06-09 | Contra Costa | 13 | 12790 | 65118 | |
253547 | 253547 | Byron | Byron | 2022-06-09 | Contra Costa | 13 | 269 | 1325 | |
253548 | 253548 | Clayton | Clayton | 2022-06-09 | Contra Costa | 13 | 1626 | 11337 | |
253549 | 253549 | Concord | Concord | 2022-06-09 | Contra Costa | 13 | 23115 | 130143 | |
253550 | 253550 | Crockett | Crockett | 2022-06-09 | Contra Costa | 13 | 514 | 3044 | |
253551 | 253551 | Danville | Danville | 2022-06-09 | Contra Costa | 13 | 6829 | 43876 | |
253552 | 253552 | Diablo | Diablo | 2022-06-09 | Contra Costa | 13 | 121 | 818 | |
253553 | 253553 | Discovery Bay | Discovery Bay | 2022-06-09 | Contra Costa | 13 | 2630 | 13352 | |
253554 | 253554 | El Cerrito | El Cerrito | 2022-06-09 | Contra Costa | 13 | 3063 | 24953 | |
253555 | 253555 | Hercules | Hercules | 2022-06-09 | Contra Costa | 13 | 4743 | 25530 | |
253556 | 253556 | Kensington | Kensington | 2022-06-09 | Contra Costa | 13 | 382 | 5077 | |
253557 | 253557 | Knightsen | Knightsen | 2022-06-09 | Contra Costa | 13 | 81 | 1500 | |
253558 | 253558 | Lafayette | Lafayette | 2022-06-09 | Contra Costa | 13 | 2881 | 25604 | |
253559 | 253559 | Martinez | Martinez | 2022-06-09 | Contra Costa | 13 | 7340 | 37106 | |
253560 | 253560 | Moraga | Moraga | 2022-06-09 | Contra Costa | 13 | 1548 | 16946 | |
253561 | 253561 | Oakley | Oakley | 2022-06-09 | Contra Costa | 13 | 10518 | 42461 | |
253562 | 253562 | Orinda | Orinda | 2022-06-09 | Contra Costa | 13 | 1978 | 19009 | |
253563 | 253563 | Pacheco | Pacheco | 2022-06-09 | Contra Costa | 13 | 748 | 3685 | |
253564 | 253564 | Pinole | Pinole | 2022-06-09 | Contra Costa | 13 | 3647 | 19505 | |
253565 | 253565 | Pittsburg | Pittsburg | 2022-06-09 | Contra Costa | 13 | 17972 | 74321 | |
253566 | 253566 | Pleasant Hill | Pleasant Hill | 2022-06-09 | Contra Costa | 13 | 5067 | 34267 | |
253567 | 253567 | Richmond | Richmond | 2022-06-09 | Contra Costa | 13 | 30534 | 111217 | |
253568 | 253568 | Rodeo | Rodeo | 2022-06-09 | Contra Costa | 13 | 2020 | 8679 | |
253569 | 253569 | San Pablo | San Pablo | 2022-06-09 | Contra Costa | 13 | 12914 | 31413 | |
253570 | 253570 | San Ramon | San Ramon | 2022-06-09 | Contra Costa | 13 | 10194 | 83118 | |
253571 | 253571 | Walnut Creek | Walnut Creek | 2022-06-09 | Contra Costa | 13 | 11291 | 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 );