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", "date" is on date 2021-06-20 and fips = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
703921 | 703921 | Alamo | Alamo | 2021-06-20 | Contra Costa | 13 | 498 | 14750 | |
703922 | 703922 | Antioch | Antioch | 2021-06-20 | Contra Costa | 13 | 9932 | 112520 | |
703923 | 703923 | Bay Point | Bay Point | 2021-06-20 | Contra Costa | 13 | 2827 | 22639 | |
703924 | 703924 | Bethel Island | Bethel Island | 2021-06-20 | Contra Costa | 13 | 76 | 2137 | |
703925 | 703925 | Brentwood | Brentwood | 2021-06-20 | Contra Costa | 13 | 3945 | 65118 | |
703926 | 703926 | Byron | Byron | 2021-06-20 | Contra Costa | 13 | 106 | 1325 | |
703927 | 703927 | Clayton | Clayton | 2021-06-20 | Contra Costa | 13 | 436 | 11337 | |
703928 | 703928 | Concord | Concord | 2021-06-20 | Contra Costa | 13 | 8194 | 130143 | |
703929 | 703929 | Crockett | Crockett | 2021-06-20 | Contra Costa | 13 | 132 | 3044 | |
703930 | 703930 | Danville | Danville | 2021-06-20 | Contra Costa | 13 | 1672 | 43876 | |
703931 | 703931 | Diablo | Diablo | 2021-06-20 | Contra Costa | 13 | 38 | 818 | |
703932 | 703932 | Discovery Bay | Discovery Bay | 2021-06-20 | Contra Costa | 13 | 895 | 13352 | |
703933 | 703933 | El Cerrito | El Cerrito | 2021-06-20 | Contra Costa | 13 | 718 | 24953 | |
703934 | 703934 | Hercules | Hercules | 2021-06-20 | Contra Costa | 13 | 1301 | 25530 | |
703935 | 703935 | Kensington | Kensington | 2021-06-20 | Contra Costa | 13 | 47 | 5077 | |
703936 | 703936 | Knightsen | Knightsen | 2021-06-20 | Contra Costa | 13 | 26 | 1500 | |
703937 | 703937 | Lafayette | Lafayette | 2021-06-20 | Contra Costa | 13 | 638 | 25604 | |
703938 | 703938 | Martinez | Martinez | 2021-06-20 | Contra Costa | 13 | 1996 | 37106 | |
703939 | 703939 | Moraga | Moraga | 2021-06-20 | Contra Costa | 13 | 343 | 16946 | |
703940 | 703940 | Oakley | Oakley | 2021-06-20 | Contra Costa | 13 | 3330 | 42461 | |
703941 | 703941 | Orinda | Orinda | 2021-06-20 | Contra Costa | 13 | 415 | 19009 | |
703942 | 703942 | Pacheco | Pacheco | 2021-06-20 | Contra Costa | 13 | 250 | 3685 | |
703943 | 703943 | Pinole | Pinole | 2021-06-20 | Contra Costa | 13 | 1163 | 19505 | |
703944 | 703944 | Pittsburg | Pittsburg | 2021-06-20 | Contra Costa | 13 | 7027 | 74321 | |
703945 | 703945 | Pleasant Hill | Pleasant Hill | 2021-06-20 | Contra Costa | 13 | 1239 | 34267 | |
703946 | 703946 | Richmond | Richmond | 2021-06-20 | Contra Costa | 13 | 11837 | 111217 | |
703947 | 703947 | Rodeo | Rodeo | 2021-06-20 | Contra Costa | 13 | 609 | 8679 | |
703948 | 703948 | San Pablo | San Pablo | 2021-06-20 | Contra Costa | 13 | 5368 | 31413 | |
703949 | 703949 | San Ramon | San Ramon | 2021-06-20 | Contra Costa | 13 | 2151 | 83118 | |
703950 | 703950 | Walnut Creek | Walnut Creek | 2021-06-20 | Contra Costa | 13 | 2924 | 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 );