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-12-31 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 |
---|---|---|---|---|---|---|---|---|---|
456377 | 456377 | Alamo | Alamo | 2021-12-31 | Contra Costa | 13 | 914 | 14750 | |
456378 | 456378 | Antioch | Antioch | 2021-12-31 | Contra Costa | 13 | 15682 | 112520 | |
456379 | 456379 | Bay Point | Bay Point | 2021-12-31 | Contra Costa | 13 | 4038 | 22639 | |
456380 | 456380 | Bethel Island | Bethel Island | 2021-12-31 | Contra Costa | 13 | 170 | 2137 | |
456381 | 456381 | Brentwood | Brentwood | 2021-12-31 | Contra Costa | 13 | 7108 | 65118 | |
456382 | 456382 | Byron | Byron | 2021-12-31 | Contra Costa | 13 | 191 | 1325 | |
456383 | 456383 | Clayton | Clayton | 2021-12-31 | Contra Costa | 13 | 806 | 11337 | |
456384 | 456384 | Concord | Concord | 2021-12-31 | Contra Costa | 13 | 12287 | 130143 | |
456385 | 456385 | Crockett | Crockett | 2021-12-31 | Contra Costa | 13 | 250 | 3044 | |
456386 | 456386 | Danville | Danville | 2021-12-31 | Contra Costa | 13 | 3228 | 43876 | |
456387 | 456387 | Diablo | Diablo | 2021-12-31 | Contra Costa | 13 | 59 | 818 | |
456388 | 456388 | Discovery Bay | Discovery Bay | 2021-12-31 | Contra Costa | 13 | 1641 | 13352 | |
456389 | 456389 | El Cerrito | El Cerrito | 2021-12-31 | Contra Costa | 13 | 1220 | 24953 | |
456390 | 456390 | Hercules | Hercules | 2021-12-31 | Contra Costa | 13 | 2186 | 25530 | |
456391 | 456391 | Kensington | Kensington | 2021-12-31 | Contra Costa | 13 | 140 | 5077 | |
456392 | 456392 | Knightsen | Knightsen | 2021-12-31 | Contra Costa | 13 | 39 | 1500 | |
456393 | 456393 | Lafayette | Lafayette | 2021-12-31 | Contra Costa | 13 | 1269 | 25604 | |
456394 | 456394 | Martinez | Martinez | 2021-12-31 | Contra Costa | 13 | 3638 | 37106 | |
456395 | 456395 | Moraga | Moraga | 2021-12-31 | Contra Costa | 13 | 604 | 16946 | |
456396 | 456396 | Oakley | Oakley | 2021-12-31 | Contra Costa | 13 | 5851 | 42461 | |
456397 | 456397 | Orinda | Orinda | 2021-12-31 | Contra Costa | 13 | 816 | 19009 | |
456398 | 456398 | Pacheco | Pacheco | 2021-12-31 | Contra Costa | 13 | 358 | 3685 | |
456399 | 456399 | Pinole | Pinole | 2021-12-31 | Contra Costa | 13 | 1799 | 19505 | |
456400 | 456400 | Pittsburg | Pittsburg | 2021-12-31 | Contra Costa | 13 | 10207 | 74321 | |
456401 | 456401 | Pleasant Hill | Pleasant Hill | 2021-12-31 | Contra Costa | 13 | 2157 | 34267 | |
456402 | 456402 | Richmond | Richmond | 2021-12-31 | Contra Costa | 13 | 16416 | 111217 | |
456403 | 456403 | Rodeo | Rodeo | 2021-12-31 | Contra Costa | 13 | 960 | 8679 | |
456404 | 456404 | San Pablo | San Pablo | 2021-12-31 | Contra Costa | 13 | 7073 | 31413 | |
456405 | 456405 | San Ramon | San Ramon | 2021-12-31 | Contra Costa | 13 | 4008 | 83118 | |
456406 | 456406 | Walnut Creek | Walnut Creek | 2021-12-31 | Contra Costa | 13 | 5180 | 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 );