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

11,470 rows where county = "Contra Costa" sorted by date descending

✎ View and edit SQL

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

fips

  • 13 11,470

county

  • Contra Costa · 11,470 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
78 78 Alamo Alamo 2021-04-10 Contra Costa 13 466   14750
79 79 Antioch Antioch 2021-04-10 Contra Costa 13 9168   112520
80 80 Bay Point Bay Point 2021-04-10 Contra Costa 13 2680   22639
81 81 Bethel Island Bethel Island 2021-04-10 Contra Costa 13 66   2137
82 82 Brentwood Brentwood 2021-04-10 Contra Costa 13 3647   65118
83 83 Byron Byron 2021-04-10 Contra Costa 13 100   1325
84 84 Clayton Clayton 2021-04-10 Contra Costa 13 395   11337
85 85 Concord Concord 2021-04-10 Contra Costa 13 7760   130143
86 86 Crockett Crockett 2021-04-10 Contra Costa 13 123   3044
87 87 Danville Danville 2021-04-10 Contra Costa 13 1565   43876
88 88 Diablo Diablo 2021-04-10 Contra Costa 13 36   818
89 89 Discovery Bay Discovery Bay 2021-04-10 Contra Costa 13 815   13352
90 90 El Cerrito El Cerrito 2021-04-10 Contra Costa 13 684   24953
91 91 El Sobrante El Sobrante 2021-04-10 Contra Costa 13 1181   12669
92 92 Hercules Hercules 2021-04-10 Contra Costa 13 1214   25530
93 93 Kensington Kensington 2021-04-10 Contra Costa 13 45   5077
94 94 Knightsen Knightsen 2021-04-10 Contra Costa 13 23   1500
95 95 Lafayette Lafayette 2021-04-10 Contra Costa 13 600   25604
96 96 Martinez Martinez 2021-04-10 Contra Costa 13 1900   37106
97 97 Moraga Moraga 2021-04-10 Contra Costa 13 314   16946
98 98 Oakley Oakley 2021-04-10 Contra Costa 13 3020   42461
99 99 Orinda Orinda 2021-04-10 Contra Costa 13 405   19009
100 100 Pacheco Pacheco 2021-04-10 Contra Costa 13 227   3685
101 101 Pinole Pinole 2021-04-10 Contra Costa 13 1099   19505
102 102 Pittsburg Pittsburg 2021-04-10 Contra Costa 13 6587   74321
103 103 Pleasant Hill Pleasant Hill 2021-04-10 Contra Costa 13 1162   34267
104 104 Richmond Richmond 2021-04-10 Contra Costa 13 10007   111217
105 105 Rodeo Rodeo 2021-04-10 Contra Costa 13 565   8679
106 106 San Pablo San Pablo 2021-04-10 Contra Costa 13 5113   31413
107 107 San Ramon San Ramon 2021-04-10 Contra Costa 13 1996   83118
108 108 Walnut Creek Walnut Creek 2021-04-10 Contra Costa 13 2743   70860
1445 1445 Alamo Alamo 2021-04-09 Contra Costa 13 464   14750
1446 1446 Antioch Antioch 2021-04-09 Contra Costa 13 9149   112520
1447 1447 Bay Point Bay Point 2021-04-09 Contra Costa 13 2677   22639
1448 1448 Bethel Island Bethel Island 2021-04-09 Contra Costa 13 66   2137
1449 1449 Brentwood Brentwood 2021-04-09 Contra Costa 13 3638   65118
1450 1450 Byron Byron 2021-04-09 Contra Costa 13 99   1325
1451 1451 Clayton Clayton 2021-04-09 Contra Costa 13 393   11337
1452 1452 Concord Concord 2021-04-09 Contra Costa 13 7751   130143
1453 1453 Crockett Crockett 2021-04-09 Contra Costa 13 123   3044
1454 1454 Danville Danville 2021-04-09 Contra Costa 13 1561   43876
1455 1455 Diablo Diablo 2021-04-09 Contra Costa 13 36   818
1456 1456 Discovery Bay Discovery Bay 2021-04-09 Contra Costa 13 813   13352
1457 1457 El Cerrito El Cerrito 2021-04-09 Contra Costa 13 683   24953
1458 1458 El Sobrante El Sobrante 2021-04-09 Contra Costa 13 1173   12669
1459 1459 Hercules Hercules 2021-04-09 Contra Costa 13 1212   25530
1460 1460 Kensington Kensington 2021-04-09 Contra Costa 13 45   5077
1461 1461 Knightsen Knightsen 2021-04-09 Contra Costa 13 23   1500
1462 1462 Lafayette Lafayette 2021-04-09 Contra Costa 13 600   25604
1463 1463 Martinez Martinez 2021-04-09 Contra Costa 13 1896   37106
1464 1464 Moraga Moraga 2021-04-09 Contra Costa 13 313   16946
1465 1465 Oakley Oakley 2021-04-09 Contra Costa 13 3013   42461
1466 1466 Orinda Orinda 2021-04-09 Contra Costa 13 404   19009
1467 1467 Pacheco Pacheco 2021-04-09 Contra Costa 13 226   3685
1468 1468 Pinole Pinole 2021-04-09 Contra Costa 13 1097   19505
1469 1469 Pittsburg Pittsburg 2021-04-09 Contra Costa 13 6576   74321
1470 1470 Pleasant Hill Pleasant Hill 2021-04-09 Contra Costa 13 1157   34267
1471 1471 Richmond Richmond 2021-04-09 Contra Costa 13 9982   111217
1472 1472 Rodeo Rodeo 2021-04-09 Contra Costa 13 564   8679
1473 1473 San Pablo San Pablo 2021-04-09 Contra Costa 13 5106   31413
1474 1474 San Ramon San Ramon 2021-04-09 Contra Costa 13 1995   83118
1475 1475 Walnut Creek Walnut Creek 2021-04-09 Contra Costa 13 2733   70860
2812 2812 Alamo Alamo 2021-04-08 Contra Costa 13 464   14750
2813 2813 Antioch Antioch 2021-04-08 Contra Costa 13 9131   112520
2814 2814 Bay Point Bay Point 2021-04-08 Contra Costa 13 2671   22639
2815 2815 Bethel Island Bethel Island 2021-04-08 Contra Costa 13 66   2137
2816 2816 Brentwood Brentwood 2021-04-08 Contra Costa 13 3625   65118
2817 2817 Byron Byron 2021-04-08 Contra Costa 13 99   1325
2818 2818 Clayton Clayton 2021-04-08 Contra Costa 13 393   11337
2819 2819 Concord Concord 2021-04-08 Contra Costa 13 7725   130143
2820 2820 Crockett Crockett 2021-04-08 Contra Costa 13 123   3044
2821 2821 Danville Danville 2021-04-08 Contra Costa 13 1559   43876
2822 2822 Diablo Diablo 2021-04-08 Contra Costa 13 36   818
2823 2823 Discovery Bay Discovery Bay 2021-04-08 Contra Costa 13 812   13352
2824 2824 El Cerrito El Cerrito 2021-04-08 Contra Costa 13 681   24953
2825 2825 El Sobrante El Sobrante 2021-04-08 Contra Costa 13 1169   12669
2826 2826 Hercules Hercules 2021-04-08 Contra Costa 13 1211   25530
2827 2827 Kensington Kensington 2021-04-08 Contra Costa 13 45   5077
2828 2828 Knightsen Knightsen 2021-04-08 Contra Costa 13 23   1500
2829 2829 Lafayette Lafayette 2021-04-08 Contra Costa 13 598   25604
2830 2830 Martinez Martinez 2021-04-08 Contra Costa 13 1893   37106
2831 2831 Moraga Moraga 2021-04-08 Contra Costa 13 310   16946
2832 2832 Oakley Oakley 2021-04-08 Contra Costa 13 3002   42461
2833 2833 Orinda Orinda 2021-04-08 Contra Costa 13 403   19009
2834 2834 Pacheco Pacheco 2021-04-08 Contra Costa 13 226   3685
2835 2835 Pinole Pinole 2021-04-08 Contra Costa 13 1093   19505
2836 2836 Pittsburg Pittsburg 2021-04-08 Contra Costa 13 6565   74321
2837 2837 Pleasant Hill Pleasant Hill 2021-04-08 Contra Costa 13 1154   34267
2838 2838 Richmond Richmond 2021-04-08 Contra Costa 13 9962   111217
2839 2839 Rodeo Rodeo 2021-04-08 Contra Costa 13 560   8679
2840 2840 San Pablo San Pablo 2021-04-08 Contra Costa 13 5097   31413
2841 2841 San Ramon San Ramon 2021-04-08 Contra Costa 13 1991   83118
2842 2842 Walnut Creek Walnut Creek 2021-04-08 Contra Costa 13 2731   70860
4182 4182 Alamo Alamo 2021-04-07 Contra Costa 13 464   14750
4183 4183 Antioch Antioch 2021-04-07 Contra Costa 13 9121   112520
4184 4184 Bay Point Bay Point 2021-04-07 Contra Costa 13 2665   22639
4185 4185 Bethel Island Bethel Island 2021-04-07 Contra Costa 13 66   2137
4186 4186 Brentwood Brentwood 2021-04-07 Contra Costa 13 3618   65118
4187 4187 Byron Byron 2021-04-07 Contra Costa 13 99   1325
4188 4188 Clayton Clayton 2021-04-07 Contra Costa 13 393   11337

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
);