latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
29,970 rows where county = "Contra Costa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
596747 | 596747 | Diablo | Diablo | 2021-09-12 | Contra Costa | 13 | 48 | 818 | |
596748 | 596748 | Discovery Bay | Discovery Bay | 2021-09-12 | Contra Costa | 13 | 1334 | 13352 | |
596749 | 596749 | El Cerrito | El Cerrito | 2021-09-12 | Contra Costa | 13 | 964 | 24953 | |
596750 | 596750 | Hercules | Hercules | 2021-09-12 | Contra Costa | 13 | 1762 | 25530 | |
596751 | 596751 | Kensington | Kensington | 2021-09-12 | Contra Costa | 13 | 85 | 5077 | |
596752 | 596752 | Knightsen | Knightsen | 2021-09-12 | Contra Costa | 13 | 33 | 1500 | |
596753 | 596753 | Lafayette | Lafayette | 2021-09-12 | Contra Costa | 13 | 885 | 25604 | |
596754 | 596754 | Martinez | Martinez | 2021-09-12 | Contra Costa | 13 | 2905 | 37106 | |
596755 | 596755 | Moraga | Moraga | 2021-09-12 | Contra Costa | 13 | 437 | 16946 | |
596756 | 596756 | Oakley | Oakley | 2021-09-12 | Contra Costa | 13 | 4827 | 42461 | |
596757 | 596757 | Orinda | Orinda | 2021-09-12 | Contra Costa | 13 | 550 | 19009 | |
596758 | 596758 | Pacheco | Pacheco | 2021-09-12 | Contra Costa | 13 | 305 | 3685 | |
596759 | 596759 | Pinole | Pinole | 2021-09-12 | Contra Costa | 13 | 1505 | 19505 | |
596760 | 596760 | Pittsburg | Pittsburg | 2021-09-12 | Contra Costa | 13 | 8942 | 74321 | |
596761 | 596761 | Pleasant Hill | Pleasant Hill | 2021-09-12 | Contra Costa | 13 | 1667 | 34267 | |
596762 | 596762 | Richmond | Richmond | 2021-09-12 | Contra Costa | 13 | 14398 | 111217 | |
596763 | 596763 | Rodeo | Rodeo | 2021-09-12 | Contra Costa | 13 | 799 | 8679 | |
596764 | 596764 | San Pablo | San Pablo | 2021-09-12 | Contra Costa | 13 | 6296 | 31413 | |
596765 | 596765 | San Ramon | San Ramon | 2021-09-12 | Contra Costa | 13 | 2951 | 83118 | |
596766 | 596766 | Walnut Creek | Walnut Creek | 2021-09-12 | Contra Costa | 13 | 3953 | 70860 | |
598013 | 598013 | Alamo | Alamo | 2021-09-11 | Contra Costa | 13 | 677 | 14750 | |
598014 | 598014 | Antioch | Antioch | 2021-09-11 | Contra Costa | 13 | 13613 | 112520 | |
598015 | 598015 | Bay Point | Bay Point | 2021-09-11 | Contra Costa | 13 | 3581 | 22639 | |
598016 | 598016 | Bethel Island | Bethel Island | 2021-09-11 | Contra Costa | 13 | 144 | 2137 | |
598017 | 598017 | Brentwood | Brentwood | 2021-09-11 | Contra Costa | 13 | 5737 | 65118 | |
598018 | 598018 | Byron | Byron | 2021-09-11 | Contra Costa | 13 | 166 | 1325 | |
598019 | 598019 | Clayton | Clayton | 2021-09-11 | Contra Costa | 13 | 598 | 11337 | |
598020 | 598020 | Concord | Concord | 2021-09-11 | Contra Costa | 13 | 10431 | 130143 | |
598021 | 598021 | Crockett | Crockett | 2021-09-11 | Contra Costa | 13 | 206 | 3044 | |
598022 | 598022 | Danville | Danville | 2021-09-11 | Contra Costa | 13 | 2268 | 43876 | |
598023 | 598023 | Diablo | Diablo | 2021-09-11 | Contra Costa | 13 | 48 | 818 | |
598024 | 598024 | Discovery Bay | Discovery Bay | 2021-09-11 | Contra Costa | 13 | 1325 | 13352 | |
598025 | 598025 | El Cerrito | El Cerrito | 2021-09-11 | Contra Costa | 13 | 958 | 24953 | |
598026 | 598026 | Hercules | Hercules | 2021-09-11 | Contra Costa | 13 | 1760 | 25530 | |
598027 | 598027 | Kensington | Kensington | 2021-09-11 | Contra Costa | 13 | 84 | 5077 | |
598028 | 598028 | Knightsen | Knightsen | 2021-09-11 | Contra Costa | 13 | 33 | 1500 | |
598029 | 598029 | Lafayette | Lafayette | 2021-09-11 | Contra Costa | 13 | 884 | 25604 | |
598030 | 598030 | Martinez | Martinez | 2021-09-11 | Contra Costa | 13 | 2890 | 37106 | |
598031 | 598031 | Moraga | Moraga | 2021-09-11 | Contra Costa | 13 | 437 | 16946 | |
598032 | 598032 | Oakley | Oakley | 2021-09-11 | Contra Costa | 13 | 4815 | 42461 | |
598033 | 598033 | Orinda | Orinda | 2021-09-11 | Contra Costa | 13 | 549 | 19009 | |
598034 | 598034 | Pacheco | Pacheco | 2021-09-11 | Contra Costa | 13 | 305 | 3685 | |
598035 | 598035 | Pinole | Pinole | 2021-09-11 | Contra Costa | 13 | 1499 | 19505 | |
598036 | 598036 | Pittsburg | Pittsburg | 2021-09-11 | Contra Costa | 13 | 8928 | 74321 | |
598037 | 598037 | Pleasant Hill | Pleasant Hill | 2021-09-11 | Contra Costa | 13 | 1661 | 34267 | |
598038 | 598038 | Richmond | Richmond | 2021-09-11 | Contra Costa | 13 | 14367 | 111217 | |
598039 | 598039 | Rodeo | Rodeo | 2021-09-11 | Contra Costa | 13 | 797 | 8679 | |
598040 | 598040 | San Pablo | San Pablo | 2021-09-11 | Contra Costa | 13 | 6278 | 31413 | |
598041 | 598041 | San Ramon | San Ramon | 2021-09-11 | Contra Costa | 13 | 2942 | 83118 | |
598042 | 598042 | Walnut Creek | Walnut Creek | 2021-09-11 | Contra Costa | 13 | 3944 | 70860 | |
599289 | 599289 | Alamo | Alamo | 2021-09-10 | Contra Costa | 13 | 675 | 14750 | |
599290 | 599290 | Antioch | Antioch | 2021-09-10 | Contra Costa | 13 | 13586 | 112520 | |
599291 | 599291 | Bay Point | Bay Point | 2021-09-10 | Contra Costa | 13 | 3570 | 22639 | |
599292 | 599292 | Bethel Island | Bethel Island | 2021-09-10 | Contra Costa | 13 | 144 | 2137 | |
599293 | 599293 | Brentwood | Brentwood | 2021-09-10 | Contra Costa | 13 | 5717 | 65118 | |
599294 | 599294 | Byron | Byron | 2021-09-10 | Contra Costa | 13 | 165 | 1325 | |
599295 | 599295 | Clayton | Clayton | 2021-09-10 | Contra Costa | 13 | 596 | 11337 | |
599296 | 599296 | Concord | Concord | 2021-09-10 | Contra Costa | 13 | 10392 | 130143 | |
599297 | 599297 | Crockett | Crockett | 2021-09-10 | Contra Costa | 13 | 204 | 3044 | |
599298 | 599298 | Danville | Danville | 2021-09-10 | Contra Costa | 13 | 2255 | 43876 | |
599299 | 599299 | Diablo | Diablo | 2021-09-10 | Contra Costa | 13 | 48 | 818 | |
599300 | 599300 | Discovery Bay | Discovery Bay | 2021-09-10 | Contra Costa | 13 | 1322 | 13352 | |
599301 | 599301 | El Cerrito | El Cerrito | 2021-09-10 | Contra Costa | 13 | 957 | 24953 | |
599302 | 599302 | Hercules | Hercules | 2021-09-10 | Contra Costa | 13 | 1756 | 25530 | |
599303 | 599303 | Kensington | Kensington | 2021-09-10 | Contra Costa | 13 | 84 | 5077 | |
599304 | 599304 | Knightsen | Knightsen | 2021-09-10 | Contra Costa | 13 | 32 | 1500 | |
599305 | 599305 | Lafayette | Lafayette | 2021-09-10 | Contra Costa | 13 | 883 | 25604 | |
599306 | 599306 | Martinez | Martinez | 2021-09-10 | Contra Costa | 13 | 2878 | 37106 | |
599307 | 599307 | Moraga | Moraga | 2021-09-10 | Contra Costa | 13 | 435 | 16946 | |
599308 | 599308 | Oakley | Oakley | 2021-09-10 | Contra Costa | 13 | 4792 | 42461 | |
599309 | 599309 | Orinda | Orinda | 2021-09-10 | Contra Costa | 13 | 549 | 19009 | |
599310 | 599310 | Pacheco | Pacheco | 2021-09-10 | Contra Costa | 13 | 305 | 3685 | |
599311 | 599311 | Pinole | Pinole | 2021-09-10 | Contra Costa | 13 | 1496 | 19505 | |
599312 | 599312 | Pittsburg | Pittsburg | 2021-09-10 | Contra Costa | 13 | 8902 | 74321 | |
599313 | 599313 | Pleasant Hill | Pleasant Hill | 2021-09-10 | Contra Costa | 13 | 1652 | 34267 | |
599314 | 599314 | Richmond | Richmond | 2021-09-10 | Contra Costa | 13 | 14351 | 111217 | |
599315 | 599315 | Rodeo | Rodeo | 2021-09-10 | Contra Costa | 13 | 796 | 8679 | |
599316 | 599316 | San Pablo | San Pablo | 2021-09-10 | Contra Costa | 13 | 6269 | 31413 | |
599317 | 599317 | San Ramon | San Ramon | 2021-09-10 | Contra Costa | 13 | 2927 | 83118 | |
599318 | 599318 | Walnut Creek | Walnut Creek | 2021-09-10 | Contra Costa | 13 | 3937 | 70860 | |
600565 | 600565 | Alamo | Alamo | 2021-09-09 | Contra Costa | 13 | 672 | 14750 | |
600566 | 600566 | Antioch | Antioch | 2021-09-09 | Contra Costa | 13 | 13537 | 112520 | |
600567 | 600567 | Bay Point | Bay Point | 2021-09-09 | Contra Costa | 13 | 3561 | 22639 | |
600568 | 600568 | Bethel Island | Bethel Island | 2021-09-09 | Contra Costa | 13 | 140 | 2137 | |
600569 | 600569 | Brentwood | Brentwood | 2021-09-09 | Contra Costa | 13 | 5701 | 65118 | |
600570 | 600570 | Byron | Byron | 2021-09-09 | Contra Costa | 13 | 163 | 1325 | |
600571 | 600571 | Clayton | Clayton | 2021-09-09 | Contra Costa | 13 | 593 | 11337 | |
600572 | 600572 | Concord | Concord | 2021-09-09 | Contra Costa | 13 | 10363 | 130143 | |
600573 | 600573 | Crockett | Crockett | 2021-09-09 | Contra Costa | 13 | 204 | 3044 | |
600574 | 600574 | Danville | Danville | 2021-09-09 | Contra Costa | 13 | 2248 | 43876 | |
600575 | 600575 | Diablo | Diablo | 2021-09-09 | Contra Costa | 13 | 48 | 818 | |
600576 | 600576 | Discovery Bay | Discovery Bay | 2021-09-09 | Contra Costa | 13 | 1320 | 13352 | |
600577 | 600577 | El Cerrito | El Cerrito | 2021-09-09 | Contra Costa | 13 | 957 | 24953 | |
600578 | 600578 | Hercules | Hercules | 2021-09-09 | Contra Costa | 13 | 1747 | 25530 | |
600579 | 600579 | Kensington | Kensington | 2021-09-09 | Contra Costa | 13 | 84 | 5077 | |
600580 | 600580 | Knightsen | Knightsen | 2021-09-09 | Contra Costa | 13 | 32 | 1500 | |
600581 | 600581 | Lafayette | Lafayette | 2021-09-09 | Contra Costa | 13 | 880 | 25604 | |
600582 | 600582 | Martinez | Martinez | 2021-09-09 | Contra Costa | 13 | 2854 | 37106 | |
600583 | 600583 | Moraga | Moraga | 2021-09-09 | Contra Costa | 13 | 434 | 16946 | |
600584 | 600584 | Oakley | Oakley | 2021-09-09 | Contra Costa | 13 | 4759 | 42461 |
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 );