ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,653 rows where deaths = 183 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 192
- Pennsylvania 134
- Georgia 96
- Indiana 76
- Tennessee 76
- Ohio 66
- Wisconsin 65
- Virginia 60
- New York 59
- South Carolina 57
- Louisiana 56
- North Carolina 54
- Missouri 52
- Michigan 50
- Kansas 48
- Alabama 46
- Florida 46
- Oklahoma 38
- Illinois 36
- Kentucky 36
- Mississippi 32
- West Virginia 32
- New Mexico 25
- Arkansas 21
- Iowa 17
- California 16
- Maine 15
- New Jersey 14
- Washington 14
- Arizona 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499944 | 2499944 | 2022-05-13 | Okeechobee | Florida | 12093 | 10649 | 183 |
2500524 | 2500524 | 2022-05-13 | Leavenworth | Kansas | 20103 | 19619 | 183 |
2501567 | 2501567 | 2022-05-13 | Sampson | North Carolina | 37163 | 18913 | 183 |
2502280 | 2502280 | 2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 |
2496686 | 2496686 | 2022-05-12 | Okeechobee | Florida | 12093 | 10649 | 183 |
2497266 | 2497266 | 2022-05-12 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2498309 | 2498309 | 2022-05-12 | Sampson | North Carolina | 37163 | 18913 | 183 |
2499022 | 2499022 | 2022-05-12 | Fannin | Texas | 48147 | 6897 | 183 |
2493428 | 2493428 | 2022-05-11 | Okeechobee | Florida | 12093 | 10649 | 183 |
2494008 | 2494008 | 2022-05-11 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2494443 | 2494443 | 2022-05-11 | Olmsted | Minnesota | 27109 | 43279 | 183 |
2495051 | 2495051 | 2022-05-11 | Sampson | North Carolina | 37163 | 18913 | 183 |
2495764 | 2495764 | 2022-05-11 | Fannin | Texas | 48147 | 6895 | 183 |
2490170 | 2490170 | 2022-05-10 | Okeechobee | Florida | 12093 | 10649 | 183 |
2490750 | 2490750 | 2022-05-10 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2491185 | 2491185 | 2022-05-10 | Olmsted | Minnesota | 27109 | 43221 | 183 |
2491793 | 2491793 | 2022-05-10 | Sampson | North Carolina | 37163 | 18869 | 183 |
2492506 | 2492506 | 2022-05-10 | Fannin | Texas | 48147 | 6895 | 183 |
2486913 | 2486913 | 2022-05-09 | Okeechobee | Florida | 12093 | 10649 | 183 |
2487493 | 2487493 | 2022-05-09 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2487928 | 2487928 | 2022-05-09 | Olmsted | Minnesota | 27109 | 42992 | 183 |
2488535 | 2488535 | 2022-05-09 | Sampson | North Carolina | 37163 | 18869 | 183 |
2489248 | 2489248 | 2022-05-09 | Fannin | Texas | 48147 | 6890 | 183 |
2483655 | 2483655 | 2022-05-08 | Okeechobee | Florida | 12093 | 10649 | 183 |
2484235 | 2484235 | 2022-05-08 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2484670 | 2484670 | 2022-05-08 | Olmsted | Minnesota | 27109 | 42844 | 183 |
2485278 | 2485278 | 2022-05-08 | Sampson | North Carolina | 37163 | 18869 | 183 |
2485991 | 2485991 | 2022-05-08 | Fannin | Texas | 48147 | 6890 | 183 |
2480397 | 2480397 | 2022-05-07 | Okeechobee | Florida | 12093 | 10649 | 183 |
2480977 | 2480977 | 2022-05-07 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2481412 | 2481412 | 2022-05-07 | Olmsted | Minnesota | 27109 | 42844 | 183 |
2482020 | 2482020 | 2022-05-07 | Sampson | North Carolina | 37163 | 18869 | 183 |
2482733 | 2482733 | 2022-05-07 | Fannin | Texas | 48147 | 6890 | 183 |
2477139 | 2477139 | 2022-05-06 | Okeechobee | Florida | 12093 | 10649 | 183 |
2477719 | 2477719 | 2022-05-06 | Leavenworth | Kansas | 20103 | 19527 | 183 |
2478154 | 2478154 | 2022-05-06 | Olmsted | Minnesota | 27109 | 42844 | 183 |
2478762 | 2478762 | 2022-05-06 | Sampson | North Carolina | 37163 | 18869 | 183 |
2479475 | 2479475 | 2022-05-06 | Fannin | Texas | 48147 | 6889 | 183 |
2473881 | 2473881 | 2022-05-05 | Okeechobee | Florida | 12093 | 10630 | 183 |
2474461 | 2474461 | 2022-05-05 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2474896 | 2474896 | 2022-05-05 | Olmsted | Minnesota | 27109 | 42687 | 183 |
2475504 | 2475504 | 2022-05-05 | Sampson | North Carolina | 37163 | 18869 | 183 |
2476217 | 2476217 | 2022-05-05 | Fannin | Texas | 48147 | 6888 | 183 |
2470624 | 2470624 | 2022-05-04 | Okeechobee | Florida | 12093 | 10630 | 183 |
2471204 | 2471204 | 2022-05-04 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2471639 | 2471639 | 2022-05-04 | Olmsted | Minnesota | 27109 | 42561 | 183 |
2472247 | 2472247 | 2022-05-04 | Sampson | North Carolina | 37163 | 18869 | 183 |
2472960 | 2472960 | 2022-05-04 | Fannin | Texas | 48147 | 6883 | 183 |
2473448 | 2473448 | 2022-05-04 | La Crosse | Wisconsin | 55063 | 35510 | 183 |
2467948 | 2467948 | 2022-05-03 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2468383 | 2468383 | 2022-05-03 | Olmsted | Minnesota | 27109 | 42446 | 183 |
2469560 | 2469560 | 2022-05-03 | Franklin | Tennessee | 47051 | 12880 | 183 |
2469704 | 2469704 | 2022-05-03 | Fannin | Texas | 48147 | 6882 | 183 |
2464693 | 2464693 | 2022-05-02 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2465128 | 2465128 | 2022-05-02 | Olmsted | Minnesota | 27109 | 42313 | 183 |
2466304 | 2466304 | 2022-05-02 | Franklin | Tennessee | 47051 | 12880 | 183 |
2466448 | 2466448 | 2022-05-02 | Fannin | Texas | 48147 | 6881 | 183 |
2461198 | 2461198 | 2022-05-01 | Boone | Indiana | 18011 | 15328 | 183 |
2461437 | 2461437 | 2022-05-01 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2463049 | 2463049 | 2022-05-01 | Franklin | Tennessee | 47051 | 12880 | 183 |
2463193 | 2463193 | 2022-05-01 | Fannin | Texas | 48147 | 6881 | 183 |
2457942 | 2457942 | 2022-04-30 | Boone | Indiana | 18011 | 15328 | 183 |
2458181 | 2458181 | 2022-04-30 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2459793 | 2459793 | 2022-04-30 | Franklin | Tennessee | 47051 | 12880 | 183 |
2459937 | 2459937 | 2022-04-30 | Fannin | Texas | 48147 | 6881 | 183 |
2454686 | 2454686 | 2022-04-29 | Boone | Indiana | 18011 | 15328 | 183 |
2454925 | 2454925 | 2022-04-29 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2456537 | 2456537 | 2022-04-29 | Franklin | Tennessee | 47051 | 12880 | 183 |
2456681 | 2456681 | 2022-04-29 | Fannin | Texas | 48147 | 6879 | 183 |
2451669 | 2451669 | 2022-04-28 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2453281 | 2453281 | 2022-04-28 | Franklin | Tennessee | 47051 | 12880 | 183 |
2453425 | 2453425 | 2022-04-28 | Fannin | Texas | 48147 | 6878 | 183 |
2453889 | 2453889 | 2022-04-28 | Chippewa | Wisconsin | 55017 | 18842 | 183 |
2448413 | 2448413 | 2022-04-27 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2450025 | 2450025 | 2022-04-27 | Franklin | Tennessee | 47051 | 12880 | 183 |
2450169 | 2450169 | 2022-04-27 | Fannin | Texas | 48147 | 6877 | 183 |
2450633 | 2450633 | 2022-04-27 | Chippewa | Wisconsin | 55017 | 18819 | 183 |
2445157 | 2445157 | 2022-04-26 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2446768 | 2446768 | 2022-04-26 | Franklin | Tennessee | 47051 | 12867 | 183 |
2446912 | 2446912 | 2022-04-26 | Fannin | Texas | 48147 | 6876 | 183 |
2441901 | 2441901 | 2022-04-25 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2443513 | 2443513 | 2022-04-25 | Franklin | Tennessee | 47051 | 12867 | 183 |
2443657 | 2443657 | 2022-04-25 | Fannin | Texas | 48147 | 6875 | 183 |
2444080 | 2444080 | 2022-04-25 | Logan | West Virginia | 54045 | 9614 | 183 |
2438645 | 2438645 | 2022-04-24 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2440257 | 2440257 | 2022-04-24 | Franklin | Tennessee | 47051 | 12867 | 183 |
2440401 | 2440401 | 2022-04-24 | Fannin | Texas | 48147 | 6875 | 183 |
2440824 | 2440824 | 2022-04-24 | Logan | West Virginia | 54045 | 9599 | 183 |
2435389 | 2435389 | 2022-04-23 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2437001 | 2437001 | 2022-04-23 | Franklin | Tennessee | 47051 | 12867 | 183 |
2437145 | 2437145 | 2022-04-23 | Fannin | Texas | 48147 | 6875 | 183 |
2437568 | 2437568 | 2022-04-23 | Logan | West Virginia | 54045 | 9599 | 183 |
2432133 | 2432133 | 2022-04-22 | Leavenworth | Kansas | 20103 | 19407 | 183 |
2433745 | 2433745 | 2022-04-22 | Franklin | Tennessee | 47051 | 12867 | 183 |
2433889 | 2433889 | 2022-04-22 | Fannin | Texas | 48147 | 6871 | 183 |
2434312 | 2434312 | 2022-04-22 | Logan | West Virginia | 54045 | 9599 | 183 |
2428638 | 2428638 | 2022-04-21 | Boone | Indiana | 18011 | 15255 | 183 |
2428877 | 2428877 | 2022-04-21 | Leavenworth | Kansas | 20103 | 19364 | 183 |
2430489 | 2430489 | 2022-04-21 | Franklin | Tennessee | 47051 | 12867 | 183 |
2430633 | 2430633 | 2022-04-21 | Fannin | Texas | 48147 | 6867 | 183 |
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);