latimes_place_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

17,100 rows where county = "Contra Costa" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

  • 13 17,100

county

  • Contra Costa · 17,100 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
79 79 Alamo Alamo 2021-10-27 Contra Costa 13 740   14750
80 80 Antioch Antioch 2021-10-27 Contra Costa 13 14462   112520
81 81 Bay Point Bay Point 2021-10-27 Contra Costa 13 3772   22639
82 82 Bethel Island Bethel Island 2021-10-27 Contra Costa 13 159   2137
83 83 Brentwood Brentwood 2021-10-27 Contra Costa 13 6170   65118
84 84 Byron Byron 2021-10-27 Contra Costa 13 178   1325
85 85 Clayton Clayton 2021-10-27 Contra Costa 13 676   11337
86 86 Concord Concord 2021-10-27 Contra Costa 13 11134   130143
87 87 Crockett Crockett 2021-10-27 Contra Costa 13 222   3044
88 88 Danville Danville 2021-10-27 Contra Costa 13 2492   43876
89 89 Diablo Diablo 2021-10-27 Contra Costa 13 50   818
90 90 Discovery Bay Discovery Bay 2021-10-27 Contra Costa 13 1438   13352
91 91 El Cerrito El Cerrito 2021-10-27 Contra Costa 13 1019   24953
92 92 Hercules Hercules 2021-10-27 Contra Costa 13 1858   25530
93 93 Kensington Kensington 2021-10-27 Contra Costa 13 96   5077
94 94 Knightsen Knightsen 2021-10-27 Contra Costa 13 35   1500
95 95 Lafayette Lafayette 2021-10-27 Contra Costa 13 982   25604
96 96 Martinez Martinez 2021-10-27 Contra Costa 13 3164   37106
97 97 Moraga Moraga 2021-10-27 Contra Costa 13 469   16946
98 98 Oakley Oakley 2021-10-27 Contra Costa 13 5221   42461
99 99 Orinda Orinda 2021-10-27 Contra Costa 13 589   19009
100 100 Pacheco Pacheco 2021-10-27 Contra Costa 13 329   3685
101 101 Pinole Pinole 2021-10-27 Contra Costa 13 1578   19505
102 102 Pittsburg Pittsburg 2021-10-27 Contra Costa 13 9465   74321
103 103 Pleasant Hill Pleasant Hill 2021-10-27 Contra Costa 13 1809   34267
104 104 Richmond Richmond 2021-10-27 Contra Costa 13 14958   111217
105 105 Rodeo Rodeo 2021-10-27 Contra Costa 13 869   8679
106 106 San Pablo San Pablo 2021-10-27 Contra Costa 13 6533   31413
107 107 San Ramon San Ramon 2021-10-27 Contra Costa 13 3208   83118
108 108 Walnut Creek Walnut Creek 2021-10-27 Contra Costa 13 4279   70860
1444 1444 Alamo Alamo 2021-10-26 Contra Costa 13 739   14750
1445 1445 Antioch Antioch 2021-10-26 Contra Costa 13 14448   112520
1446 1446 Bay Point Bay Point 2021-10-26 Contra Costa 13 3770   22639
1447 1447 Bethel Island Bethel Island 2021-10-26 Contra Costa 13 158   2137
1448 1448 Brentwood Brentwood 2021-10-26 Contra Costa 13 6163   65118
1449 1449 Byron Byron 2021-10-26 Contra Costa 13 178   1325
1450 1450 Clayton Clayton 2021-10-26 Contra Costa 13 673   11337
1451 1451 Concord Concord 2021-10-26 Contra Costa 13 11125   130143
1452 1452 Crockett Crockett 2021-10-26 Contra Costa 13 222   3044
1453 1453 Danville Danville 2021-10-26 Contra Costa 13 2489   43876
1454 1454 Diablo Diablo 2021-10-26 Contra Costa 13 50   818
1455 1455 Discovery Bay Discovery Bay 2021-10-26 Contra Costa 13 1437   13352
1456 1456 El Cerrito El Cerrito 2021-10-26 Contra Costa 13 1017   24953
1457 1457 Hercules Hercules 2021-10-26 Contra Costa 13 1856   25530
1458 1458 Kensington Kensington 2021-10-26 Contra Costa 13 96   5077
1459 1459 Knightsen Knightsen 2021-10-26 Contra Costa 13 35   1500
1460 1460 Lafayette Lafayette 2021-10-26 Contra Costa 13 981   25604
1461 1461 Martinez Martinez 2021-10-26 Contra Costa 13 3157   37106
1462 1462 Moraga Moraga 2021-10-26 Contra Costa 13 469   16946
1463 1463 Oakley Oakley 2021-10-26 Contra Costa 13 5218   42461
1464 1464 Orinda Orinda 2021-10-26 Contra Costa 13 589   19009
1465 1465 Pacheco Pacheco 2021-10-26 Contra Costa 13 329   3685
1466 1466 Pinole Pinole 2021-10-26 Contra Costa 13 1577   19505
1467 1467 Pittsburg Pittsburg 2021-10-26 Contra Costa 13 9458   74321
1468 1468 Pleasant Hill Pleasant Hill 2021-10-26 Contra Costa 13 1808   34267
1469 1469 Richmond Richmond 2021-10-26 Contra Costa 13 14949   111217
1470 1470 Rodeo Rodeo 2021-10-26 Contra Costa 13 869   8679
1471 1471 San Pablo San Pablo 2021-10-26 Contra Costa 13 6529   31413
1472 1472 San Ramon San Ramon 2021-10-26 Contra Costa 13 3200   83118
1473 1473 Walnut Creek Walnut Creek 2021-10-26 Contra Costa 13 4274   70860
2809 2809 Alamo Alamo 2021-10-25 Contra Costa 13 739   14750
2810 2810 Antioch Antioch 2021-10-25 Contra Costa 13 14427   112520
2811 2811 Bay Point Bay Point 2021-10-25 Contra Costa 13 3768   22639
2812 2812 Bethel Island Bethel Island 2021-10-25 Contra Costa 13 158   2137
2813 2813 Brentwood Brentwood 2021-10-25 Contra Costa 13 6154   65118
2814 2814 Byron Byron 2021-10-25 Contra Costa 13 178   1325
2815 2815 Clayton Clayton 2021-10-25 Contra Costa 13 673   11337
2816 2816 Concord Concord 2021-10-25 Contra Costa 13 11115   130143
2817 2817 Crockett Crockett 2021-10-25 Contra Costa 13 222   3044
2818 2818 Danville Danville 2021-10-25 Contra Costa 13 2488   43876
2819 2819 Diablo Diablo 2021-10-25 Contra Costa 13 50   818
2820 2820 Discovery Bay Discovery Bay 2021-10-25 Contra Costa 13 1437   13352
2821 2821 El Cerrito El Cerrito 2021-10-25 Contra Costa 13 1014   24953
2822 2822 Hercules Hercules 2021-10-25 Contra Costa 13 1856   25530
2823 2823 Kensington Kensington 2021-10-25 Contra Costa 13 96   5077
2824 2824 Knightsen Knightsen 2021-10-25 Contra Costa 13 35   1500
2825 2825 Lafayette Lafayette 2021-10-25 Contra Costa 13 981   25604
2826 2826 Martinez Martinez 2021-10-25 Contra Costa 13 3152   37106
2827 2827 Moraga Moraga 2021-10-25 Contra Costa 13 468   16946
2828 2828 Oakley Oakley 2021-10-25 Contra Costa 13 5213   42461
2829 2829 Orinda Orinda 2021-10-25 Contra Costa 13 588   19009
2830 2830 Pacheco Pacheco 2021-10-25 Contra Costa 13 328   3685
2831 2831 Pinole Pinole 2021-10-25 Contra Costa 13 1576   19505
2832 2832 Pittsburg Pittsburg 2021-10-25 Contra Costa 13 9450   74321
2833 2833 Pleasant Hill Pleasant Hill 2021-10-25 Contra Costa 13 1804   34267
2834 2834 Richmond Richmond 2021-10-25 Contra Costa 13 14939   111217
2835 2835 Rodeo Rodeo 2021-10-25 Contra Costa 13 869   8679
2836 2836 San Pablo San Pablo 2021-10-25 Contra Costa 13 6526   31413
2837 2837 San Ramon San Ramon 2021-10-25 Contra Costa 13 3196   83118
2838 2838 Walnut Creek Walnut Creek 2021-10-25 Contra Costa 13 4272   70860
4174 4174 Alamo Alamo 2021-10-24 Contra Costa 13 739   14750
4175 4175 Antioch Antioch 2021-10-24 Contra Costa 13 14418   112520
4176 4176 Bay Point Bay Point 2021-10-24 Contra Costa 13 3766   22639
4177 4177 Bethel Island Bethel Island 2021-10-24 Contra Costa 13 158   2137
4178 4178 Brentwood Brentwood 2021-10-24 Contra Costa 13 6148   65118
4179 4179 Byron Byron 2021-10-24 Contra Costa 13 178   1325
4180 4180 Clayton Clayton 2021-10-24 Contra Costa 13 671   11337
4181 4181 Concord Concord 2021-10-24 Contra Costa 13 11102   130143
4182 4182 Crockett Crockett 2021-10-24 Contra Costa 13 222   3044
4183 4183 Danville Danville 2021-10-24 Contra Costa 13 2488   43876

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);