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-03-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 |
---|---|---|---|---|---|---|---|---|---|
845557 | 845557 | Alamo | Alamo | 2021-03-01 | Contra Costa | 13 | 424 | 14750 | |
845558 | 845558 | Antioch | Antioch | 2021-03-01 | Contra Costa | 13 | 8683 | 112520 | |
845559 | 845559 | Bay Point | Bay Point | 2021-03-01 | Contra Costa | 13 | 2572 | 22639 | |
845560 | 845560 | Bethel Island | Bethel Island | 2021-03-01 | Contra Costa | 13 | 64 | 2137 | |
845561 | 845561 | Brentwood | Brentwood | 2021-03-01 | Contra Costa | 13 | 3405 | 65118 | |
845562 | 845562 | Byron | Byron | 2021-03-01 | Contra Costa | 13 | 97 | 1325 | |
845563 | 845563 | Clayton | Clayton | 2021-03-01 | Contra Costa | 13 | 377 | 11337 | |
845564 | 845564 | Concord | Concord | 2021-03-01 | Contra Costa | 13 | 7388 | 130143 | |
845565 | 845565 | Crockett | Crockett | 2021-03-01 | Contra Costa | 13 | 112 | 3044 | |
845566 | 845566 | Danville | Danville | 2021-03-01 | Contra Costa | 13 | 1477 | 43876 | |
845567 | 845567 | Diablo | Diablo | 2021-03-01 | Contra Costa | 13 | 32 | 818 | |
845568 | 845568 | Discovery Bay | Discovery Bay | 2021-03-01 | Contra Costa | 13 | 761 | 13352 | |
845569 | 845569 | El Cerrito | El Cerrito | 2021-03-01 | Contra Costa | 13 | 639 | 24953 | |
845570 | 845570 | Hercules | Hercules | 2021-03-01 | Contra Costa | 13 | 1152 | 25530 | |
845571 | 845571 | Kensington | Kensington | 2021-03-01 | Contra Costa | 13 | 42 | 5077 | |
845572 | 845572 | Knightsen | Knightsen | 2021-03-01 | Contra Costa | 13 | 22 | 1500 | |
845573 | 845573 | Lafayette | Lafayette | 2021-03-01 | Contra Costa | 13 | 562 | 25604 | |
845574 | 845574 | Martinez | Martinez | 2021-03-01 | Contra Costa | 13 | 1806 | 37106 | |
845575 | 845575 | Moraga | Moraga | 2021-03-01 | Contra Costa | 13 | 290 | 16946 | |
845576 | 845576 | Oakley | Oakley | 2021-03-01 | Contra Costa | 13 | 2837 | 42461 | |
845577 | 845577 | Orinda | Orinda | 2021-03-01 | Contra Costa | 13 | 388 | 19009 | |
845578 | 845578 | Pacheco | Pacheco | 2021-03-01 | Contra Costa | 13 | 213 | 3685 | |
845579 | 845579 | Pinole | Pinole | 2021-03-01 | Contra Costa | 13 | 1031 | 19505 | |
845580 | 845580 | Pittsburg | Pittsburg | 2021-03-01 | Contra Costa | 13 | 6234 | 74321 | |
845581 | 845581 | Pleasant Hill | Pleasant Hill | 2021-03-01 | Contra Costa | 13 | 1105 | 34267 | |
845582 | 845582 | Richmond | Richmond | 2021-03-01 | Contra Costa | 13 | 9528 | 111217 | |
845583 | 845583 | Rodeo | Rodeo | 2021-03-01 | Contra Costa | 13 | 542 | 8679 | |
845584 | 845584 | San Pablo | San Pablo | 2021-03-01 | Contra Costa | 13 | 4884 | 31413 | |
845585 | 845585 | San Ramon | San Ramon | 2021-03-01 | Contra Costa | 13 | 1857 | 83118 | |
845586 | 845586 | Walnut Creek | Walnut Creek | 2021-03-01 | Contra Costa | 13 | 2566 | 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 );