latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
30 rows where county = "Contra Costa" and "date" is on date 2021-07-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
686057 | 686057 | Alamo | Alamo | 2021-07-04 | Contra Costa | 13 | 501 | 14750 | |
686058 | 686058 | Antioch | Antioch | 2021-07-04 | Contra Costa | 13 | 10107 | 112520 | |
686059 | 686059 | Bay Point | Bay Point | 2021-07-04 | Contra Costa | 13 | 2843 | 22639 | |
686060 | 686060 | Bethel Island | Bethel Island | 2021-07-04 | Contra Costa | 13 | 80 | 2137 | |
686061 | 686061 | Brentwood | Brentwood | 2021-07-04 | Contra Costa | 13 | 4016 | 65118 | |
686062 | 686062 | Byron | Byron | 2021-07-04 | Contra Costa | 13 | 111 | 1325 | |
686063 | 686063 | Clayton | Clayton | 2021-07-04 | Contra Costa | 13 | 439 | 11337 | |
686064 | 686064 | Concord | Concord | 2021-07-04 | Contra Costa | 13 | 8288 | 130143 | |
686065 | 686065 | Crockett | Crockett | 2021-07-04 | Contra Costa | 13 | 132 | 3044 | |
686066 | 686066 | Danville | Danville | 2021-07-04 | Contra Costa | 13 | 1688 | 43876 | |
686067 | 686067 | Diablo | Diablo | 2021-07-04 | Contra Costa | 13 | 38 | 818 | |
686068 | 686068 | Discovery Bay | Discovery Bay | 2021-07-04 | Contra Costa | 13 | 912 | 13352 | |
686069 | 686069 | El Cerrito | El Cerrito | 2021-07-04 | Contra Costa | 13 | 732 | 24953 | |
686070 | 686070 | Hercules | Hercules | 2021-07-04 | Contra Costa | 13 | 1314 | 25530 | |
686071 | 686071 | Kensington | Kensington | 2021-07-04 | Contra Costa | 13 | 48 | 5077 | |
686072 | 686072 | Knightsen | Knightsen | 2021-07-04 | Contra Costa | 13 | 26 | 1500 | |
686073 | 686073 | Lafayette | Lafayette | 2021-07-04 | Contra Costa | 13 | 645 | 25604 | |
686074 | 686074 | Martinez | Martinez | 2021-07-04 | Contra Costa | 13 | 2021 | 37106 | |
686075 | 686075 | Moraga | Moraga | 2021-07-04 | Contra Costa | 13 | 347 | 16946 | |
686076 | 686076 | Oakley | Oakley | 2021-07-04 | Contra Costa | 13 | 3401 | 42461 | |
686077 | 686077 | Orinda | Orinda | 2021-07-04 | Contra Costa | 13 | 419 | 19009 | |
686078 | 686078 | Pacheco | Pacheco | 2021-07-04 | Contra Costa | 13 | 250 | 3685 | |
686079 | 686079 | Pinole | Pinole | 2021-07-04 | Contra Costa | 13 | 1178 | 19505 | |
686080 | 686080 | Pittsburg | Pittsburg | 2021-07-04 | Contra Costa | 13 | 7119 | 74321 | |
686081 | 686081 | Pleasant Hill | Pleasant Hill | 2021-07-04 | Contra Costa | 13 | 1253 | 34267 | |
686082 | 686082 | Richmond | Richmond | 2021-07-04 | Contra Costa | 13 | 11935 | 111217 | |
686083 | 686083 | Rodeo | Rodeo | 2021-07-04 | Contra Costa | 13 | 614 | 8679 | |
686084 | 686084 | San Pablo | San Pablo | 2021-07-04 | Contra Costa | 13 | 5411 | 31413 | |
686085 | 686085 | San Ramon | San Ramon | 2021-07-04 | Contra Costa | 13 | 2170 | 83118 | |
686086 | 686086 | Walnut Creek | Walnut Creek | 2021-07-04 | Contra Costa | 13 | 2954 | 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 );