⚠️ 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 fips = 13 sorted by date descending

View and edit SQL

fips

  • 13 · 11,470

county

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