ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where county = "Sonoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 177 ✖
- 4 47
- 318 29
- 0 23
- 1 21
- 2 21
- 323 20
- 311 17
- 490 17
- 321 16
- 412 15
- 310 14
- 416 14
- 488 14
- 418 13
- 487 12
- 122 11
- 317 10
- 5 9
- 136 8
- 160 8
- 402 8
- 410 8
- 414 8
- 489 8
- 308 7
- 404 7
- 114 6
- 149 6
- 157 6
- 291 6
- 298 6
- 322 6
- 344 6
- 365 6
- 386 6
- 408 6
- 445 6
- 16 5
- 93 5
- 128 5
- 134 5
- 146 5
- 155 5
- 162 5
- 306 5
- 327 5
- 329 5
- 368 5
- 384 5
- 396 5
- 406 5
- 432 5
- 469 5
- 477 5
- 14 4
- 24 4
- 51 4
- 78 4
- 120 4
- 126 4
- 129 4
- 150 4
- 218 4
- 234 4
- 260 4
- 287 4
- 330 4
- 334 4
- 337 4
- 338 4
- 353 4
- 376 4
- 426 4
- 461 4
- 476 4
- 478 4
- 481 4
- 484 4
- 3 3
- 11 3
- 19 3
- 22 3
- 39 3
- 47 3
- 57 3
- 108 3
- 142 3
- 174 3
- 182 3
- 196 3
- 295 3
- 301 3
- 303 3
- 328 3
- 331 3
- 419 3
- 421 3
- 429 3
- 448 3
- 474 3
- 7 2
- 20 2
- 31 2
- 70 2
- 72 2
- 75 2
- 98 2
- 110 2
- 166 2
- 171 2
- 180 2
- 184 2
- 192 2
- 240 2
- 245 2
- 247 2
- 251 2
- 267 2
- 275 2
- 277 2
- 283 2
- 319 2
- 349 2
- 356 2
- 372 2
- 378 2
- 381 2
- 398 2
- 440 2
- 455 2
- 459 2
- 472 2
- 475 2
- 9 1
- 10 1
- 12 1
- 32 1
- 36 1
- 37 1
- 42 1
- 44 1
- 50 1
- 54 1
- 65 1
- 73 1
- 80 1
- 83 1
- 89 1
- 105 1
- 164 1
- 177 1
- 181 1
- 204 1
- 213 1
- 214 1
- 219 1
- 227 1
- 242 1
- 254 1
- 265 1
- 270 1
- 280 1
- 309 1
- 316 1
- 320 1
- 326 1
- 340 1
- 347 1
- 361 1
- 390 1
- 400 1
- 422 1
- 423 1
- 437 1
- 452 1
- 464 1
- 483 1
state 1
- California 808
fips 1
- 6097 808
county 1
- Sonoma · 808 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499810 | 2499810 | 2022-05-13 | Sonoma | California | 6097 | 90191 | 490 |
2496552 | 2496552 | 2022-05-12 | Sonoma | California | 6097 | 89730 | 490 |
2493294 | 2493294 | 2022-05-11 | Sonoma | California | 6097 | 89730 | 490 |
2490036 | 2490036 | 2022-05-10 | Sonoma | California | 6097 | 89730 | 490 |
2486779 | 2486779 | 2022-05-09 | Sonoma | California | 6097 | 89082 | 490 |
2483521 | 2483521 | 2022-05-08 | Sonoma | California | 6097 | 89082 | 490 |
2480263 | 2480263 | 2022-05-07 | Sonoma | California | 6097 | 89082 | 490 |
2477005 | 2477005 | 2022-05-06 | Sonoma | California | 6097 | 89082 | 490 |
2473747 | 2473747 | 2022-05-05 | Sonoma | California | 6097 | 88499 | 490 |
2470490 | 2470490 | 2022-05-04 | Sonoma | California | 6097 | 88499 | 490 |
2467234 | 2467234 | 2022-05-03 | Sonoma | California | 6097 | 88499 | 490 |
2463979 | 2463979 | 2022-05-02 | Sonoma | California | 6097 | 88095 | 490 |
2460723 | 2460723 | 2022-05-01 | Sonoma | California | 6097 | 88095 | 490 |
2457467 | 2457467 | 2022-04-30 | Sonoma | California | 6097 | 88095 | 490 |
2454211 | 2454211 | 2022-04-29 | Sonoma | California | 6097 | 88095 | 490 |
2450955 | 2450955 | 2022-04-28 | Sonoma | California | 6097 | 87684 | 490 |
2447699 | 2447699 | 2022-04-27 | Sonoma | California | 6097 | 87684 | 490 |
2444443 | 2444443 | 2022-04-26 | Sonoma | California | 6097 | 87684 | 489 |
2441187 | 2441187 | 2022-04-25 | Sonoma | California | 6097 | 87282 | 489 |
2437931 | 2437931 | 2022-04-24 | Sonoma | California | 6097 | 87282 | 489 |
2434675 | 2434675 | 2022-04-23 | Sonoma | California | 6097 | 87282 | 489 |
2431419 | 2431419 | 2022-04-22 | Sonoma | California | 6097 | 87282 | 489 |
2428163 | 2428163 | 2022-04-21 | Sonoma | California | 6097 | 86988 | 489 |
2424907 | 2424907 | 2022-04-20 | Sonoma | California | 6097 | 86988 | 489 |
2421651 | 2421651 | 2022-04-19 | Sonoma | California | 6097 | 86988 | 489 |
2418395 | 2418395 | 2022-04-18 | Sonoma | California | 6097 | 86731 | 488 |
2415139 | 2415139 | 2022-04-17 | Sonoma | California | 6097 | 86731 | 488 |
2411883 | 2411883 | 2022-04-16 | Sonoma | California | 6097 | 86731 | 488 |
2408627 | 2408627 | 2022-04-15 | Sonoma | California | 6097 | 86731 | 488 |
2405371 | 2405371 | 2022-04-14 | Sonoma | California | 6097 | 86592 | 488 |
2402116 | 2402116 | 2022-04-13 | Sonoma | California | 6097 | 86121 | 488 |
2398861 | 2398861 | 2022-04-12 | Sonoma | California | 6097 | 86121 | 488 |
2395606 | 2395606 | 2022-04-11 | Sonoma | California | 6097 | 86121 | 488 |
2392350 | 2392350 | 2022-04-10 | Sonoma | California | 6097 | 86121 | 488 |
2389094 | 2389094 | 2022-04-09 | Sonoma | California | 6097 | 86121 | 488 |
2385839 | 2385839 | 2022-04-08 | Sonoma | California | 6097 | 86121 | 488 |
2382584 | 2382584 | 2022-04-07 | Sonoma | California | 6097 | 85882 | 488 |
2379329 | 2379329 | 2022-04-06 | Sonoma | California | 6097 | 85882 | 488 |
2376075 | 2376075 | 2022-04-05 | Sonoma | California | 6097 | 85882 | 488 |
2372823 | 2372823 | 2022-04-04 | Sonoma | California | 6097 | 85756 | 487 |
2369570 | 2369570 | 2022-04-03 | Sonoma | California | 6097 | 85756 | 487 |
2366317 | 2366317 | 2022-04-02 | Sonoma | California | 6097 | 85756 | 487 |
2363064 | 2363064 | 2022-04-01 | Sonoma | California | 6097 | 85756 | 487 |
2359810 | 2359810 | 2022-03-31 | Sonoma | California | 6097 | 85684 | 487 |
2356556 | 2356556 | 2022-03-30 | Sonoma | California | 6097 | 85578 | 487 |
2353303 | 2353303 | 2022-03-29 | Sonoma | California | 6097 | 85553 | 487 |
2350051 | 2350051 | 2022-03-28 | Sonoma | California | 6097 | 85536 | 487 |
2346798 | 2346798 | 2022-03-27 | Sonoma | California | 6097 | 85561 | 487 |
2343545 | 2343545 | 2022-03-26 | Sonoma | California | 6097 | 85561 | 487 |
2340292 | 2340292 | 2022-03-25 | Sonoma | California | 6097 | 85561 | 487 |
2337039 | 2337039 | 2022-03-24 | Sonoma | California | 6097 | 85522 | 487 |
2333785 | 2333785 | 2022-03-23 | Sonoma | California | 6097 | 85454 | 484 |
2330531 | 2330531 | 2022-03-22 | Sonoma | California | 6097 | 85391 | 484 |
2327279 | 2327279 | 2022-03-21 | Sonoma | California | 6097 | 85377 | 484 |
2324026 | 2324026 | 2022-03-20 | Sonoma | California | 6097 | 85250 | 484 |
2320772 | 2320772 | 2022-03-19 | Sonoma | California | 6097 | 85250 | 483 |
2317518 | 2317518 | 2022-03-18 | Sonoma | California | 6097 | 85250 | 481 |
2314265 | 2314265 | 2022-03-17 | Sonoma | California | 6097 | 85203 | 481 |
2311012 | 2311012 | 2022-03-16 | Sonoma | California | 6097 | 85077 | 481 |
2307759 | 2307759 | 2022-03-15 | Sonoma | California | 6097 | 85071 | 481 |
2304508 | 2304508 | 2022-03-14 | Sonoma | California | 6097 | 85051 | 478 |
2301256 | 2301256 | 2022-03-13 | Sonoma | California | 6097 | 84962 | 478 |
2298004 | 2298004 | 2022-03-12 | Sonoma | California | 6097 | 84962 | 478 |
2294752 | 2294752 | 2022-03-11 | Sonoma | California | 6097 | 84962 | 478 |
2291500 | 2291500 | 2022-03-10 | Sonoma | California | 6097 | 84914 | 477 |
2288248 | 2288248 | 2022-03-09 | Sonoma | California | 6097 | 84638 | 477 |
2284997 | 2284997 | 2022-03-08 | Sonoma | California | 6097 | 84597 | 477 |
2281745 | 2281745 | 2022-03-07 | Sonoma | California | 6097 | 84525 | 476 |
2278492 | 2278492 | 2022-03-06 | Sonoma | California | 6097 | 84380 | 476 |
2275239 | 2275239 | 2022-03-05 | Sonoma | California | 6097 | 84380 | 476 |
2271986 | 2271986 | 2022-03-04 | Sonoma | California | 6097 | 84380 | 475 |
2268734 | 2268734 | 2022-03-03 | Sonoma | California | 6097 | 84275 | 475 |
2265481 | 2265481 | 2022-03-02 | Sonoma | California | 6097 | 84026 | 477 |
2262230 | 2262230 | 2022-03-01 | Sonoma | California | 6097 | 83981 | 477 |
2258979 | 2258979 | 2022-02-28 | Sonoma | California | 6097 | 83964 | 476 |
2255728 | 2255728 | 2022-02-27 | Sonoma | California | 6097 | 83625 | 474 |
2252477 | 2252477 | 2022-02-26 | Sonoma | California | 6097 | 83625 | 474 |
2249226 | 2249226 | 2022-02-25 | Sonoma | California | 6097 | 83625 | 474 |
2245975 | 2245975 | 2022-02-24 | Sonoma | California | 6097 | 83517 | 472 |
2242724 | 2242724 | 2022-02-23 | Sonoma | California | 6097 | 83311 | 472 |
2239473 | 2239473 | 2022-02-22 | Sonoma | California | 6097 | 83260 | 469 |
2236222 | 2236222 | 2022-02-21 | Sonoma | California | 6097 | 82742 | 469 |
2232971 | 2232971 | 2022-02-20 | Sonoma | California | 6097 | 82742 | 469 |
2229720 | 2229720 | 2022-02-19 | Sonoma | California | 6097 | 82742 | 469 |
2226469 | 2226469 | 2022-02-18 | Sonoma | California | 6097 | 82742 | 469 |
2223218 | 2223218 | 2022-02-17 | Sonoma | California | 6097 | 82541 | 464 |
2219967 | 2219967 | 2022-02-16 | Sonoma | California | 6097 | 82584 | 461 |
2216716 | 2216716 | 2022-02-15 | Sonoma | California | 6097 | 82487 | 461 |
2213465 | 2213465 | 2022-02-14 | Sonoma | California | 6097 | 82323 | 461 |
2210213 | 2210213 | 2022-02-13 | Sonoma | California | 6097 | 81684 | 461 |
2206960 | 2206960 | 2022-02-12 | Sonoma | California | 6097 | 81684 | 459 |
2203707 | 2203707 | 2022-02-11 | Sonoma | California | 6097 | 81684 | 459 |
2200454 | 2200454 | 2022-02-10 | Sonoma | California | 6097 | 81316 | 455 |
2197200 | 2197200 | 2022-02-09 | Sonoma | California | 6097 | 80943 | 455 |
2193945 | 2193945 | 2022-02-08 | Sonoma | California | 6097 | 80441 | 452 |
2190692 | 2190692 | 2022-02-07 | Sonoma | California | 6097 | 80032 | 448 |
2187439 | 2187439 | 2022-02-06 | Sonoma | California | 6097 | 79358 | 448 |
2184186 | 2184186 | 2022-02-05 | Sonoma | California | 6097 | 79358 | 448 |
2180934 | 2180934 | 2022-02-04 | Sonoma | California | 6097 | 79358 | 445 |
2177683 | 2177683 | 2022-02-03 | Sonoma | California | 6097 | 78826 | 445 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);