ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21,443 rows where deaths = 20 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
- Virginia 1,376
- Texas 1,308
- Kentucky 1,292
- South Dakota 1,020
- Missouri 1,006
- Kansas 987
- Nebraska 969
- Oklahoma 920
- Georgia 898
- Illinois 890
- Minnesota 813
- North Carolina 697
- North Dakota 640
- Iowa 633
- Colorado 512
- Michigan 510
- Arkansas 495
- Tennessee 483
- Mississippi 438
- Wisconsin 410
- West Virginia 409
- Montana 382
- Indiana 369
- Florida 343
- Pennsylvania 338
- Ohio 318
- Idaho 303
- Louisiana 276
- Alabama 274
- Oregon 235
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499664 | 2499664 | 2022-05-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 2052 | 20 |
2499814 | 2499814 | 2022-05-13 | Trinity | California | 6105 | 1485 | 20 |
2499867 | 2499867 | 2022-05-13 | Park | Colorado | 8093 | 2913 | 20 |
2500171 | 2500171 | 2022-05-13 | Power | Idaho | 16077 | 1496 | 20 |
2500211 | 2500211 | 2022-05-13 | Hardin | Illinois | 17069 | 1059 | 20 |
2500357 | 2500357 | 2022-05-13 | Switzerland | Indiana | 18155 | 2320 | 20 |
2500361 | 2500361 | 2022-05-13 | Unknown | Indiana | 0 | 20 | |
2500492 | 2500492 | 2022-05-13 | Decatur | Kansas | 20039 | 620 | 20 |
2500519 | 2500519 | 2022-05-13 | Kearny | Kansas | 20093 | 1236 | 20 |
2500532 | 2500532 | 2022-05-13 | Meade | Kansas | 20119 | 1221 | 20 |
2500554 | 2500554 | 2022-05-13 | Rooks | Kansas | 20163 | 1377 | 20 |
2500563 | 2500563 | 2022-05-13 | Sherman | Kansas | 20181 | 1514 | 20 |
2500567 | 2500567 | 2022-05-13 | Stevens | Kansas | 20189 | 1465 | 20 |
2500598 | 2500598 | 2022-05-13 | Carlisle | Kentucky | 21039 | 1076 | 20 |
2501220 | 2501220 | 2022-05-13 | Madison | Montana | 30057 | 1819 | 20 |
2501293 | 2501293 | 2022-05-13 | Holt | Nebraska | 31089 | 2179 | 20 |
2501299 | 2501299 | 2022-05-13 | Keith | Nebraska | 31101 | 1533 | 20 |
2501312 | 2501312 | 2022-05-13 | Nemaha | Nebraska | 31127 | 1340 | 20 |
2501321 | 2501321 | 2022-05-13 | Red Willow | Nebraska | 31145 | 2325 | 20 |
2501360 | 2501360 | 2022-05-13 | White Pine | Nevada | 32033 | 1693 | 20 |
2501522 | 2501522 | 2022-05-13 | Gates | North Carolina | 37073 | 1926 | 20 |
2501608 | 2501608 | 2022-05-13 | LaMoure | North Dakota | 38045 | 1015 | 20 |
2502051 | 2502051 | 2022-05-13 | Brule | South Dakota | 46015 | 1415 | 20 |
2502080 | 2502080 | 2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2502247 | 2502247 | 2022-05-13 | Coke | Texas | 48081 | 843 | 20 |
2502519 | 2502519 | 2022-05-13 | Bath | Virginia | 51017 | 906 | 20 |
2502630 | 2502630 | 2022-05-13 | Surry | Virginia | 51181 | 1110 | 20 |
2496406 | 2496406 | 2022-05-12 | Southeast Fairbanks Census Area | Alaska | 2240 | 2052 | 20 |
2496556 | 2496556 | 2022-05-12 | Trinity | California | 6105 | 1485 | 20 |
2496609 | 2496609 | 2022-05-12 | Park | Colorado | 8093 | 2908 | 20 |
2496913 | 2496913 | 2022-05-12 | Power | Idaho | 16077 | 1495 | 20 |
2496953 | 2496953 | 2022-05-12 | Hardin | Illinois | 17069 | 1059 | 20 |
2497099 | 2497099 | 2022-05-12 | Switzerland | Indiana | 18155 | 2320 | 20 |
2497234 | 2497234 | 2022-05-12 | Decatur | Kansas | 20039 | 619 | 20 |
2497261 | 2497261 | 2022-05-12 | Kearny | Kansas | 20093 | 1236 | 20 |
2497274 | 2497274 | 2022-05-12 | Meade | Kansas | 20119 | 1220 | 20 |
2497296 | 2497296 | 2022-05-12 | Rooks | Kansas | 20163 | 1373 | 20 |
2497305 | 2497305 | 2022-05-12 | Sherman | Kansas | 20181 | 1513 | 20 |
2497309 | 2497309 | 2022-05-12 | Stevens | Kansas | 20189 | 1464 | 20 |
2497340 | 2497340 | 2022-05-12 | Carlisle | Kentucky | 21039 | 1076 | 20 |
2497962 | 2497962 | 2022-05-12 | Madison | Montana | 30057 | 1818 | 20 |
2498035 | 2498035 | 2022-05-12 | Holt | Nebraska | 31089 | 2177 | 20 |
2498041 | 2498041 | 2022-05-12 | Keith | Nebraska | 31101 | 1533 | 20 |
2498052 | 2498052 | 2022-05-12 | Morrill | Nebraska | 31123 | 1144 | 20 |
2498054 | 2498054 | 2022-05-12 | Nemaha | Nebraska | 31127 | 1336 | 20 |
2498063 | 2498063 | 2022-05-12 | Red Willow | Nebraska | 31145 | 2322 | 20 |
2498102 | 2498102 | 2022-05-12 | White Pine | Nevada | 32033 | 1693 | 20 |
2498264 | 2498264 | 2022-05-12 | Gates | North Carolina | 37073 | 1926 | 20 |
2498350 | 2498350 | 2022-05-12 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2498793 | 2498793 | 2022-05-12 | Brule | South Dakota | 46015 | 1415 | 20 |
2498822 | 2498822 | 2022-05-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2498989 | 2498989 | 2022-05-12 | Coke | Texas | 48081 | 843 | 20 |
2499261 | 2499261 | 2022-05-12 | Bath | Virginia | 51017 | 905 | 20 |
2499372 | 2499372 | 2022-05-12 | Surry | Virginia | 51181 | 1110 | 20 |
2493148 | 2493148 | 2022-05-11 | Southeast Fairbanks Census Area | Alaska | 2240 | 2052 | 20 |
2493298 | 2493298 | 2022-05-11 | Trinity | California | 6105 | 1485 | 20 |
2493351 | 2493351 | 2022-05-11 | Park | Colorado | 8093 | 2890 | 20 |
2493655 | 2493655 | 2022-05-11 | Power | Idaho | 16077 | 1495 | 20 |
2493695 | 2493695 | 2022-05-11 | Hardin | Illinois | 17069 | 1059 | 20 |
2493841 | 2493841 | 2022-05-11 | Switzerland | Indiana | 18155 | 2320 | 20 |
2493976 | 2493976 | 2022-05-11 | Decatur | Kansas | 20039 | 619 | 20 |
2494003 | 2494003 | 2022-05-11 | Kearny | Kansas | 20093 | 1236 | 20 |
2494016 | 2494016 | 2022-05-11 | Meade | Kansas | 20119 | 1220 | 20 |
2494038 | 2494038 | 2022-05-11 | Rooks | Kansas | 20163 | 1373 | 20 |
2494047 | 2494047 | 2022-05-11 | Sherman | Kansas | 20181 | 1513 | 20 |
2494051 | 2494051 | 2022-05-11 | Stevens | Kansas | 20189 | 1464 | 20 |
2494082 | 2494082 | 2022-05-11 | Carlisle | Kentucky | 21039 | 1076 | 20 |
2494704 | 2494704 | 2022-05-11 | Madison | Montana | 30057 | 1818 | 20 |
2494777 | 2494777 | 2022-05-11 | Holt | Nebraska | 31089 | 2177 | 20 |
2494783 | 2494783 | 2022-05-11 | Keith | Nebraska | 31101 | 1533 | 20 |
2494794 | 2494794 | 2022-05-11 | Morrill | Nebraska | 31123 | 1144 | 20 |
2494796 | 2494796 | 2022-05-11 | Nemaha | Nebraska | 31127 | 1336 | 20 |
2494805 | 2494805 | 2022-05-11 | Red Willow | Nebraska | 31145 | 2322 | 20 |
2494844 | 2494844 | 2022-05-11 | White Pine | Nevada | 32033 | 1693 | 20 |
2495006 | 2495006 | 2022-05-11 | Gates | North Carolina | 37073 | 1926 | 20 |
2495092 | 2495092 | 2022-05-11 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2495535 | 2495535 | 2022-05-11 | Brule | South Dakota | 46015 | 1415 | 20 |
2495564 | 2495564 | 2022-05-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2495731 | 2495731 | 2022-05-11 | Coke | Texas | 48081 | 842 | 20 |
2496003 | 2496003 | 2022-05-11 | Bath | Virginia | 51017 | 903 | 20 |
2496114 | 2496114 | 2022-05-11 | Surry | Virginia | 51181 | 1107 | 20 |
2489890 | 2489890 | 2022-05-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2490040 | 2490040 | 2022-05-10 | Trinity | California | 6105 | 1485 | 20 |
2490093 | 2490093 | 2022-05-10 | Park | Colorado | 8093 | 2883 | 20 |
2490397 | 2490397 | 2022-05-10 | Power | Idaho | 16077 | 1495 | 20 |
2490437 | 2490437 | 2022-05-10 | Hardin | Illinois | 17069 | 1059 | 20 |
2490583 | 2490583 | 2022-05-10 | Switzerland | Indiana | 18155 | 2319 | 20 |
2490718 | 2490718 | 2022-05-10 | Decatur | Kansas | 20039 | 619 | 20 |
2490745 | 2490745 | 2022-05-10 | Kearny | Kansas | 20093 | 1236 | 20 |
2490758 | 2490758 | 2022-05-10 | Meade | Kansas | 20119 | 1220 | 20 |
2490780 | 2490780 | 2022-05-10 | Rooks | Kansas | 20163 | 1373 | 20 |
2490789 | 2490789 | 2022-05-10 | Sherman | Kansas | 20181 | 1513 | 20 |
2490793 | 2490793 | 2022-05-10 | Stevens | Kansas | 20189 | 1464 | 20 |
2490824 | 2490824 | 2022-05-10 | Carlisle | Kentucky | 21039 | 1076 | 20 |
2491446 | 2491446 | 2022-05-10 | Madison | Montana | 30057 | 1818 | 20 |
2491519 | 2491519 | 2022-05-10 | Holt | Nebraska | 31089 | 2163 | 20 |
2491536 | 2491536 | 2022-05-10 | Morrill | Nebraska | 31123 | 1260 | 20 |
2491538 | 2491538 | 2022-05-10 | Nemaha | Nebraska | 31127 | 1535 | 20 |
2491547 | 2491547 | 2022-05-10 | Red Willow | Nebraska | 31145 | 2363 | 20 |
2491748 | 2491748 | 2022-05-10 | Gates | North Carolina | 37073 | 1913 | 20 |
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);