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-04-06 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 |
---|---|---|---|---|---|---|---|---|---|
799621 | 799621 | Alamo | Alamo | 2021-04-06 | Contra Costa | 13 | 463 | 14750 | |
799622 | 799622 | Antioch | Antioch | 2021-04-06 | Contra Costa | 13 | 9116 | 112520 | |
799623 | 799623 | Bay Point | Bay Point | 2021-04-06 | Contra Costa | 13 | 2662 | 22639 | |
799624 | 799624 | Bethel Island | Bethel Island | 2021-04-06 | Contra Costa | 13 | 66 | 2137 | |
799625 | 799625 | Brentwood | Brentwood | 2021-04-06 | Contra Costa | 13 | 3614 | 65118 | |
799626 | 799626 | Byron | Byron | 2021-04-06 | Contra Costa | 13 | 99 | 1325 | |
799627 | 799627 | Clayton | Clayton | 2021-04-06 | Contra Costa | 13 | 393 | 11337 | |
799628 | 799628 | Concord | Concord | 2021-04-06 | Contra Costa | 13 | 7715 | 130143 | |
799629 | 799629 | Crockett | Crockett | 2021-04-06 | Contra Costa | 13 | 123 | 3044 | |
799630 | 799630 | Danville | Danville | 2021-04-06 | Contra Costa | 13 | 1554 | 43876 | |
799631 | 799631 | Diablo | Diablo | 2021-04-06 | Contra Costa | 13 | 36 | 818 | |
799632 | 799632 | Discovery Bay | Discovery Bay | 2021-04-06 | Contra Costa | 13 | 809 | 13352 | |
799633 | 799633 | El Cerrito | El Cerrito | 2021-04-06 | Contra Costa | 13 | 678 | 24953 | |
799634 | 799634 | Hercules | Hercules | 2021-04-06 | Contra Costa | 13 | 1207 | 25530 | |
799635 | 799635 | Kensington | Kensington | 2021-04-06 | Contra Costa | 13 | 45 | 5077 | |
799636 | 799636 | Knightsen | Knightsen | 2021-04-06 | Contra Costa | 13 | 23 | 1500 | |
799637 | 799637 | Lafayette | Lafayette | 2021-04-06 | Contra Costa | 13 | 595 | 25604 | |
799638 | 799638 | Martinez | Martinez | 2021-04-06 | Contra Costa | 13 | 1892 | 37106 | |
799639 | 799639 | Moraga | Moraga | 2021-04-06 | Contra Costa | 13 | 309 | 16946 | |
799640 | 799640 | Oakley | Oakley | 2021-04-06 | Contra Costa | 13 | 2992 | 42461 | |
799641 | 799641 | Orinda | Orinda | 2021-04-06 | Contra Costa | 13 | 401 | 19009 | |
799642 | 799642 | Pacheco | Pacheco | 2021-04-06 | Contra Costa | 13 | 226 | 3685 | |
799643 | 799643 | Pinole | Pinole | 2021-04-06 | Contra Costa | 13 | 1088 | 19505 | |
799644 | 799644 | Pittsburg | Pittsburg | 2021-04-06 | Contra Costa | 13 | 6558 | 74321 | |
799645 | 799645 | Pleasant Hill | Pleasant Hill | 2021-04-06 | Contra Costa | 13 | 1154 | 34267 | |
799646 | 799646 | Richmond | Richmond | 2021-04-06 | Contra Costa | 13 | 9951 | 111217 | |
799647 | 799647 | Rodeo | Rodeo | 2021-04-06 | Contra Costa | 13 | 560 | 8679 | |
799648 | 799648 | San Pablo | San Pablo | 2021-04-06 | Contra Costa | 13 | 5094 | 31413 | |
799649 | 799649 | San Ramon | San Ramon | 2021-04-06 | Contra Costa | 13 | 1984 | 83118 | |
799650 | 799650 | Walnut Creek | Walnut Creek | 2021-04-06 | Contra Costa | 13 | 2720 | 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 );