ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55,292 rows where deaths = 3 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 4,317
- Georgia 2,846
- Nebraska 2,633
- Kansas 2,443
- Virginia 2,164
- Missouri 2,153
- Colorado 2,099
- Kentucky 2,097
- South Dakota 1,993
- Minnesota 1,985
- North Dakota 1,779
- North Carolina 1,729
- Iowa 1,663
- Oklahoma 1,526
- Montana 1,447
- Ohio 1,233
- Alaska 1,215
- Tennessee 1,179
- Arkansas 1,175
- Illinois 1,150
- Michigan 1,149
- Indiana 1,079
- Wisconsin 999
- Mississippi 995
- Oregon 895
- Idaho 885
- Washington 874
- West Virginia 870
- Vermont 846
- Pennsylvania 841
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499642 | 2499642 | 2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 |
2500096 | 2500096 | 2022-05-13 | Taliaferro | Georgia | 13265 | 268 | 3 |
2500508 | 2500508 | 2022-05-13 | Greeley | Kansas | 20071 | 331 | 3 |
2500510 | 2500510 | 2022-05-13 | Hamilton | Kansas | 20075 | 464 | 3 |
2501066 | 2501066 | 2022-05-13 | Unknown | Mississippi | 1919 | 3 | |
2501191 | 2501191 | 2022-05-13 | Worth | Missouri | 29227 | 407 | 3 |
2501209 | 2501209 | 2022-05-13 | Garfield | Montana | 30033 | 225 | 3 |
2501232 | 2501232 | 2022-05-13 | Prairie | Montana | 30079 | 263 | 3 |
2501253 | 2501253 | 2022-05-13 | Blaine | Nebraska | 31009 | 65 | 3 |
2501280 | 2501280 | 2022-05-13 | Frontier | Nebraska | 31063 | 543 | 3 |
2501290 | 2501290 | 2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 |
2501348 | 2501348 | 2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 |
2501592 | 2501592 | 2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 |
2501845 | 2501845 | 2022-05-13 | Wheeler | Oregon | 41069 | 246 | 3 |
2502075 | 2502075 | 2022-05-13 | Harding | South Dakota | 46063 | 201 | 3 |
2502103 | 2502103 | 2022-05-13 | Sully | South Dakota | 46119 | 245 | 3 |
2502293 | 2502293 | 2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 |
2502309 | 2502309 | 2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 |
2502324 | 2502324 | 2022-05-13 | Irion | Texas | 48235 | 445 | 3 |
2502429 | 2502429 | 2022-05-13 | Terrell | Texas | 48443 | 121 | 3 |
2502496 | 2502496 | 2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 |
2496384 | 2496384 | 2022-05-12 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 |
2496838 | 2496838 | 2022-05-12 | Taliaferro | Georgia | 13265 | 268 | 3 |
2497250 | 2497250 | 2022-05-12 | Greeley | Kansas | 20071 | 331 | 3 |
2497252 | 2497252 | 2022-05-12 | Hamilton | Kansas | 20075 | 464 | 3 |
2497808 | 2497808 | 2022-05-12 | Unknown | Mississippi | 1218 | 3 | |
2497933 | 2497933 | 2022-05-12 | Worth | Missouri | 29227 | 407 | 3 |
2497951 | 2497951 | 2022-05-12 | Garfield | Montana | 30033 | 225 | 3 |
2497974 | 2497974 | 2022-05-12 | Prairie | Montana | 30079 | 263 | 3 |
2497995 | 2497995 | 2022-05-12 | Blaine | Nebraska | 31009 | 65 | 3 |
2498022 | 2498022 | 2022-05-12 | Frontier | Nebraska | 31063 | 543 | 3 |
2498032 | 2498032 | 2022-05-12 | Harlan | Nebraska | 31083 | 348 | 3 |
2498090 | 2498090 | 2022-05-12 | Esmeralda | Nevada | 32009 | 109 | 3 |
2498334 | 2498334 | 2022-05-12 | Burke | North Dakota | 38013 | 433 | 3 |
2498587 | 2498587 | 2022-05-12 | Wheeler | Oregon | 41069 | 246 | 3 |
2498817 | 2498817 | 2022-05-12 | Harding | South Dakota | 46063 | 201 | 3 |
2498845 | 2498845 | 2022-05-12 | Sully | South Dakota | 46119 | 245 | 3 |
2499035 | 2499035 | 2022-05-12 | Glasscock | Texas | 48173 | 199 | 3 |
2499051 | 2499051 | 2022-05-12 | Hartley | Texas | 48205 | 1364 | 3 |
2499066 | 2499066 | 2022-05-12 | Irion | Texas | 48235 | 445 | 3 |
2499171 | 2499171 | 2022-05-12 | Terrell | Texas | 48443 | 121 | 3 |
2499238 | 2499238 | 2022-05-12 | Essex | Vermont | 50009 | 1296 | 3 |
2493126 | 2493126 | 2022-05-11 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 |
2493580 | 2493580 | 2022-05-11 | Taliaferro | Georgia | 13265 | 268 | 3 |
2493992 | 2493992 | 2022-05-11 | Greeley | Kansas | 20071 | 331 | 3 |
2493994 | 2493994 | 2022-05-11 | Hamilton | Kansas | 20075 | 464 | 3 |
2494675 | 2494675 | 2022-05-11 | Worth | Missouri | 29227 | 407 | 3 |
2494693 | 2494693 | 2022-05-11 | Garfield | Montana | 30033 | 225 | 3 |
2494716 | 2494716 | 2022-05-11 | Prairie | Montana | 30079 | 263 | 3 |
2494737 | 2494737 | 2022-05-11 | Blaine | Nebraska | 31009 | 65 | 3 |
2494764 | 2494764 | 2022-05-11 | Frontier | Nebraska | 31063 | 543 | 3 |
2494774 | 2494774 | 2022-05-11 | Harlan | Nebraska | 31083 | 348 | 3 |
2494832 | 2494832 | 2022-05-11 | Esmeralda | Nevada | 32009 | 109 | 3 |
2495076 | 2495076 | 2022-05-11 | Burke | North Dakota | 38013 | 433 | 3 |
2495329 | 2495329 | 2022-05-11 | Wheeler | Oregon | 41069 | 245 | 3 |
2495559 | 2495559 | 2022-05-11 | Harding | South Dakota | 46063 | 201 | 3 |
2495587 | 2495587 | 2022-05-11 | Sully | South Dakota | 46119 | 245 | 3 |
2495777 | 2495777 | 2022-05-11 | Glasscock | Texas | 48173 | 199 | 3 |
2495793 | 2495793 | 2022-05-11 | Hartley | Texas | 48205 | 1364 | 3 |
2495808 | 2495808 | 2022-05-11 | Irion | Texas | 48235 | 445 | 3 |
2495913 | 2495913 | 2022-05-11 | Terrell | Texas | 48443 | 121 | 3 |
2495980 | 2495980 | 2022-05-11 | Essex | Vermont | 50009 | 1292 | 3 |
2489868 | 2489868 | 2022-05-10 | Aleutians East Borough | Alaska | 2013 | 1099 | 3 |
2490322 | 2490322 | 2022-05-10 | Taliaferro | Georgia | 13265 | 268 | 3 |
2490734 | 2490734 | 2022-05-10 | Greeley | Kansas | 20071 | 331 | 3 |
2490736 | 2490736 | 2022-05-10 | Hamilton | Kansas | 20075 | 464 | 3 |
2491417 | 2491417 | 2022-05-10 | Worth | Missouri | 29227 | 407 | 3 |
2491435 | 2491435 | 2022-05-10 | Garfield | Montana | 30033 | 225 | 3 |
2491458 | 2491458 | 2022-05-10 | Prairie | Montana | 30079 | 263 | 3 |
2491479 | 2491479 | 2022-05-10 | Blaine | Nebraska | 31009 | 69 | 3 |
2491506 | 2491506 | 2022-05-10 | Frontier | Nebraska | 31063 | 543 | 3 |
2491516 | 2491516 | 2022-05-10 | Harlan | Nebraska | 31083 | 400 | 3 |
2491574 | 2491574 | 2022-05-10 | Esmeralda | Nevada | 32009 | 107 | 3 |
2491818 | 2491818 | 2022-05-10 | Burke | North Dakota | 38013 | 433 | 3 |
2492071 | 2492071 | 2022-05-10 | Wheeler | Oregon | 41069 | 245 | 3 |
2492301 | 2492301 | 2022-05-10 | Harding | South Dakota | 46063 | 201 | 3 |
2492329 | 2492329 | 2022-05-10 | Sully | South Dakota | 46119 | 245 | 3 |
2492519 | 2492519 | 2022-05-10 | Glasscock | Texas | 48173 | 199 | 3 |
2492535 | 2492535 | 2022-05-10 | Hartley | Texas | 48205 | 1364 | 3 |
2492550 | 2492550 | 2022-05-10 | Irion | Texas | 48235 | 445 | 3 |
2492655 | 2492655 | 2022-05-10 | Terrell | Texas | 48443 | 121 | 3 |
2492722 | 2492722 | 2022-05-10 | Essex | Vermont | 50009 | 1291 | 3 |
2486611 | 2486611 | 2022-05-09 | Aleutians East Borough | Alaska | 2013 | 1099 | 3 |
2487065 | 2487065 | 2022-05-09 | Taliaferro | Georgia | 13265 | 268 | 3 |
2487477 | 2487477 | 2022-05-09 | Greeley | Kansas | 20071 | 331 | 3 |
2487479 | 2487479 | 2022-05-09 | Hamilton | Kansas | 20075 | 464 | 3 |
2488159 | 2488159 | 2022-05-09 | Worth | Missouri | 29227 | 407 | 3 |
2488177 | 2488177 | 2022-05-09 | Garfield | Montana | 30033 | 225 | 3 |
2488200 | 2488200 | 2022-05-09 | Prairie | Montana | 30079 | 263 | 3 |
2488221 | 2488221 | 2022-05-09 | Blaine | Nebraska | 31009 | 69 | 3 |
2488248 | 2488248 | 2022-05-09 | Frontier | Nebraska | 31063 | 543 | 3 |
2488258 | 2488258 | 2022-05-09 | Harlan | Nebraska | 31083 | 400 | 3 |
2488316 | 2488316 | 2022-05-09 | Esmeralda | Nevada | 32009 | 107 | 3 |
2488560 | 2488560 | 2022-05-09 | Burke | North Dakota | 38013 | 433 | 3 |
2488813 | 2488813 | 2022-05-09 | Wheeler | Oregon | 41069 | 244 | 3 |
2489043 | 2489043 | 2022-05-09 | Harding | South Dakota | 46063 | 201 | 3 |
2489071 | 2489071 | 2022-05-09 | Sully | South Dakota | 46119 | 245 | 3 |
2489261 | 2489261 | 2022-05-09 | Glasscock | Texas | 48173 | 199 | 3 |
2489277 | 2489277 | 2022-05-09 | Hartley | Texas | 48205 | 1364 | 3 |
2489292 | 2489292 | 2022-05-09 | Irion | Texas | 48235 | 445 | 3 |
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);