home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ 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

28,864 rows where fips = 97 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 97 · 28,864 ✖

county 1

  • Sonoma 28,864
Link rowid id name date ▲ county fips confirmed_cases note population
1125 1125 94515 94515: Calistoga 2022-08-19 Sonoma 97 72   7436
1126 1126 94922 94922: Bodega 2022-08-19 Sonoma 97 67   603
1127 1127 94923 94923: Bodega Bay 2022-08-19 Sonoma 97 131   846
1128 1128 94928 94928: Rohnert Park 2022-08-19 Sonoma 97 10861   44103
1129 1129 94931 94931: Cotati 2022-08-19 Sonoma 97 1786   8601
1130 1130 94951 94951: Penngrove 2022-08-19 Sonoma 97 715   4571
1131 1131 94952 94952: Petaluma 2022-08-19 Sonoma 97 5435   36184
1132 1132 94954 94954: Petaluma 2022-08-19 Sonoma 97 7493   38414
1133 1133 95401 95401: Santa Rosa 2022-08-19 Sonoma 97 9206   38986
1134 1134 95403 95403: Santa Rosa 2022-08-19 Sonoma 97 11327   45355
1135 1135 95404 95404: Santa Rosa 2022-08-19 Sonoma 97 7860   40474
1136 1136 95405 95405: Santa Rosa 2022-08-19 Sonoma 97 4116   21448
1137 1137 95407 95407: Santa Rosa 2022-08-19 Sonoma 97 12966   42483
1138 1138 95409 95409: Santa Rosa 2022-08-19 Sonoma 97 4148   27312
1139 1139 95412 95412: Annapolis 2022-08-19 Sonoma 97 19   402
1140 1140 95421 95421: Cazadero 2022-08-19 Sonoma 97 126   1681
1141 1141 95425 95425: Cloverdale 2022-08-19 Sonoma 97 2158   10586
1142 1142 95436 95436: Forestville 2022-08-19 Sonoma 97 757   6352
1143 1143 95439 95439: Fulton 2022-08-19 Sonoma 97 160   774
1144 1144 95441 95441: Geyserville 2022-08-19 Sonoma 97 355   2053
1145 1145 95442 95442: Glen Ellen 2022-08-19 Sonoma 97 512   3136
1146 1146 95444 95444: Graton 2022-08-19 Sonoma 97 151   715
1147 1147 95446 95446: Guerneville 2022-08-19 Sonoma 97 657   5100
1148 1148 95448 95448: Healdsburg 2022-08-19 Sonoma 97 3152   17482
1149 1149 95450 95450: Jenner 2022-08-19 Sonoma 97 28   298
1150 1150 95452 95452: Kenwood 2022-08-19 Sonoma 97 133   970
1151 1151 95462 95462: Monte Rio 2022-08-19 Sonoma 97 147   1265
1152 1152 95465 95465: Occidental 2022-08-19 Sonoma 97 189   2104
1153 1153 95472 95472: Sebastopol 2022-08-19 Sonoma 97 3741   30762
1154 1154 95476 95476: Sonoma 2022-08-19 Sonoma 97 7280   36792
1155 1155 95492 95492: Windsor 2022-08-19 Sonoma 97 6384   29920
1156 1156 95497 95497: The Sea Ranch 2022-08-19 Sonoma 97 37   1161
2363 2363 94515 94515: Calistoga 2022-08-18 Sonoma 97 72   7436
2364 2364 94922 94922: Bodega 2022-08-18 Sonoma 97 67   603
2365 2365 94923 94923: Bodega Bay 2022-08-18 Sonoma 97 131   846
2366 2366 94928 94928: Rohnert Park 2022-08-18 Sonoma 97 10861   44103
2367 2367 94931 94931: Cotati 2022-08-18 Sonoma 97 1786   8601
2368 2368 94951 94951: Penngrove 2022-08-18 Sonoma 97 715   4571
2369 2369 94952 94952: Petaluma 2022-08-18 Sonoma 97 5435   36184
2370 2370 94954 94954: Petaluma 2022-08-18 Sonoma 97 7493   38414
2371 2371 95401 95401: Santa Rosa 2022-08-18 Sonoma 97 9206   38986
2372 2372 95403 95403: Santa Rosa 2022-08-18 Sonoma 97 11327   45355
2373 2373 95404 95404: Santa Rosa 2022-08-18 Sonoma 97 7860   40474
2374 2374 95405 95405: Santa Rosa 2022-08-18 Sonoma 97 4116   21448
2375 2375 95407 95407: Santa Rosa 2022-08-18 Sonoma 97 12966   42483
2376 2376 95409 95409: Santa Rosa 2022-08-18 Sonoma 97 4148   27312
2377 2377 95412 95412: Annapolis 2022-08-18 Sonoma 97 19   402
2378 2378 95421 95421: Cazadero 2022-08-18 Sonoma 97 126   1681
2379 2379 95425 95425: Cloverdale 2022-08-18 Sonoma 97 2158   10586
2380 2380 95436 95436: Forestville 2022-08-18 Sonoma 97 757   6352
2381 2381 95439 95439: Fulton 2022-08-18 Sonoma 97 160   774
2382 2382 95441 95441: Geyserville 2022-08-18 Sonoma 97 355   2053
2383 2383 95442 95442: Glen Ellen 2022-08-18 Sonoma 97 512   3136
2384 2384 95444 95444: Graton 2022-08-18 Sonoma 97 151   715
2385 2385 95446 95446: Guerneville 2022-08-18 Sonoma 97 657   5100
2386 2386 95448 95448: Healdsburg 2022-08-18 Sonoma 97 3152   17482
2387 2387 95450 95450: Jenner 2022-08-18 Sonoma 97 28   298
2388 2388 95452 95452: Kenwood 2022-08-18 Sonoma 97 133   970
2389 2389 95462 95462: Monte Rio 2022-08-18 Sonoma 97 147   1265
2390 2390 95465 95465: Occidental 2022-08-18 Sonoma 97 189   2104
2391 2391 95472 95472: Sebastopol 2022-08-18 Sonoma 97 3741   30762
2392 2392 95476 95476: Sonoma 2022-08-18 Sonoma 97 7280   36792
2393 2393 95492 95492: Windsor 2022-08-18 Sonoma 97 6384   29920
2394 2394 95497 95497: The Sea Ranch 2022-08-18 Sonoma 97 37   1161
3601 3601 94515 94515: Calistoga 2022-08-17 Sonoma 97 72   7436
3602 3602 94922 94922: Bodega 2022-08-17 Sonoma 97 67   603
3603 3603 94923 94923: Bodega Bay 2022-08-17 Sonoma 97 131   846
3604 3604 94928 94928: Rohnert Park 2022-08-17 Sonoma 97 10849   44103
3605 3605 94931 94931: Cotati 2022-08-17 Sonoma 97 1785   8601
3606 3606 94951 94951: Penngrove 2022-08-17 Sonoma 97 713   4571
3607 3607 94952 94952: Petaluma 2022-08-17 Sonoma 97 5428   36184
3608 3608 94954 94954: Petaluma 2022-08-17 Sonoma 97 7488   38414
3609 3609 95401 95401: Santa Rosa 2022-08-17 Sonoma 97 9190   38986
3610 3610 95403 95403: Santa Rosa 2022-08-17 Sonoma 97 11306   45355
3611 3611 95404 95404: Santa Rosa 2022-08-17 Sonoma 97 7851   40474
3612 3612 95405 95405: Santa Rosa 2022-08-17 Sonoma 97 4111   21448
3613 3613 95407 95407: Santa Rosa 2022-08-17 Sonoma 97 12952   42483
3614 3614 95409 95409: Santa Rosa 2022-08-17 Sonoma 97 4143   27312
3615 3615 95412 95412: Annapolis 2022-08-17 Sonoma 97 19   402
3616 3616 95421 95421: Cazadero 2022-08-17 Sonoma 97 126   1681
3617 3617 95425 95425: Cloverdale 2022-08-17 Sonoma 97 2156   10586
3618 3618 95436 95436: Forestville 2022-08-17 Sonoma 97 757   6352
3619 3619 95439 95439: Fulton 2022-08-17 Sonoma 97 160   774
3620 3620 95441 95441: Geyserville 2022-08-17 Sonoma 97 355   2053
3621 3621 95442 95442: Glen Ellen 2022-08-17 Sonoma 97 512   3136
3622 3622 95444 95444: Graton 2022-08-17 Sonoma 97 151   715
3623 3623 95446 95446: Guerneville 2022-08-17 Sonoma 97 657   5100
3624 3624 95448 95448: Healdsburg 2022-08-17 Sonoma 97 3148   17482
3625 3625 95450 95450: Jenner 2022-08-17 Sonoma 97 28   298
3626 3626 95452 95452: Kenwood 2022-08-17 Sonoma 97 132   970
3627 3627 95462 95462: Monte Rio 2022-08-17 Sonoma 97 147   1265
3628 3628 95465 95465: Occidental 2022-08-17 Sonoma 97 189   2104
3629 3629 95472 95472: Sebastopol 2022-08-17 Sonoma 97 3737   30762
3630 3630 95476 95476: Sonoma 2022-08-17 Sonoma 97 7276   36792
3631 3631 95492 95492: Windsor 2022-08-17 Sonoma 97 6377   29920
3632 3632 95497 95497: The Sea Ranch 2022-08-17 Sonoma 97 37   1161
4839 4839 94515 94515: Calistoga 2022-08-16 Sonoma 97 70   7436
4840 4840 94922 94922: Bodega 2022-08-16 Sonoma 97 67   603
4841 4841 94923 94923: Bodega Bay 2022-08-16 Sonoma 97 130   846
4842 4842 94928 94928: Rohnert Park 2022-08-16 Sonoma 97 10838   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
);
Powered by Datasette · Queries took 1299.893ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals