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

12,992 rows where fips = 97 sorted by date descending

✎ View and edit SQL

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

fips

  • 97 · 12,992 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
1256 1256 94515 94515: Calistoga 2021-04-10 Sonoma 97 11   7436
1257 1257 94922 94922: Bodega 2021-04-10 Sonoma 97 15   603
1258 1258 94923 94923: Bodega Bay 2021-04-10 Sonoma 97 51   846
1259 1259 94928 94928: Rohnert Park 2021-04-10 Sonoma 97 2586   44103
1260 1260 94931 94931: Cotati 2021-04-10 Sonoma 97 380   8601
1261 1261 94951 94951: Penngrove 2021-04-10 Sonoma 97 173   4571
1262 1262 94952 94952: Petaluma 2021-04-10 Sonoma 97 1463   36184
1263 1263 94954 94954: Petaluma 2021-04-10 Sonoma 97 2051   38414
1264 1264 95401 95401: Santa Rosa 2021-04-10 Sonoma 97 2843   38986
1265 1265 95403 95403: Santa Rosa 2021-04-10 Sonoma 97 3033   45355
1266 1266 95404 95404: Santa Rosa 2021-04-10 Sonoma 97 2156   40474
1267 1267 95405 95405: Santa Rosa 2021-04-10 Sonoma 97 1015   21448
1268 1268 95407 95407: Santa Rosa 2021-04-10 Sonoma 97 4780   42483
1269 1269 95409 95409: Santa Rosa 2021-04-10 Sonoma 97 956   27312
1270 1270 95412 95412: Annapolis 2021-04-10 Sonoma 97 10 10 or fewer 402
1271 1271 95421 95421: Cazadero 2021-04-10 Sonoma 97 34   1681
1272 1272 95425 95425: Cloverdale 2021-04-10 Sonoma 97 736   10586
1273 1273 95436 95436: Forestville 2021-04-10 Sonoma 97 166   6352
1274 1274 95439 95439: Fulton 2021-04-10 Sonoma 97 47   774
1275 1275 95441 95441: Geyserville 2021-04-10 Sonoma 97 93   2053
1276 1276 95442 95442: Glen Ellen 2021-04-10 Sonoma 97 137   3136
1277 1277 95444 95444: Graton 2021-04-10 Sonoma 97 28   715
1278 1278 95446 95446: Guerneville 2021-04-10 Sonoma 97 137   5100
1279 1279 95448 95448: Healdsburg 2021-04-10 Sonoma 97 926   17482
1280 1280 95450 95450: Jenner 2021-04-10 Sonoma 97 10 10 or fewer 298
1281 1281 95452 95452: Kenwood 2021-04-10 Sonoma 97 19   970
1282 1282 95462 95462: Monte Rio 2021-04-10 Sonoma 97 21   1265
1283 1283 95465 95465: Occidental 2021-04-10 Sonoma 97 22   2104
1284 1284 95472 95472: Sebastopol 2021-04-10 Sonoma 97 643   30762
1285 1285 95476 95476: Sonoma 2021-04-10 Sonoma 97 2290   36792
1286 1286 95492 95492: Windsor 2021-04-10 Sonoma 97 1639   29920
1287 1287 95497 95497: The Sea Ranch 2021-04-10 Sonoma 97 10 10 or fewer 1161
2623 2623 94515 94515: Calistoga 2021-04-09 Sonoma 97 11   7436
2624 2624 94922 94922: Bodega 2021-04-09 Sonoma 97 15   603
2625 2625 94923 94923: Bodega Bay 2021-04-09 Sonoma 97 51   846
2626 2626 94928 94928: Rohnert Park 2021-04-09 Sonoma 97 2586   44103
2627 2627 94931 94931: Cotati 2021-04-09 Sonoma 97 380   8601
2628 2628 94951 94951: Penngrove 2021-04-09 Sonoma 97 173   4571
2629 2629 94952 94952: Petaluma 2021-04-09 Sonoma 97 1463   36184
2630 2630 94954 94954: Petaluma 2021-04-09 Sonoma 97 2051   38414
2631 2631 95401 95401: Santa Rosa 2021-04-09 Sonoma 97 2843   38986
2632 2632 95403 95403: Santa Rosa 2021-04-09 Sonoma 97 3033   45355
2633 2633 95404 95404: Santa Rosa 2021-04-09 Sonoma 97 2156   40474
2634 2634 95405 95405: Santa Rosa 2021-04-09 Sonoma 97 1015   21448
2635 2635 95407 95407: Santa Rosa 2021-04-09 Sonoma 97 4780   42483
2636 2636 95409 95409: Santa Rosa 2021-04-09 Sonoma 97 956   27312
2637 2637 95412 95412: Annapolis 2021-04-09 Sonoma 97 10 10 or fewer 402
2638 2638 95421 95421: Cazadero 2021-04-09 Sonoma 97 34   1681
2639 2639 95425 95425: Cloverdale 2021-04-09 Sonoma 97 736   10586
2640 2640 95436 95436: Forestville 2021-04-09 Sonoma 97 166   6352
2641 2641 95439 95439: Fulton 2021-04-09 Sonoma 97 47   774
2642 2642 95441 95441: Geyserville 2021-04-09 Sonoma 97 93   2053
2643 2643 95442 95442: Glen Ellen 2021-04-09 Sonoma 97 137   3136
2644 2644 95444 95444: Graton 2021-04-09 Sonoma 97 28   715
2645 2645 95446 95446: Guerneville 2021-04-09 Sonoma 97 137   5100
2646 2646 95448 95448: Healdsburg 2021-04-09 Sonoma 97 926   17482
2647 2647 95450 95450: Jenner 2021-04-09 Sonoma 97 10 10 or fewer 298
2648 2648 95452 95452: Kenwood 2021-04-09 Sonoma 97 19   970
2649 2649 95462 95462: Monte Rio 2021-04-09 Sonoma 97 21   1265
2650 2650 95465 95465: Occidental 2021-04-09 Sonoma 97 22   2104
2651 2651 95472 95472: Sebastopol 2021-04-09 Sonoma 97 643   30762
2652 2652 95476 95476: Sonoma 2021-04-09 Sonoma 97 2290   36792
2653 2653 95492 95492: Windsor 2021-04-09 Sonoma 97 1639   29920
2654 2654 95497 95497: The Sea Ranch 2021-04-09 Sonoma 97 10 10 or fewer 1161
3993 3993 94515 94515: Calistoga 2021-04-08 Sonoma 97 11   7436
3994 3994 94922 94922: Bodega 2021-04-08 Sonoma 97 15   603
3995 3995 94923 94923: Bodega Bay 2021-04-08 Sonoma 97 51   846
3996 3996 94928 94928: Rohnert Park 2021-04-08 Sonoma 97 2586   44103
3997 3997 94931 94931: Cotati 2021-04-08 Sonoma 97 380   8601
3998 3998 94951 94951: Penngrove 2021-04-08 Sonoma 97 173   4571
3999 3999 94952 94952: Petaluma 2021-04-08 Sonoma 97 1463   36184
4000 4000 94954 94954: Petaluma 2021-04-08 Sonoma 97 2051   38414
4001 4001 95401 95401: Santa Rosa 2021-04-08 Sonoma 97 2843   38986
4002 4002 95403 95403: Santa Rosa 2021-04-08 Sonoma 97 3033   45355
4003 4003 95404 95404: Santa Rosa 2021-04-08 Sonoma 97 2156   40474
4004 4004 95405 95405: Santa Rosa 2021-04-08 Sonoma 97 1015   21448
4005 4005 95407 95407: Santa Rosa 2021-04-08 Sonoma 97 4780   42483
4006 4006 95409 95409: Santa Rosa 2021-04-08 Sonoma 97 956   27312
4007 4007 95412 95412: Annapolis 2021-04-08 Sonoma 97 10 10 or fewer 402
4008 4008 95421 95421: Cazadero 2021-04-08 Sonoma 97 34   1681
4009 4009 95425 95425: Cloverdale 2021-04-08 Sonoma 97 736   10586
4010 4010 95436 95436: Forestville 2021-04-08 Sonoma 97 166   6352
4011 4011 95439 95439: Fulton 2021-04-08 Sonoma 97 47   774
4012 4012 95441 95441: Geyserville 2021-04-08 Sonoma 97 93   2053
4013 4013 95442 95442: Glen Ellen 2021-04-08 Sonoma 97 137   3136
4014 4014 95444 95444: Graton 2021-04-08 Sonoma 97 28   715
4015 4015 95446 95446: Guerneville 2021-04-08 Sonoma 97 137   5100
4016 4016 95448 95448: Healdsburg 2021-04-08 Sonoma 97 926   17482
4017 4017 95450 95450: Jenner 2021-04-08 Sonoma 97 10 10 or fewer 298
4018 4018 95452 95452: Kenwood 2021-04-08 Sonoma 97 19   970
4019 4019 95462 95462: Monte Rio 2021-04-08 Sonoma 97 21   1265
4020 4020 95465 95465: Occidental 2021-04-08 Sonoma 97 22   2104
4021 4021 95472 95472: Sebastopol 2021-04-08 Sonoma 97 643   30762
4022 4022 95476 95476: Sonoma 2021-04-08 Sonoma 97 2290   36792
4023 4023 95492 95492: Windsor 2021-04-08 Sonoma 97 1639   29920
4024 4024 95497 95497: The Sea Ranch 2021-04-08 Sonoma 97 10 10 or fewer 1161
5365 5365 94515 94515: Calistoga 2021-04-07 Sonoma 97 11   7436
5366 5366 94922 94922: Bodega 2021-04-07 Sonoma 97 15   603
5367 5367 94923 94923: Bodega Bay 2021-04-07 Sonoma 97 51   846
5368 5368 94928 94928: Rohnert Park 2021-04-07 Sonoma 97 2586   44103

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