ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39,623 rows where deaths = 5 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 3,618
- Nebraska 2,333
- Virginia 1,932
- Montana 1,804
- Kansas 1,689
- Illinois 1,543
- North Carolina 1,543
- Georgia 1,520
- Colorado 1,493
- Minnesota 1,385
- Michigan 1,303
- Kentucky 1,266
- South Dakota 1,209
- New York 1,052
- North Dakota 991
- Oklahoma 975
- Missouri 828
- Alaska 794
- Ohio 755
- Arkansas 748
- Tennessee 745
- Iowa 702
- West Virginia 648
- Indiana 645
- Washington 621
- Idaho 581
- New Mexico 558
- Pennsylvania 556
- Alabama 537
- Oregon 524
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499657 | 2499657 | 2022-05-13 | Nome Census Area | Alaska | 2180 | 6245 | 5 |
2499662 | 2499662 | 2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2499668 | 2499668 | 2022-05-13 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2500573 | 2500573 | 2022-05-13 | Wallace | Kansas | 20199 | 438 | 5 |
2501198 | 2501198 | 2022-05-13 | Carter | Montana | 30011 | 252 | 5 |
2501211 | 2501211 | 2022-05-13 | Golden Valley | Montana | 30037 | 150 | 5 |
2501254 | 2501254 | 2022-05-13 | Boone | Nebraska | 31011 | 1074 | 5 |
2501286 | 2501286 | 2022-05-13 | Grant | Nebraska | 31075 | 100 | 5 |
2501294 | 2501294 | 2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 |
2501447 | 2501447 | 2022-05-13 | Hamilton | New York | 36041 | 919 | 5 |
2501618 | 2501618 | 2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 |
2501724 | 2501724 | 2022-05-13 | Unknown | Ohio | 0 | 5 | |
2501821 | 2501821 | 2022-05-13 | Gilliam | Oregon | 41021 | 284 | 5 |
2502498 | 2502498 | 2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 |
2502508 | 2502508 | 2022-05-13 | St. John | Virgin Islands | 78020 | 832 | 5 |
2496399 | 2496399 | 2022-05-12 | Nome Census Area | Alaska | 2180 | 6245 | 5 |
2496404 | 2496404 | 2022-05-12 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2496410 | 2496410 | 2022-05-12 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2496586 | 2496586 | 2022-05-12 | Gilpin | Colorado | 8047 | 975 | 5 |
2497315 | 2497315 | 2022-05-12 | Wallace | Kansas | 20199 | 438 | 5 |
2497940 | 2497940 | 2022-05-12 | Carter | Montana | 30011 | 252 | 5 |
2497953 | 2497953 | 2022-05-12 | Golden Valley | Montana | 30037 | 150 | 5 |
2497996 | 2497996 | 2022-05-12 | Boone | Nebraska | 31011 | 1073 | 5 |
2498028 | 2498028 | 2022-05-12 | Grant | Nebraska | 31075 | 100 | 5 |
2498036 | 2498036 | 2022-05-12 | Hooker | Nebraska | 31091 | 113 | 5 |
2498189 | 2498189 | 2022-05-12 | Hamilton | New York | 36041 | 919 | 5 |
2498360 | 2498360 | 2022-05-12 | Oliver | North Dakota | 38065 | 329 | 5 |
2498466 | 2498466 | 2022-05-12 | Unknown | Ohio | 0 | 5 | |
2498563 | 2498563 | 2022-05-12 | Gilliam | Oregon | 41021 | 284 | 5 |
2499240 | 2499240 | 2022-05-12 | Grand Isle | Vermont | 50013 | 1130 | 5 |
2499250 | 2499250 | 2022-05-12 | St. John | Virgin Islands | 78020 | 830 | 5 |
2493141 | 2493141 | 2022-05-11 | Nome Census Area | Alaska | 2180 | 6245 | 5 |
2493146 | 2493146 | 2022-05-11 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2493152 | 2493152 | 2022-05-11 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2493328 | 2493328 | 2022-05-11 | Gilpin | Colorado | 8047 | 973 | 5 |
2494057 | 2494057 | 2022-05-11 | Wallace | Kansas | 20199 | 438 | 5 |
2494682 | 2494682 | 2022-05-11 | Carter | Montana | 30011 | 252 | 5 |
2494695 | 2494695 | 2022-05-11 | Golden Valley | Montana | 30037 | 150 | 5 |
2494738 | 2494738 | 2022-05-11 | Boone | Nebraska | 31011 | 1073 | 5 |
2494770 | 2494770 | 2022-05-11 | Grant | Nebraska | 31075 | 100 | 5 |
2494778 | 2494778 | 2022-05-11 | Hooker | Nebraska | 31091 | 113 | 5 |
2494931 | 2494931 | 2022-05-11 | Hamilton | New York | 36041 | 919 | 5 |
2495102 | 2495102 | 2022-05-11 | Oliver | North Dakota | 38065 | 329 | 5 |
2495305 | 2495305 | 2022-05-11 | Gilliam | Oregon | 41021 | 284 | 5 |
2495982 | 2495982 | 2022-05-11 | Grand Isle | Vermont | 50013 | 1126 | 5 |
2495992 | 2495992 | 2022-05-11 | St. John | Virgin Islands | 78020 | 813 | 5 |
2489883 | 2489883 | 2022-05-10 | Nome Census Area | Alaska | 2180 | 6235 | 5 |
2489888 | 2489888 | 2022-05-10 | Sitka City and Borough | Alaska | 2220 | 2607 | 5 |
2489894 | 2489894 | 2022-05-10 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2490799 | 2490799 | 2022-05-10 | Wallace | Kansas | 20199 | 438 | 5 |
2491424 | 2491424 | 2022-05-10 | Carter | Montana | 30011 | 252 | 5 |
2491437 | 2491437 | 2022-05-10 | Golden Valley | Montana | 30037 | 150 | 5 |
2491480 | 2491480 | 2022-05-10 | Boone | Nebraska | 31011 | 1111 | 5 |
2491512 | 2491512 | 2022-05-10 | Grant | Nebraska | 31075 | 104 | 5 |
2491520 | 2491520 | 2022-05-10 | Hooker | Nebraska | 31091 | 113 | 5 |
2491673 | 2491673 | 2022-05-10 | Hamilton | New York | 36041 | 916 | 5 |
2491844 | 2491844 | 2022-05-10 | Oliver | North Dakota | 38065 | 329 | 5 |
2492047 | 2492047 | 2022-05-10 | Gilliam | Oregon | 41021 | 284 | 5 |
2492724 | 2492724 | 2022-05-10 | Grand Isle | Vermont | 50013 | 1125 | 5 |
2492734 | 2492734 | 2022-05-10 | St. John | Virgin Islands | 78020 | 812 | 5 |
2486626 | 2486626 | 2022-05-09 | Nome Census Area | Alaska | 2180 | 6235 | 5 |
2486631 | 2486631 | 2022-05-09 | Sitka City and Borough | Alaska | 2220 | 2607 | 5 |
2486637 | 2486637 | 2022-05-09 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2487542 | 2487542 | 2022-05-09 | Wallace | Kansas | 20199 | 438 | 5 |
2488166 | 2488166 | 2022-05-09 | Carter | Montana | 30011 | 252 | 5 |
2488179 | 2488179 | 2022-05-09 | Golden Valley | Montana | 30037 | 150 | 5 |
2488222 | 2488222 | 2022-05-09 | Boone | Nebraska | 31011 | 1111 | 5 |
2488254 | 2488254 | 2022-05-09 | Grant | Nebraska | 31075 | 104 | 5 |
2488262 | 2488262 | 2022-05-09 | Hooker | Nebraska | 31091 | 113 | 5 |
2488415 | 2488415 | 2022-05-09 | Hamilton | New York | 36041 | 915 | 5 |
2488586 | 2488586 | 2022-05-09 | Oliver | North Dakota | 38065 | 329 | 5 |
2488789 | 2488789 | 2022-05-09 | Gilliam | Oregon | 41021 | 284 | 5 |
2489466 | 2489466 | 2022-05-09 | Grand Isle | Vermont | 50013 | 1123 | 5 |
2489476 | 2489476 | 2022-05-09 | St. John | Virgin Islands | 78020 | 812 | 5 |
2483368 | 2483368 | 2022-05-08 | Nome Census Area | Alaska | 2180 | 6235 | 5 |
2483373 | 2483373 | 2022-05-08 | Sitka City and Borough | Alaska | 2220 | 2607 | 5 |
2483379 | 2483379 | 2022-05-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2484284 | 2484284 | 2022-05-08 | Wallace | Kansas | 20199 | 438 | 5 |
2484909 | 2484909 | 2022-05-08 | Carter | Montana | 30011 | 252 | 5 |
2484922 | 2484922 | 2022-05-08 | Golden Valley | Montana | 30037 | 150 | 5 |
2484965 | 2484965 | 2022-05-08 | Boone | Nebraska | 31011 | 1111 | 5 |
2484997 | 2484997 | 2022-05-08 | Grant | Nebraska | 31075 | 104 | 5 |
2485005 | 2485005 | 2022-05-08 | Hooker | Nebraska | 31091 | 114 | 5 |
2485158 | 2485158 | 2022-05-08 | Hamilton | New York | 36041 | 914 | 5 |
2485329 | 2485329 | 2022-05-08 | Oliver | North Dakota | 38065 | 329 | 5 |
2485532 | 2485532 | 2022-05-08 | Gilliam | Oregon | 41021 | 284 | 5 |
2486208 | 2486208 | 2022-05-08 | Grand Isle | Vermont | 50013 | 1115 | 5 |
2486218 | 2486218 | 2022-05-08 | St. John | Virgin Islands | 78020 | 811 | 5 |
2480110 | 2480110 | 2022-05-07 | Nome Census Area | Alaska | 2180 | 6235 | 5 |
2480115 | 2480115 | 2022-05-07 | Sitka City and Borough | Alaska | 2220 | 2607 | 5 |
2480121 | 2480121 | 2022-05-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2481026 | 2481026 | 2022-05-07 | Wallace | Kansas | 20199 | 438 | 5 |
2481651 | 2481651 | 2022-05-07 | Carter | Montana | 30011 | 252 | 5 |
2481664 | 2481664 | 2022-05-07 | Golden Valley | Montana | 30037 | 150 | 5 |
2481707 | 2481707 | 2022-05-07 | Boone | Nebraska | 31011 | 1111 | 5 |
2481739 | 2481739 | 2022-05-07 | Grant | Nebraska | 31075 | 104 | 5 |
2481747 | 2481747 | 2022-05-07 | Hooker | Nebraska | 31091 | 114 | 5 |
2481900 | 2481900 | 2022-05-07 | Hamilton | New York | 36041 | 910 | 5 |
2482071 | 2482071 | 2022-05-07 | Oliver | North Dakota | 38065 | 329 | 5 |
2482274 | 2482274 | 2022-05-07 | Gilliam | Oregon | 41021 | 284 | 5 |
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);