ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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);