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-13 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 |
---|---|---|---|---|---|---|---|---|---|
55667 | 55667 | Alamo | Alamo | 2022-11-13 | Contra Costa | 13 | 2361 | 14750 | |
55668 | 55668 | Antioch | Antioch | 2022-11-13 | Contra Costa | 13 | 35104 | 112520 | |
55669 | 55669 | Bay Point | Bay Point | 2022-11-13 | Contra Costa | 13 | 7989 | 22639 | |
55670 | 55670 | Bethel Island | Bethel Island | 2022-11-13 | Contra Costa | 13 | 372 | 2137 | |
55671 | 55671 | Brentwood | Brentwood | 2022-11-13 | Contra Costa | 13 | 18106 | 65118 | |
55672 | 55672 | Byron | Byron | 2022-11-13 | Contra Costa | 13 | 342 | 1325 | |
55673 | 55673 | Clayton | Clayton | 2022-11-13 | Contra Costa | 13 | 2064 | 11337 | |
55674 | 55674 | Concord | Concord | 2022-11-13 | Contra Costa | 13 | 28966 | 130143 | |
55675 | 55675 | Crockett | Crockett | 2022-11-13 | Contra Costa | 13 | 621 | 3044 | |
55676 | 55676 | Danville | Danville | 2022-11-13 | Contra Costa | 13 | 9387 | 43876 | |
55677 | 55677 | Diablo | Diablo | 2022-11-13 | Contra Costa | 13 | 152 | 818 | |
55678 | 55678 | Discovery Bay | Discovery Bay | 2022-11-13 | Contra Costa | 13 | 3299 | 13352 | |
55679 | 55679 | El Cerrito | El Cerrito | 2022-11-13 | Contra Costa | 13 | 4254 | 24953 | |
55680 | 55680 | Hercules | Hercules | 2022-11-13 | Contra Costa | 13 | 6290 | 25530 | |
55681 | 55681 | Kensington | Kensington | 2022-11-13 | Contra Costa | 13 | 551 | 5077 | |
55682 | 55682 | Knightsen | Knightsen | 2022-11-13 | Contra Costa | 13 | 104 | 1500 | |
55683 | 55683 | Lafayette | Lafayette | 2022-11-13 | Contra Costa | 13 | 4185 | 25604 | |
55684 | 55684 | Martinez | Martinez | 2022-11-13 | Contra Costa | 13 | 10030 | 37106 | |
55685 | 55685 | Moraga | Moraga | 2022-11-13 | Contra Costa | 13 | 2220 | 16946 | |
55686 | 55686 | Oakley | Oakley | 2022-11-13 | Contra Costa | 13 | 13326 | 42461 | |
55687 | 55687 | Orinda | Orinda | 2022-11-13 | Contra Costa | 13 | 2698 | 19009 | |
55688 | 55688 | Pacheco | Pacheco | 2022-11-13 | Contra Costa | 13 | 975 | 3685 | |
55689 | 55689 | Pinole | Pinole | 2022-11-13 | Contra Costa | 13 | 4784 | 19505 | |
55690 | 55690 | Pittsburg | Pittsburg | 2022-11-13 | Contra Costa | 13 | 21838 | 74321 | |
55691 | 55691 | Pleasant Hill | Pleasant Hill | 2022-11-13 | Contra Costa | 13 | 6730 | 34267 | |
55692 | 55692 | Richmond | Richmond | 2022-11-13 | Contra Costa | 13 | 38133 | 111217 | |
55693 | 55693 | Rodeo | Rodeo | 2022-11-13 | Contra Costa | 13 | 2470 | 8679 | |
55694 | 55694 | San Pablo | San Pablo | 2022-11-13 | Contra Costa | 13 | 15991 | 31413 | |
55695 | 55695 | San Ramon | San Ramon | 2022-11-13 | Contra Costa | 13 | 14393 | 83118 | |
55696 | 55696 | Walnut Creek | Walnut Creek | 2022-11-13 | Contra Costa | 13 | 14937 | 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 );