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-11-01 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 |
---|---|---|---|---|---|---|---|---|---|
70439 | 70439 | Alamo | Alamo | 2022-11-01 | Contra Costa | 13 | 2346 | 14750 | |
70440 | 70440 | Antioch | Antioch | 2022-11-01 | Contra Costa | 13 | 34924 | 112520 | |
70441 | 70441 | Bay Point | Bay Point | 2022-11-01 | Contra Costa | 13 | 7956 | 22639 | |
70442 | 70442 | Bethel Island | Bethel Island | 2022-11-01 | Contra Costa | 13 | 370 | 2137 | |
70443 | 70443 | Brentwood | Brentwood | 2022-11-01 | Contra Costa | 13 | 18014 | 65118 | |
70444 | 70444 | Byron | Byron | 2022-11-01 | Contra Costa | 13 | 341 | 1325 | |
70445 | 70445 | Clayton | Clayton | 2022-11-01 | Contra Costa | 13 | 2058 | 11337 | |
70446 | 70446 | Concord | Concord | 2022-11-01 | Contra Costa | 13 | 28786 | 130143 | |
70447 | 70447 | Crockett | Crockett | 2022-11-01 | Contra Costa | 13 | 619 | 3044 | |
70448 | 70448 | Danville | Danville | 2022-11-01 | Contra Costa | 13 | 9345 | 43876 | |
70449 | 70449 | Diablo | Diablo | 2022-11-01 | Contra Costa | 13 | 152 | 818 | |
70450 | 70450 | Discovery Bay | Discovery Bay | 2022-11-01 | Contra Costa | 13 | 3294 | 13352 | |
70451 | 70451 | El Cerrito | El Cerrito | 2022-11-01 | Contra Costa | 13 | 4219 | 24953 | |
70452 | 70452 | Hercules | Hercules | 2022-11-01 | Contra Costa | 13 | 6262 | 25530 | |
70453 | 70453 | Kensington | Kensington | 2022-11-01 | Contra Costa | 13 | 545 | 5077 | |
70454 | 70454 | Knightsen | Knightsen | 2022-11-01 | Contra Costa | 13 | 103 | 1500 | |
70455 | 70455 | Lafayette | Lafayette | 2022-11-01 | Contra Costa | 13 | 4167 | 25604 | |
70456 | 70456 | Martinez | Martinez | 2022-11-01 | Contra Costa | 13 | 9963 | 37106 | |
70457 | 70457 | Moraga | Moraga | 2022-11-01 | Contra Costa | 13 | 2212 | 16946 | |
70458 | 70458 | Oakley | Oakley | 2022-11-01 | Contra Costa | 13 | 13267 | 42461 | |
70459 | 70459 | Orinda | Orinda | 2022-11-01 | Contra Costa | 13 | 2674 | 19009 | |
70460 | 70460 | Pacheco | Pacheco | 2022-11-01 | Contra Costa | 13 | 970 | 3685 | |
70461 | 70461 | Pinole | Pinole | 2022-11-01 | Contra Costa | 13 | 4751 | 19505 | |
70462 | 70462 | Pittsburg | Pittsburg | 2022-11-01 | Contra Costa | 13 | 21727 | 74321 | |
70463 | 70463 | Pleasant Hill | Pleasant Hill | 2022-11-01 | Contra Costa | 13 | 6695 | 34267 | |
70464 | 70464 | Richmond | Richmond | 2022-11-01 | Contra Costa | 13 | 37972 | 111217 | |
70465 | 70465 | Rodeo | Rodeo | 2022-11-01 | Contra Costa | 13 | 2465 | 8679 | |
70466 | 70466 | San Pablo | San Pablo | 2022-11-01 | Contra Costa | 13 | 15931 | 31413 | |
70467 | 70467 | San Ramon | San Ramon | 2022-11-01 | Contra Costa | 13 | 14350 | 83118 | |
70468 | 70468 | Walnut Creek | Walnut Creek | 2022-11-01 | Contra Costa | 13 | 14858 | 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 );