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-08-04 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 |
---|---|---|---|---|---|---|---|---|---|
646501 | 646501 | Alamo | Alamo | 2021-08-04 | Contra Costa | 13 | 561 | 14750 | |
646502 | 646502 | Antioch | Antioch | 2021-08-04 | Contra Costa | 13 | 11239 | 112520 | |
646503 | 646503 | Bay Point | Bay Point | 2021-08-04 | Contra Costa | 13 | 3088 | 22639 | |
646504 | 646504 | Bethel Island | Bethel Island | 2021-08-04 | Contra Costa | 13 | 98 | 2137 | |
646505 | 646505 | Brentwood | Brentwood | 2021-08-04 | Contra Costa | 13 | 4492 | 65118 | |
646506 | 646506 | Byron | Byron | 2021-08-04 | Contra Costa | 13 | 118 | 1325 | |
646507 | 646507 | Clayton | Clayton | 2021-08-04 | Contra Costa | 13 | 500 | 11337 | |
646508 | 646508 | Concord | Concord | 2021-08-04 | Contra Costa | 13 | 9023 | 130143 | |
646509 | 646509 | Crockett | Crockett | 2021-08-04 | Contra Costa | 13 | 158 | 3044 | |
646510 | 646510 | Danville | Danville | 2021-08-04 | Contra Costa | 13 | 1882 | 43876 | |
646511 | 646511 | Diablo | Diablo | 2021-08-04 | Contra Costa | 13 | 42 | 818 | |
646512 | 646512 | Discovery Bay | Discovery Bay | 2021-08-04 | Contra Costa | 13 | 1030 | 13352 | |
646513 | 646513 | El Cerrito | El Cerrito | 2021-08-04 | Contra Costa | 13 | 803 | 24953 | |
646514 | 646514 | Hercules | Hercules | 2021-08-04 | Contra Costa | 13 | 1455 | 25530 | |
646515 | 646515 | Kensington | Kensington | 2021-08-04 | Contra Costa | 13 | 59 | 5077 | |
646516 | 646516 | Knightsen | Knightsen | 2021-08-04 | Contra Costa | 13 | 27 | 1500 | |
646517 | 646517 | Lafayette | Lafayette | 2021-08-04 | Contra Costa | 13 | 708 | 25604 | |
646518 | 646518 | Martinez | Martinez | 2021-08-04 | Contra Costa | 13 | 2287 | 37106 | |
646519 | 646519 | Moraga | Moraga | 2021-08-04 | Contra Costa | 13 | 366 | 16946 | |
646520 | 646520 | Oakley | Oakley | 2021-08-04 | Contra Costa | 13 | 3802 | 42461 | |
646521 | 646521 | Orinda | Orinda | 2021-08-04 | Contra Costa | 13 | 457 | 19009 | |
646522 | 646522 | Pacheco | Pacheco | 2021-08-04 | Contra Costa | 13 | 268 | 3685 | |
646523 | 646523 | Pinole | Pinole | 2021-08-04 | Contra Costa | 13 | 1274 | 19505 | |
646524 | 646524 | Pittsburg | Pittsburg | 2021-08-04 | Contra Costa | 13 | 7736 | 74321 | |
646525 | 646525 | Pleasant Hill | Pleasant Hill | 2021-08-04 | Contra Costa | 13 | 1383 | 34267 | |
646526 | 646526 | Richmond | Richmond | 2021-08-04 | Contra Costa | 13 | 12787 | 111217 | |
646527 | 646527 | Rodeo | Rodeo | 2021-08-04 | Contra Costa | 13 | 680 | 8679 | |
646528 | 646528 | San Pablo | San Pablo | 2021-08-04 | Contra Costa | 13 | 5689 | 31413 | |
646529 | 646529 | San Ramon | San Ramon | 2021-08-04 | Contra Costa | 13 | 2405 | 83118 | |
646530 | 646530 | Walnut Creek | Walnut Creek | 2021-08-04 | Contra Costa | 13 | 3277 | 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 );