ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 4420 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Indiana 14
- Illinois 8
- Mississippi 8
- Georgia 7
- New York 6
- Ohio 6
- South Carolina 6
- Texas 6
- Puerto Rico 5
- Florida 4
- Kentucky 4
- Alabama 3
- Michigan 3
- Virginia 3
- Missouri 2
- North Carolina 2
- South Dakota 2
- Vermont 2
- Wisconsin 2
- Arkansas 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- New Hampshire 1
- New Mexico 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500210 | 2500210 | 2022-05-13 | Hancock | Illinois | 17067 | 4420 | 58 |
2502500 | 2502500 | 2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 |
2263289 | 2263289 | 2022-03-01 | Manistee | Michigan | 26101 | 4420 | 84 |
2260038 | 2260038 | 2022-02-28 | Manistee | Michigan | 26101 | 4420 | 84 |
2251677 | 2251677 | 2022-02-25 | Deaf Smith | Texas | 48117 | 4420 | 109 |
2222645 | 2222645 | 2022-02-16 | Caledonia | Vermont | 50005 | 4420 | 23 |
2218866 | 2218866 | 2022-02-15 | Morovis | Puerto Rico | 72101 | 4420 | |
2215615 | 2215615 | 2022-02-14 | Morovis | Puerto Rico | 72101 | 4420 | |
2212364 | 2212364 | 2022-02-13 | Morovis | Puerto Rico | 72101 | 4420 | |
2212732 | 2212732 | 2022-02-13 | Jones | Texas | 48253 | 4420 | 87 |
2205833 | 2205833 | 2022-02-11 | Fajardo | Puerto Rico | 72053 | 4420 | |
2156933 | 2156933 | 2022-01-27 | Wasco | Oregon | 41065 | 4420 | 50 |
2119008 | 2119008 | 2022-01-16 | Columbia | Arkansas | 5027 | 4420 | 77 |
2107315 | 2107315 | 2022-01-12 | Grenada | Mississippi | 28043 | 4420 | 112 |
2080971 | 2080971 | 2022-01-04 | Russell | Kentucky | 21207 | 4420 | 66 |
2074050 | 2074050 | 2022-01-02 | Shelby | Illinois | 17173 | 4420 | 59 |
2070799 | 2070799 | 2022-01-01 | Shelby | Illinois | 17173 | 4420 | 59 |
2067548 | 2067548 | 2021-12-31 | Shelby | Illinois | 17173 | 4420 | 59 |
2064297 | 2064297 | 2021-12-30 | Shelby | Illinois | 17173 | 4420 | 59 |
2050615 | 2050615 | 2021-12-26 | Bibb | Alabama | 1007 | 4420 | 95 |
2040093 | 2040093 | 2021-12-22 | Davison | South Dakota | 46035 | 4420 | 72 |
2026711 | 2026711 | 2021-12-18 | Hocking | Ohio | 39073 | 4420 | 94 |
1964064 | 1964064 | 2021-11-29 | Dorchester | Maryland | 24019 | 4420 | 87 |
1884099 | 1884099 | 2021-11-04 | Lawrence | South Dakota | 46081 | 4420 | 64 |
1847723 | 1847723 | 2021-10-24 | Greene | New York | 36039 | 4420 | 87 |
1825572 | 1825572 | 2021-10-17 | Union | South Carolina | 45087 | 4420 | 100 |
1822323 | 1822323 | 2021-10-16 | Union | South Carolina | 45087 | 4420 | 100 |
1819074 | 1819074 | 2021-10-15 | Union | South Carolina | 45087 | 4420 | 100 |
1816023 | 1816023 | 2021-10-14 | Cass | Texas | 48067 | 4420 | 138 |
1768327 | 1768327 | 2021-09-30 | Gilmer | Georgia | 13123 | 4420 | 121 |
1759613 | 1759613 | 2021-09-27 | Tate | Mississippi | 28137 | 4420 | 103 |
1755290 | 1755290 | 2021-09-26 | Butts | Georgia | 13035 | 4420 | 96 |
1752042 | 1752042 | 2021-09-25 | Butts | Georgia | 13035 | 4420 | 96 |
1748793 | 1748793 | 2021-09-24 | Butts | Georgia | 13035 | 4420 | 96 |
1731226 | 1731226 | 2021-09-18 | Arecibo | Puerto Rico | 72013 | 4420 | |
1719845 | 1719845 | 2021-09-15 | Adams | Indiana | 18001 | 4420 | 66 |
1711007 | 1711007 | 2021-09-12 | Warren | Missouri | 29219 | 4420 | 39 |
1689709 | 1689709 | 2021-09-05 | Tazewell | Virginia | 51185 | 4420 | 80 |
1686459 | 1686459 | 2021-09-04 | Tazewell | Virginia | 51185 | 4420 | 80 |
1683208 | 1683208 | 2021-09-03 | Tazewell | Virginia | 51185 | 4420 | 80 |
1679038 | 1679038 | 2021-09-02 | Preble | Ohio | 39135 | 4420 | 109 |
1672511 | 1672511 | 2021-08-31 | Highland | Ohio | 39071 | 4420 | 70 |
1653255 | 1653255 | 2021-08-25 | Wayne | Pennsylvania | 42127 | 4420 | 84 |
1626719 | 1626719 | 2021-08-17 | Belknap | New Hampshire | 33001 | 4420 | 101 |
1585842 | 1585842 | 2021-08-04 | Ohio | West Virginia | 54069 | 4420 | 87 |
1556784 | 1556784 | 2021-07-27 | Tallapoosa | Alabama | 1123 | 4420 | 157 |
1547011 | 1547011 | 2021-07-24 | Franklin | Alabama | 1059 | 4420 | 81 |
1509369 | 1509369 | 2021-07-12 | Isanti | Minnesota | 27059 | 4420 | 65 |
1469776 | 1469776 | 2021-06-30 | DeKalb | Indiana | 18033 | 4420 | 88 |
1466547 | 1466547 | 2021-06-29 | Harrison | Indiana | 18061 | 4420 | 77 |
1466570 | 1466570 | 2021-06-29 | Montgomery | Indiana | 18107 | 4420 | 92 |
1463302 | 1463302 | 2021-06-28 | Harrison | Indiana | 18061 | 4420 | 77 |
1460057 | 1460057 | 2021-06-27 | Harrison | Indiana | 18061 | 4420 | 77 |
1456812 | 1456812 | 2021-06-26 | Harrison | Indiana | 18061 | 4420 | 77 |
1453567 | 1453567 | 2021-06-25 | Harrison | Indiana | 18061 | 4420 | 77 |
1450321 | 1450321 | 2021-06-24 | Harrison | Indiana | 18061 | 4420 | 77 |
1447076 | 1447076 | 2021-06-23 | Harrison | Indiana | 18061 | 4420 | 77 |
1443831 | 1443831 | 2021-06-22 | Harrison | Indiana | 18061 | 4420 | 77 |
1440586 | 1440586 | 2021-06-21 | Harrison | Indiana | 18061 | 4420 | 77 |
1422805 | 1422805 | 2021-06-15 | Dillon | South Carolina | 45033 | 4420 | 85 |
1419559 | 1419559 | 2021-06-14 | Dillon | South Carolina | 45033 | 4420 | 85 |
1412499 | 1412499 | 2021-06-12 | Fulton | New York | 36035 | 4420 | 91 |
1409254 | 1409254 | 2021-06-11 | Fulton | New York | 36035 | 4420 | 91 |
1406009 | 1406009 | 2021-06-10 | Fulton | New York | 36035 | 4420 | 91 |
1379364 | 1379364 | 2021-06-02 | Washington | Louisiana | 22117 | 4420 | 133 |
1373800 | 1373800 | 2021-05-31 | Madison | Ohio | 39097 | 4420 | 63 |
1369936 | 1369936 | 2021-05-30 | Warren | Mississippi | 28149 | 4420 | 122 |
1370555 | 1370555 | 2021-05-30 | Madison | Ohio | 39097 | 4420 | 63 |
1366690 | 1366690 | 2021-05-29 | Warren | Mississippi | 28149 | 4420 | 122 |
1363444 | 1363444 | 2021-05-28 | Warren | Mississippi | 28149 | 4420 | 122 |
1359438 | 1359438 | 2021-05-27 | Gibson | Indiana | 18051 | 4420 | 95 |
1291157 | 1291157 | 2021-05-06 | Franklin | Illinois | 17055 | 4420 | 85 |
1228386 | 1228386 | 2021-04-16 | Nacogdoches | Texas | 48347 | 4420 | 166 |
1214068 | 1214068 | 2021-04-12 | Pearl River | Mississippi | 28109 | 4420 | 139 |
1203911 | 1203911 | 2021-04-09 | Jessamine | Kentucky | 21113 | 4420 | 60 |
1180558 | 1180558 | 2021-04-02 | Effingham | Georgia | 13103 | 4420 | 65 |
1181586 | 1181586 | 2021-04-02 | Panola | Mississippi | 28107 | 4420 | 103 |
1177523 | 1177523 | 2021-04-01 | Livingston | Illinois | 17105 | 4420 | 92 |
1180038 | 1180038 | 2021-04-01 | Douglas | Wisconsin | 55031 | 4420 | 47 |
1152801 | 1152801 | 2021-03-24 | Beaufort | North Carolina | 37013 | 4420 | 87 |
1109791 | 1109791 | 2021-03-11 | Shelby | Kentucky | 21211 | 4420 | 52 |
1088410 | 1088410 | 2021-03-04 | Newberry | South Carolina | 45071 | 4420 | 92 |
1081333 | 1081333 | 2021-03-02 | Genesee | New York | 36037 | 4420 | 118 |
1078073 | 1078073 | 2021-03-01 | Cattaraugus | New York | 36009 | 4420 | 76 |
1041016 | 1041016 | 2021-02-18 | Murray | Georgia | 13213 | 4420 | 66 |
1009078 | 1009078 | 2021-02-08 | Boyd | Kentucky | 21019 | 4420 | 40 |
992576 | 992576 | 2021-02-03 | Jackson | Indiana | 18071 | 4420 | 49 |
994573 | 994573 | 2021-02-03 | Howard | Texas | 48227 | 4420 | 89 |
986950 | 986950 | 2021-02-01 | Taney | Missouri | 29213 | 4420 | 68 |
929515 | 929515 | 2021-01-14 | Monroe | Tennessee | 47123 | 4420 | 62 |
924980 | 924980 | 2021-01-13 | Midland | Michigan | 26111 | 4420 | 51 |
909611 | 909611 | 2021-01-08 | Bryan | Oklahoma | 40013 | 4420 | 39 |
878861 | 878861 | 2020-12-30 | Clinton | Illinois | 17027 | 4420 | 80 |
842940 | 842940 | 2020-12-19 | Walton | Florida | 12131 | 4420 | 42 |
833164 | 833164 | 2020-12-16 | Highlands | Florida | 12055 | 4420 | 186 |
764576 | 764576 | 2020-11-24 | Chippewa | Wisconsin | 55017 | 4420 | 49 |
719563 | 719563 | 2020-11-11 | Columbia | Florida | 12023 | 4420 | 80 |
701750 | 701750 | 2020-11-05 | Rowan | North Carolina | 37159 | 4420 | 122 |
623345 | 623345 | 2020-10-12 | Harrison | Mississippi | 28047 | 4420 | 79 |
623737 | 623737 | 2020-10-12 | McKinley | New Mexico | 35031 | 4420 | 260 |
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);