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 |
---|---|---|---|---|---|---|---|---|---|
442399 | 442399 | Diablo | Diablo | 2022-01-11 | Contra Costa | 13 | 68 | 818 | |
442400 | 442400 | Discovery Bay | Discovery Bay | 2022-01-11 | Contra Costa | 13 | 1842 | 13352 | |
442401 | 442401 | El Cerrito | El Cerrito | 2022-01-11 | Contra Costa | 13 | 1655 | 24953 | |
442402 | 442402 | Hercules | Hercules | 2022-01-11 | Contra Costa | 13 | 2871 | 25530 | |
442403 | 442403 | Kensington | Kensington | 2022-01-11 | Contra Costa | 13 | 198 | 5077 | |
442404 | 442404 | Knightsen | Knightsen | 2022-01-11 | Contra Costa | 13 | 47 | 1500 | |
442405 | 442405 | Lafayette | Lafayette | 2022-01-11 | Contra Costa | 13 | 1574 | 25604 | |
442406 | 442406 | Martinez | Martinez | 2022-01-11 | Contra Costa | 13 | 4401 | 37106 | |
442407 | 442407 | Moraga | Moraga | 2022-01-11 | Contra Costa | 13 | 802 | 16946 | |
442408 | 442408 | Oakley | Oakley | 2022-01-11 | Contra Costa | 13 | 6800 | 42461 | |
442409 | 442409 | Orinda | Orinda | 2022-01-11 | Contra Costa | 13 | 1111 | 19009 | |
442410 | 442410 | Pacheco | Pacheco | 2022-01-11 | Contra Costa | 13 | 437 | 3685 | |
442411 | 442411 | Pinole | Pinole | 2022-01-11 | Contra Costa | 13 | 2231 | 19505 | |
442412 | 442412 | Pittsburg | Pittsburg | 2022-01-11 | Contra Costa | 13 | 11760 | 74321 | |
442413 | 442413 | Pleasant Hill | Pleasant Hill | 2022-01-11 | Contra Costa | 13 | 2716 | 34267 | |
442414 | 442414 | Richmond | Richmond | 2022-01-11 | Contra Costa | 13 | 19537 | 111217 | |
442415 | 442415 | Rodeo | Rodeo | 2022-01-11 | Contra Costa | 13 | 1207 | 8679 | |
442416 | 442416 | San Pablo | San Pablo | 2022-01-11 | Contra Costa | 13 | 8262 | 31413 | |
442417 | 442417 | San Ramon | San Ramon | 2022-01-11 | Contra Costa | 13 | 5333 | 83118 | |
442418 | 442418 | Walnut Creek | Walnut Creek | 2022-01-11 | Contra Costa | 13 | 6398 | 70860 | |
443657 | 443657 | Alamo | Alamo | 2022-01-10 | Contra Costa | 13 | 1109 | 14750 | |
443658 | 443658 | Antioch | Antioch | 2022-01-10 | Contra Costa | 13 | 18098 | 112520 | |
443659 | 443659 | Bay Point | Bay Point | 2022-01-10 | Contra Costa | 13 | 4546 | 22639 | |
443660 | 443660 | Bethel Island | Bethel Island | 2022-01-10 | Contra Costa | 13 | 191 | 2137 | |
443661 | 443661 | Brentwood | Brentwood | 2022-01-10 | Contra Costa | 13 | 8235 | 65118 | |
443662 | 443662 | Byron | Byron | 2022-01-10 | Contra Costa | 13 | 210 | 1325 | |
443663 | 443663 | Clayton | Clayton | 2022-01-10 | Contra Costa | 13 | 969 | 11337 | |
443664 | 443664 | Concord | Concord | 2022-01-10 | Contra Costa | 13 | 14176 | 130143 | |
443665 | 443665 | Crockett | Crockett | 2022-01-10 | Contra Costa | 13 | 287 | 3044 | |
443666 | 443666 | Danville | Danville | 2022-01-10 | Contra Costa | 13 | 3990 | 43876 | |
443667 | 443667 | Diablo | Diablo | 2022-01-10 | Contra Costa | 13 | 66 | 818 | |
443668 | 443668 | Discovery Bay | Discovery Bay | 2022-01-10 | Contra Costa | 13 | 1822 | 13352 | |
443669 | 443669 | El Cerrito | El Cerrito | 2022-01-10 | Contra Costa | 13 | 1596 | 24953 | |
443670 | 443670 | Hercules | Hercules | 2022-01-10 | Contra Costa | 13 | 2798 | 25530 | |
443671 | 443671 | Kensington | Kensington | 2022-01-10 | Contra Costa | 13 | 192 | 5077 | |
443672 | 443672 | Knightsen | Knightsen | 2022-01-10 | Contra Costa | 13 | 46 | 1500 | |
443673 | 443673 | Lafayette | Lafayette | 2022-01-10 | Contra Costa | 13 | 1550 | 25604 | |
443674 | 443674 | Martinez | Martinez | 2022-01-10 | Contra Costa | 13 | 4328 | 37106 | |
443675 | 443675 | Moraga | Moraga | 2022-01-10 | Contra Costa | 13 | 790 | 16946 | |
443676 | 443676 | Oakley | Oakley | 2022-01-10 | Contra Costa | 13 | 6694 | 42461 | |
443677 | 443677 | Orinda | Orinda | 2022-01-10 | Contra Costa | 13 | 1083 | 19009 | |
443678 | 443678 | Pacheco | Pacheco | 2022-01-10 | Contra Costa | 13 | 428 | 3685 | |
443679 | 443679 | Pinole | Pinole | 2022-01-10 | Contra Costa | 13 | 2194 | 19505 | |
443680 | 443680 | Pittsburg | Pittsburg | 2022-01-10 | Contra Costa | 13 | 11548 | 74321 | |
443681 | 443681 | Pleasant Hill | Pleasant Hill | 2022-01-10 | Contra Costa | 13 | 2641 | 34267 | |
443682 | 443682 | Richmond | Richmond | 2022-01-10 | Contra Costa | 13 | 19170 | 111217 | |
443683 | 443683 | Rodeo | Rodeo | 2022-01-10 | Contra Costa | 13 | 1183 | 8679 | |
443684 | 443684 | San Pablo | San Pablo | 2022-01-10 | Contra Costa | 13 | 8141 | 31413 | |
443685 | 443685 | San Ramon | San Ramon | 2022-01-10 | Contra Costa | 13 | 5146 | 83118 | |
443686 | 443686 | Walnut Creek | Walnut Creek | 2022-01-10 | Contra Costa | 13 | 6296 | 70860 | |
444925 | 444925 | Alamo | Alamo | 2022-01-09 | Contra Costa | 13 | 1096 | 14750 | |
444926 | 444926 | Antioch | Antioch | 2022-01-09 | Contra Costa | 13 | 17828 | 112520 | |
444927 | 444927 | Bay Point | Bay Point | 2022-01-09 | Contra Costa | 13 | 4488 | 22639 | |
444928 | 444928 | Bethel Island | Bethel Island | 2022-01-09 | Contra Costa | 13 | 189 | 2137 | |
444929 | 444929 | Brentwood | Brentwood | 2022-01-09 | Contra Costa | 13 | 8096 | 65118 | |
444930 | 444930 | Byron | Byron | 2022-01-09 | Contra Costa | 13 | 207 | 1325 | |
444931 | 444931 | Clayton | Clayton | 2022-01-09 | Contra Costa | 13 | 952 | 11337 | |
444932 | 444932 | Concord | Concord | 2022-01-09 | Contra Costa | 13 | 13968 | 130143 | |
444933 | 444933 | Crockett | Crockett | 2022-01-09 | Contra Costa | 13 | 285 | 3044 | |
444934 | 444934 | Danville | Danville | 2022-01-09 | Contra Costa | 13 | 3939 | 43876 | |
444935 | 444935 | Diablo | Diablo | 2022-01-09 | Contra Costa | 13 | 65 | 818 | |
444936 | 444936 | Discovery Bay | Discovery Bay | 2022-01-09 | Contra Costa | 13 | 1800 | 13352 | |
444937 | 444937 | El Cerrito | El Cerrito | 2022-01-09 | Contra Costa | 13 | 1561 | 24953 | |
444938 | 444938 | Hercules | Hercules | 2022-01-09 | Contra Costa | 13 | 2750 | 25530 | |
444939 | 444939 | Kensington | Kensington | 2022-01-09 | Contra Costa | 13 | 189 | 5077 | |
444940 | 444940 | Knightsen | Knightsen | 2022-01-09 | Contra Costa | 13 | 44 | 1500 | |
444941 | 444941 | Lafayette | Lafayette | 2022-01-09 | Contra Costa | 13 | 1535 | 25604 | |
444942 | 444942 | Martinez | Martinez | 2022-01-09 | Contra Costa | 13 | 4254 | 37106 | |
444943 | 444943 | Moraga | Moraga | 2022-01-09 | Contra Costa | 13 | 777 | 16946 | |
444944 | 444944 | Oakley | Oakley | 2022-01-09 | Contra Costa | 13 | 6608 | 42461 | |
444945 | 444945 | Orinda | Orinda | 2022-01-09 | Contra Costa | 13 | 1057 | 19009 | |
444946 | 444946 | Pacheco | Pacheco | 2022-01-09 | Contra Costa | 13 | 421 | 3685 | |
444947 | 444947 | Pinole | Pinole | 2022-01-09 | Contra Costa | 13 | 2144 | 19505 | |
444948 | 444948 | Pittsburg | Pittsburg | 2022-01-09 | Contra Costa | 13 | 11405 | 74321 | |
444949 | 444949 | Pleasant Hill | Pleasant Hill | 2022-01-09 | Contra Costa | 13 | 2580 | 34267 | |
444950 | 444950 | Richmond | Richmond | 2022-01-09 | Contra Costa | 13 | 18891 | 111217 | |
444951 | 444951 | Rodeo | Rodeo | 2022-01-09 | Contra Costa | 13 | 1168 | 8679 | |
444952 | 444952 | San Pablo | San Pablo | 2022-01-09 | Contra Costa | 13 | 8045 | 31413 | |
444953 | 444953 | San Ramon | San Ramon | 2022-01-09 | Contra Costa | 13 | 5059 | 83118 | |
444954 | 444954 | Walnut Creek | Walnut Creek | 2022-01-09 | Contra Costa | 13 | 6194 | 70860 | |
446193 | 446193 | Alamo | Alamo | 2022-01-08 | Contra Costa | 13 | 1063 | 14750 | |
446194 | 446194 | Antioch | Antioch | 2022-01-08 | Contra Costa | 13 | 17433 | 112520 | |
446195 | 446195 | Bay Point | Bay Point | 2022-01-08 | Contra Costa | 13 | 4390 | 22639 | |
446196 | 446196 | Bethel Island | Bethel Island | 2022-01-08 | Contra Costa | 13 | 179 | 2137 | |
446197 | 446197 | Brentwood | Brentwood | 2022-01-08 | Contra Costa | 13 | 7933 | 65118 | |
446198 | 446198 | Byron | Byron | 2022-01-08 | Contra Costa | 13 | 204 | 1325 | |
446199 | 446199 | Clayton | Clayton | 2022-01-08 | Contra Costa | 13 | 927 | 11337 | |
446200 | 446200 | Concord | Concord | 2022-01-08 | Contra Costa | 13 | 13638 | 130143 | |
446201 | 446201 | Crockett | Crockett | 2022-01-08 | Contra Costa | 13 | 282 | 3044 | |
446202 | 446202 | Danville | Danville | 2022-01-08 | Contra Costa | 13 | 3808 | 43876 | |
446203 | 446203 | Diablo | Diablo | 2022-01-08 | Contra Costa | 13 | 64 | 818 | |
446204 | 446204 | Discovery Bay | Discovery Bay | 2022-01-08 | Contra Costa | 13 | 1772 | 13352 | |
446205 | 446205 | El Cerrito | El Cerrito | 2022-01-08 | Contra Costa | 13 | 1491 | 24953 | |
446206 | 446206 | Hercules | Hercules | 2022-01-08 | Contra Costa | 13 | 2660 | 25530 | |
446207 | 446207 | Kensington | Kensington | 2022-01-08 | Contra Costa | 13 | 183 | 5077 | |
446208 | 446208 | Knightsen | Knightsen | 2022-01-08 | Contra Costa | 13 | 44 | 1500 | |
446209 | 446209 | Lafayette | Lafayette | 2022-01-08 | Contra Costa | 13 | 1496 | 25604 | |
446210 | 446210 | Martinez | Martinez | 2022-01-08 | Contra Costa | 13 | 4144 | 37106 | |
446211 | 446211 | Moraga | Moraga | 2022-01-08 | Contra Costa | 13 | 749 | 16946 | |
446212 | 446212 | Oakley | Oakley | 2022-01-08 | Contra Costa | 13 | 6512 | 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 );