ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4666 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 13
- Virginia 9
- Indiana 8
- Nebraska 7
- Texas 7
- Missouri 6
- Illinois 5
- Mississippi 5
- Minnesota 4
- New York 4
- Ohio 4
- Wisconsin 4
- Alabama 3
- Arkansas 3
- Michigan 3
- New Mexico 3
- Puerto Rico 3
- North Carolina 2
- Pennsylvania 2
- South Dakota 2
- West Virginia 2
- California 1
- Colorado 1
- Florida 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- Maine 1
- North Dakota 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490567 | 2490567 | 2022-05-10 | Perry | Indiana | 18123 | 4666 | 69 |
2487310 | 2487310 | 2022-05-09 | Perry | Indiana | 18123 | 4666 | 69 |
2444461 | 2444461 | 2022-04-26 | Chaffee | Colorado | 8015 | 4666 | 44 |
2444702 | 2444702 | 2022-04-26 | Morgan | Georgia | 13211 | 4666 | 68 |
2441446 | 2441446 | 2022-04-25 | Morgan | Georgia | 13211 | 4666 | 68 |
2438190 | 2438190 | 2022-04-24 | Morgan | Georgia | 13211 | 4666 | 68 |
2434934 | 2434934 | 2022-04-23 | Morgan | Georgia | 13211 | 4666 | 68 |
2431678 | 2431678 | 2022-04-22 | Morgan | Georgia | 13211 | 4666 | 68 |
2428422 | 2428422 | 2022-04-21 | Morgan | Georgia | 13211 | 4666 | 68 |
2425166 | 2425166 | 2022-04-20 | Morgan | Georgia | 13211 | 4666 | 68 |
2360005 | 2360005 | 2022-03-31 | Crisp | Georgia | 13081 | 4666 | 135 |
2353498 | 2353498 | 2022-03-29 | Crisp | Georgia | 13081 | 4666 | 135 |
2270450 | 2270450 | 2022-03-03 | Hertford | North Carolina | 37091 | 4666 | 81 |
2248455 | 2248455 | 2022-02-24 | Gonzales | Texas | 48177 | 4666 | 94 |
2229513 | 2229513 | 2022-02-19 | Fayette | Alabama | 1057 | 4666 | 92 |
2215530 | 2215530 | 2022-02-14 | Juniata | Pennsylvania | 42067 | 4666 | 169 |
2210757 | 2210757 | 2022-02-13 | Starke | Indiana | 18149 | 4666 | 92 |
2207504 | 2207504 | 2022-02-12 | Starke | Indiana | 18149 | 4666 | 92 |
2204251 | 2204251 | 2022-02-11 | Starke | Indiana | 18149 | 4666 | 92 |
2198928 | 2198928 | 2022-02-09 | Madison | North Carolina | 37115 | 4666 | 76 |
2172252 | 2172252 | 2022-02-01 | Osceola | Michigan | 26133 | 4666 | 67 |
2168999 | 2168999 | 2022-01-31 | Osceola | Michigan | 26133 | 4666 | 67 |
2151207 | 2151207 | 2022-01-25 | Scott | Virginia | 51169 | 4666 | 93 |
2143497 | 2143497 | 2022-01-23 | San Miguel | New Mexico | 35047 | 4666 | 42 |
2144026 | 2144026 | 2022-01-23 | Hatillo | Puerto Rico | 72065 | 4666 | |
2140242 | 2140242 | 2022-01-22 | San Miguel | New Mexico | 35047 | 4666 | 42 |
2136986 | 2136986 | 2022-01-21 | San Miguel | New Mexico | 35047 | 4666 | 42 |
2109003 | 2109003 | 2022-01-12 | Mason | West Virginia | 54053 | 4666 | 73 |
2099998 | 2099998 | 2022-01-10 | Douglas | Illinois | 17041 | 4666 | 49 |
2097735 | 2097735 | 2022-01-09 | Washington | Missouri | 29221 | 4666 | 106 |
2012282 | 2012282 | 2021-12-14 | Perry | Illinois | 17145 | 4666 | 89 |
1977384 | 1977384 | 2021-12-03 | Dunklin | Missouri | 29069 | 4666 | 93 |
1974134 | 1974134 | 2021-12-02 | Dunklin | Missouri | 29069 | 4666 | 93 |
1946742 | 1946742 | 2021-11-24 | Johnson | Arkansas | 5071 | 4666 | 58 |
1905829 | 1905829 | 2021-11-11 | Tate | Mississippi | 28137 | 4666 | 113 |
1902580 | 1902580 | 2021-11-10 | Tate | Mississippi | 28137 | 4666 | 113 |
1896935 | 1896935 | 2021-11-08 | Arecibo | Puerto Rico | 72013 | 4666 | |
1897105 | 1897105 | 2021-11-08 | Meade | South Dakota | 46093 | 4666 | 49 |
1893685 | 1893685 | 2021-11-07 | Arecibo | Puerto Rico | 72013 | 4666 | |
1873294 | 1873294 | 2021-11-01 | Itawamba | Mississippi | 28057 | 4666 | 105 |
1869970 | 1869970 | 2021-10-31 | Lyon | Minnesota | 27083 | 4666 | 56 |
1866721 | 1866721 | 2021-10-30 | Lyon | Minnesota | 27083 | 4666 | 56 |
1862289 | 1862289 | 2021-10-29 | Yell | Arkansas | 5149 | 4666 | 78 |
1863472 | 1863472 | 2021-10-29 | Lyon | Minnesota | 27083 | 4666 | 56 |
1807991 | 1807991 | 2021-10-12 | Allen | Louisiana | 22003 | 4666 | 111 |
1735923 | 1735923 | 2021-09-20 | Unknown | Georgia | 4666 | 14 | |
1720998 | 1720998 | 2021-09-15 | Cortland | New York | 36023 | 4666 | 69 |
1705034 | 1705034 | 2021-09-10 | Putnam | Ohio | 39137 | 4666 | 105 |
1693937 | 1693937 | 2021-09-07 | Steuben | Indiana | 18151 | 4666 | 66 |
1669040 | 1669040 | 2021-08-30 | Montgomery | New York | 36057 | 4666 | 130 |
1601386 | 1601386 | 2021-08-09 | Dillon | South Carolina | 45033 | 4666 | 85 |
1556733 | 1556733 | 2021-07-27 | Chilton | Alabama | 1021 | 4666 | 117 |
1553532 | 1553532 | 2021-07-26 | Russell | Alabama | 1113 | 4666 | 42 |
1528125 | 1528125 | 2021-07-18 | Franklin | Illinois | 17055 | 4666 | 90 |
1524878 | 1524878 | 2021-07-17 | Franklin | Illinois | 17055 | 4666 | 90 |
1521630 | 1521630 | 2021-07-16 | Franklin | Illinois | 17055 | 4666 | 90 |
1490004 | 1490004 | 2021-07-06 | Pearl River | Mississippi | 28109 | 4666 | 148 |
1459065 | 1459065 | 2021-06-26 | James City | Virginia | 51095 | 4666 | 72 |
1455701 | 1455701 | 2021-06-25 | Wilson | Texas | 48493 | 4666 | 69 |
1455820 | 1455820 | 2021-06-25 | James City | Virginia | 51095 | 4666 | 72 |
1449329 | 1449329 | 2021-06-23 | James City | Virginia | 51095 | 4666 | 72 |
1442839 | 1442839 | 2021-06-21 | James City | Virginia | 51095 | 4666 | 72 |
1439590 | 1439590 | 2021-06-20 | Henry | Virginia | 51089 | 4666 | 124 |
1433096 | 1433096 | 2021-06-18 | Henry | Virginia | 51089 | 4666 | 124 |
1429850 | 1429850 | 2021-06-17 | Henry | Virginia | 51089 | 4666 | 124 |
1423359 | 1423359 | 2021-06-15 | Henry | Virginia | 51089 | 4666 | 124 |
1415631 | 1415631 | 2021-06-13 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1412385 | 1412385 | 2021-06-12 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1409140 | 1409140 | 2021-06-11 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1405895 | 1405895 | 2021-06-10 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1401726 | 1401726 | 2021-06-09 | Des Moines | Iowa | 19057 | 4666 | 69 |
1402649 | 1402649 | 2021-06-09 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1399404 | 1399404 | 2021-06-08 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1396158 | 1396158 | 2021-06-07 | Scotts Bluff | Nebraska | 31157 | 4666 | 96 |
1358366 | 1358366 | 2021-05-26 | Wasatch | Utah | 49051 | 4666 | 22 |
1329433 | 1329433 | 2021-05-17 | Monroe | Wisconsin | 55081 | 4666 | 38 |
1326187 | 1326187 | 2021-05-16 | Monroe | Wisconsin | 55081 | 4666 | 38 |
1322941 | 1322941 | 2021-05-15 | Monroe | Wisconsin | 55081 | 4666 | 38 |
1290744 | 1290744 | 2021-05-06 | Nevada | California | 6057 | 4666 | 75 |
1270927 | 1270927 | 2021-04-29 | Mercer | West Virginia | 54055 | 4666 | 116 |
1266410 | 1266410 | 2021-04-28 | Clinton | New York | 36019 | 4666 | 33 |
1236925 | 1236925 | 2021-04-19 | Scott | Missouri | 29201 | 4666 | 83 |
1233678 | 1233678 | 2021-04-18 | Scott | Missouri | 29201 | 4666 | 83 |
1230430 | 1230430 | 2021-04-17 | Scott | Missouri | 29201 | 4666 | 83 |
1201720 | 1201720 | 2021-04-08 | Mercer | Ohio | 39107 | 4666 | 84 |
1176348 | 1176348 | 2021-03-31 | Harrison | Texas | 48203 | 4666 | 104 |
1173101 | 1173101 | 2021-03-30 | Harrison | Texas | 48203 | 4666 | 104 |
1169854 | 1169854 | 2021-03-29 | Harrison | Texas | 48203 | 4666 | 104 |
1166606 | 1166606 | 2021-03-28 | Harrison | Texas | 48203 | 4666 | 104 |
1130029 | 1130029 | 2021-03-17 | Herkimer | New York | 36043 | 4666 | 107 |
1117483 | 1117483 | 2021-03-13 | Mifflin | Pennsylvania | 42087 | 4666 | 172 |
1106177 | 1106177 | 2021-03-10 | Jackson | Indiana | 18071 | 4666 | 68 |
1102931 | 1102931 | 2021-03-09 | Jackson | Indiana | 18071 | 4666 | 68 |
1093463 | 1093463 | 2021-03-06 | Boyd | Kentucky | 21019 | 4666 | 46 |
1044953 | 1044953 | 2021-02-19 | Androscoggin | Maine | 23001 | 4666 | 54 |
1036162 | 1036162 | 2021-02-16 | Sandusky | Ohio | 39143 | 4666 | 90 |
974500 | 974500 | 2021-01-28 | Union | Ohio | 39159 | 4666 | 31 |
919657 | 919657 | 2021-01-11 | Brown | South Dakota | 46013 | 4666 | 68 |
912046 | 912046 | 2021-01-09 | Crow Wing | Minnesota | 27035 | 4666 | 71 |
901372 | 901372 | 2021-01-06 | Bulloch | Georgia | 13031 | 4666 | 60 |
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);