ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4301 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 12
- Texas 9
- Iowa 8
- Virginia 8
- Michigan 7
- Arkansas 6
- Ohio 6
- Georgia 5
- Kentucky 5
- North Carolina 5
- Indiana 4
- Kansas 4
- Louisiana 4
- Pennsylvania 4
- Tennessee 4
- Wisconsin 4
- Minnesota 3
- New York 3
- Alabama 2
- California 2
- Florida 2
- Mississippi 2
- Nebraska 2
- Vermont 2
- West Virginia 2
- Idaho 1
- Missouri 1
- Oregon 1
- Puerto Rico 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500184 | 2500184 | 2022-05-13 | Carroll | Illinois | 17015 | 4301 | 49 |
2496199 | 2496199 | 2022-05-11 | Morgan | West Virginia | 54065 | 4301 | 69 |
2338804 | 2338804 | 2022-03-24 | Warren | North Carolina | 37185 | 4301 | 39 |
2308128 | 2308128 | 2022-03-15 | Bond | Illinois | 17005 | 4301 | 36 |
2304877 | 2304877 | 2022-03-14 | Bond | Illinois | 17005 | 4301 | 36 |
2301625 | 2301625 | 2022-03-13 | Bond | Illinois | 17005 | 4301 | 35 |
2298373 | 2298373 | 2022-03-12 | Bond | Illinois | 17005 | 4301 | 35 |
2295121 | 2295121 | 2022-03-11 | Bond | Illinois | 17005 | 4301 | 35 |
2217116 | 2217116 | 2022-02-15 | Hancock | Illinois | 17067 | 4301 | 53 |
2217550 | 2217550 | 2022-02-15 | Lewis | Kentucky | 21135 | 4301 | 76 |
2213875 | 2213875 | 2022-02-14 | Johnson | Illinois | 17087 | 4301 | 44 |
2196657 | 2196657 | 2022-02-08 | Buchanan | Virginia | 51027 | 4301 | 91 |
2191536 | 2191536 | 2022-02-07 | Mason | Kentucky | 21161 | 4301 | 93 |
2166799 | 2166799 | 2022-01-30 | Guayama | Puerto Rico | 72057 | 4301 | |
2138447 | 2138447 | 2022-01-22 | Marengo | Alabama | 1091 | 4301 | 93 |
2132658 | 2132658 | 2022-01-20 | Orange | Indiana | 18117 | 4301 | 87 |
2126064 | 2126064 | 2022-01-18 | Pike | Illinois | 17149 | 4301 | 64 |
2110476 | 2110476 | 2022-01-13 | Dodge | Minnesota | 27039 | 4301 | 14 |
2100435 | 2100435 | 2022-01-10 | Johnson | Kentucky | 21115 | 4301 | 82 |
2100862 | 2100862 | 2022-01-10 | Tishomingo | Mississippi | 28141 | 4301 | 99 |
2074675 | 2074675 | 2022-01-02 | Otsego | Michigan | 26137 | 4301 | 81 |
2071424 | 2071424 | 2022-01-01 | Otsego | Michigan | 26137 | 4301 | 81 |
2068173 | 2068173 | 2021-12-31 | Otsego | Michigan | 26137 | 4301 | 81 |
2064922 | 2064922 | 2021-12-30 | Otsego | Michigan | 26137 | 4301 | 81 |
2061672 | 2061672 | 2021-12-29 | Otsego | Michigan | 26137 | 4301 | 81 |
2062460 | 2062460 | 2021-12-29 | Holmes | Ohio | 39075 | 4301 | 152 |
2063485 | 2063485 | 2021-12-29 | Mason | West Virginia | 54053 | 4301 | 66 |
2057916 | 2057916 | 2021-12-28 | Bremer | Iowa | 19017 | 4301 | 74 |
2054667 | 2054667 | 2021-12-27 | Bremer | Iowa | 19017 | 4301 | 74 |
2051417 | 2051417 | 2021-12-26 | Bremer | Iowa | 19017 | 4301 | 74 |
2048167 | 2048167 | 2021-12-25 | Bremer | Iowa | 19017 | 4301 | 74 |
2044917 | 2044917 | 2021-12-24 | Bremer | Iowa | 19017 | 4301 | 74 |
2041668 | 2041668 | 2021-12-23 | Bremer | Iowa | 19017 | 4301 | 74 |
2038418 | 2038418 | 2021-12-22 | Bremer | Iowa | 19017 | 4301 | 74 |
2014218 | 2014218 | 2021-12-14 | Smith | Tennessee | 47159 | 4301 | 55 |
2009425 | 2009425 | 2021-12-13 | Letcher | Kentucky | 21133 | 4301 | 80 |
2009433 | 2009433 | 2021-12-13 | Marion | Kentucky | 21155 | 4301 | 58 |
1983917 | 1983917 | 2021-12-05 | Miller | Missouri | 29131 | 4301 | 100 |
1969025 | 1969025 | 2021-11-30 | Washington | Vermont | 50023 | 4301 | 28 |
1954957 | 1954957 | 2021-11-26 | Delaware | New York | 36025 | 4301 | 51 |
1920785 | 1920785 | 2021-11-16 | Calaveras | California | 6009 | 4301 | 83 |
1897849 | 1897849 | 2021-11-09 | Bibb | Alabama | 1007 | 4301 | 92 |
1898430 | 1898430 | 2021-11-09 | Jerome | Idaho | 16053 | 4301 | 52 |
1887173 | 1887173 | 2021-11-05 | Warren | Pennsylvania | 42123 | 4301 | 135 |
1871968 | 1871968 | 2021-11-01 | Carroll | Arkansas | 5015 | 4301 | 75 |
1868719 | 1868719 | 2021-10-31 | Carroll | Arkansas | 5015 | 4301 | 74 |
1869764 | 1869764 | 2021-10-31 | Richland | Louisiana | 22083 | 4301 | 79 |
1866515 | 1866515 | 2021-10-30 | Richland | Louisiana | 22083 | 4301 | 79 |
1863266 | 1863266 | 2021-10-29 | Richland | Louisiana | 22083 | 4301 | 79 |
1857036 | 1857036 | 2021-10-27 | Covington | Mississippi | 28031 | 4301 | 94 |
1814321 | 1814321 | 2021-10-14 | McPherson | Kansas | 20113 | 4301 | 93 |
1811072 | 1811072 | 2021-10-13 | McPherson | Kansas | 20113 | 4301 | 93 |
1783172 | 1783172 | 2021-10-04 | Jefferson | Pennsylvania | 42065 | 4301 | 107 |
1766946 | 1766946 | 2021-09-29 | Snyder | Pennsylvania | 42109 | 4301 | 92 |
1742337 | 1742337 | 2021-09-22 | Gilmer | Georgia | 13123 | 4301 | 110 |
1741715 | 1741715 | 2021-09-21 | Kittitas | Washington | 53037 | 4301 | 44 |
1729034 | 1729034 | 2021-09-18 | Johnson | Arkansas | 5071 | 4301 | 55 |
1700137 | 1700137 | 2021-09-09 | Lumpkin | Georgia | 13187 | 4301 | 86 |
1656756 | 1656756 | 2021-08-26 | Macon | Tennessee | 47111 | 4301 | 79 |
1628375 | 1628375 | 2021-08-18 | Amador | California | 6005 | 4301 | 50 |
1602700 | 1602700 | 2021-08-10 | Oconee | Georgia | 13219 | 4301 | 74 |
1574834 | 1574834 | 2021-08-01 | Montgomery | New York | 36057 | 4301 | 128 |
1560149 | 1560149 | 2021-07-28 | Union | Arkansas | 5139 | 4301 | 117 |
1539934 | 1539934 | 2021-07-21 | Erath | Texas | 48143 | 4301 | 70 |
1536852 | 1536852 | 2021-07-20 | Waller | Texas | 48473 | 4301 | 52 |
1533604 | 1533604 | 2021-07-19 | Waller | Texas | 48473 | 4301 | 52 |
1530357 | 1530357 | 2021-07-18 | Waller | Texas | 48473 | 4301 | 52 |
1452246 | 1452246 | 2021-06-24 | Cherokee | Texas | 48073 | 4301 | 145 |
1424993 | 1424993 | 2021-06-16 | McLeod | Minnesota | 27085 | 4301 | 61 |
1382380 | 1382380 | 2021-06-03 | Lyon | Kansas | 20111 | 4301 | 86 |
1379135 | 1379135 | 2021-06-02 | Lyon | Kansas | 20111 | 4301 | 86 |
1357548 | 1357548 | 2021-05-26 | Fulton | Ohio | 39051 | 4301 | 71 |
1350698 | 1350698 | 2021-05-24 | Madison | Nebraska | 31119 | 4301 | 44 |
1335481 | 1335481 | 2021-05-19 | Jim Wells | Texas | 48249 | 4301 | 102 |
1332488 | 1332488 | 2021-05-18 | Manassas city | Virginia | 51683 | 4301 | 47 |
1328368 | 1328368 | 2021-05-17 | Putnam | Ohio | 39137 | 4301 | 101 |
1329241 | 1329241 | 2021-05-17 | Manassas city | Virginia | 51683 | 4301 | 47 |
1325995 | 1325995 | 2021-05-16 | Manassas city | Virginia | 51683 | 4301 | 47 |
1322749 | 1322749 | 2021-05-15 | Manassas city | Virginia | 51683 | 4301 | 47 |
1314525 | 1314525 | 2021-05-13 | Hillsdale | Michigan | 26059 | 4301 | 90 |
1284193 | 1284193 | 2021-05-04 | Miller | Arkansas | 5091 | 4301 | 38 |
1280545 | 1280545 | 2021-05-02 | Manassas city | Virginia | 51683 | 4301 | 47 |
1274631 | 1274631 | 2021-05-01 | DeSoto | Florida | 12027 | 4301 | 93 |
1266664 | 1266664 | 2021-04-28 | Madison | Ohio | 39097 | 4301 | 60 |
1252301 | 1252301 | 2021-04-24 | Harrison | Indiana | 18061 | 4301 | 74 |
1219760 | 1219760 | 2021-04-14 | Monroe | Illinois | 17133 | 4301 | 90 |
1215073 | 1215073 | 2021-04-12 | Codington | South Dakota | 46029 | 4301 | 80 |
1206729 | 1206729 | 2021-04-10 | Franklin | Illinois | 17055 | 4301 | 82 |
1188610 | 1188610 | 2021-04-04 | Watauga | North Carolina | 37189 | 4301 | 30 |
1185363 | 1185363 | 2021-04-03 | Watauga | North Carolina | 37189 | 4301 | 30 |
1181368 | 1181368 | 2021-04-02 | Barry | Michigan | 26015 | 4301 | 52 |
1182116 | 1182116 | 2021-04-02 | Watauga | North Carolina | 37189 | 4301 | 30 |
1178869 | 1178869 | 2021-04-01 | Watauga | North Carolina | 37189 | 4301 | 30 |
1175036 | 1175036 | 2021-03-31 | Winona | Minnesota | 27169 | 4301 | 49 |
1106262 | 1106262 | 2021-03-10 | Des Moines | Iowa | 19057 | 4301 | 61 |
1092847 | 1092847 | 2021-03-06 | Baldwin | Georgia | 13009 | 4301 | 117 |
1092893 | 1092893 | 2021-03-06 | Effingham | Georgia | 13103 | 4301 | 63 |
1092256 | 1092256 | 2021-03-05 | Washington | Virginia | 51191 | 4301 | 99 |
1075709 | 1075709 | 2021-02-28 | Hill | Texas | 48217 | 4301 | 94 |
1072463 | 1072463 | 2021-02-27 | Hill | Texas | 48217 | 4301 | 91 |
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);