ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where cases = 3704 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Illinois 11
- Kentucky 11
- New York 8
- Virginia 8
- Colorado 6
- Indiana 6
- Ohio 6
- Louisiana 5
- Arkansas 4
- Georgia 4
- Missouri 4
- South Dakota 4
- Virgin Islands 4
- Wisconsin 4
- Alabama 3
- Idaho 3
- Iowa 3
- Kansas 3
- Oregon 3
- Pennsylvania 3
- Puerto Rico 3
- Maine 2
- Minnesota 2
- Mississippi 2
- North Carolina 2
- Tennessee 2
- Michigan 1
- Nebraska 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501485 | 2501485 | 2022-05-13 | Yates | New York | 36123 | 3704 | 40 |
2498227 | 2498227 | 2022-05-12 | Yates | New York | 36123 | 3704 | 40 |
2488439 | 2488439 | 2022-05-09 | Schuyler | New York | 36097 | 3704 | 25 |
2439960 | 2439960 | 2022-04-24 | Tillamook | Oregon | 41057 | 3704 | 64 |
2436704 | 2436704 | 2022-04-23 | Tillamook | Oregon | 41057 | 3704 | 64 |
2433448 | 2433448 | 2022-04-22 | Tillamook | Oregon | 41057 | 3704 | 64 |
2370402 | 2370402 | 2022-04-03 | Leslie | Kentucky | 21131 | 3704 | 42 |
2371729 | 2371729 | 2022-04-03 | Quebradillas | Puerto Rico | 72115 | 3704 | |
2367149 | 2367149 | 2022-04-02 | Leslie | Kentucky | 21131 | 3704 | 42 |
2363896 | 2363896 | 2022-04-01 | Leslie | Kentucky | 21131 | 3704 | 42 |
2360642 | 2360642 | 2022-03-31 | Leslie | Kentucky | 21131 | 3704 | 42 |
2357388 | 2357388 | 2022-03-30 | Leslie | Kentucky | 21131 | 3704 | 42 |
2354135 | 2354135 | 2022-03-29 | Leslie | Kentucky | 21131 | 3704 | 42 |
2350883 | 2350883 | 2022-03-28 | Leslie | Kentucky | 21131 | 3704 | 42 |
2352821 | 2352821 | 2022-03-28 | Manassas Park city | Virginia | 51685 | 3704 | 25 |
2336332 | 2336332 | 2022-03-23 | Madison | Texas | 48313 | 3704 | 53 |
2267918 | 2267918 | 2022-03-02 | Colorado | Texas | 48089 | 3704 | 61 |
2243256 | 2243256 | 2022-02-23 | Pike | Indiana | 18125 | 3704 | 48 |
2245188 | 2245188 | 2022-02-23 | Falls | Texas | 48145 | 3704 | 61 |
2240313 | 2240313 | 2022-02-22 | Magoffin | Kentucky | 21153 | 3704 | 40 |
2210112 | 2210112 | 2022-02-13 | Franklin | Arkansas | 5047 | 3704 | 67 |
2203606 | 2203606 | 2022-02-11 | Franklin | Arkansas | 5047 | 3704 | 66 |
2193666 | 2193666 | 2022-02-07 | Richland | Wisconsin | 55103 | 3704 | 39 |
2177490 | 2177490 | 2022-02-03 | Macon | Alabama | 1087 | 3704 | 71 |
2180223 | 2180223 | 2022-02-03 | Llano | Texas | 48299 | 3704 | 89 |
2174237 | 2174237 | 2022-02-02 | Macon | Alabama | 1087 | 3704 | 71 |
2172136 | 2172136 | 2022-02-01 | Lincoln | Maine | 23015 | 3704 | 20 |
2165331 | 2165331 | 2022-01-30 | Allen | Kansas | 20001 | 3704 | 36 |
2162076 | 2162076 | 2022-01-29 | Allen | Kansas | 20001 | 3704 | 36 |
2163825 | 2163825 | 2022-01-29 | Bosque | Texas | 48035 | 3704 | 61 |
2158821 | 2158821 | 2022-01-28 | Allen | Kansas | 20001 | 3704 | 36 |
2155314 | 2155314 | 2022-01-27 | Jo Daviess | Illinois | 17085 | 3704 | 36 |
2112085 | 2112085 | 2022-01-13 | Colonial Heights city | Virginia | 51570 | 3704 | 72 |
2103730 | 2103730 | 2022-01-11 | Rockcastle | Kentucky | 21203 | 3704 | 48 |
2096430 | 2096430 | 2022-01-09 | Teller | Colorado | 8119 | 3704 | 52 |
2093178 | 2093178 | 2022-01-08 | Teller | Colorado | 8119 | 3704 | 52 |
2089926 | 2089926 | 2022-01-07 | Teller | Colorado | 8119 | 3704 | 52 |
2054297 | 2054297 | 2021-12-27 | Dodge | Georgia | 13091 | 3704 | 135 |
2018727 | 2018727 | 2021-12-16 | Crawford | Illinois | 17033 | 3704 | 47 |
2017905 | 2017905 | 2021-12-15 | Staunton city | Virginia | 51790 | 3704 | 86 |
2011154 | 2011154 | 2021-12-13 | Moore | Texas | 48341 | 3704 | 91 |
2007818 | 2007818 | 2021-12-12 | Gillespie | Texas | 48171 | 3704 | 82 |
2008034 | 2008034 | 2021-12-12 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
2004783 | 2004783 | 2021-12-11 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
2001377 | 2001377 | 2021-12-10 | Limestone | Texas | 48293 | 3704 | 111 |
2001532 | 2001532 | 2021-12-10 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
1996479 | 1996479 | 2021-12-09 | Assumption | Louisiana | 22007 | 3704 | 57 |
1998282 | 1998282 | 2021-12-09 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
1973058 | 1973058 | 2021-12-02 | Grady | Georgia | 13131 | 3704 | 92 |
1963494 | 1963494 | 2021-11-29 | Jersey | Illinois | 17083 | 3704 | 74 |
1943084 | 1943084 | 2021-11-22 | Hopewell city | Virginia | 51670 | 3704 | 88 |
1918031 | 1918031 | 2021-11-15 | Shelby | Illinois | 17173 | 3704 | 54 |
1912369 | 1912369 | 2021-11-13 | Crawford | Missouri | 29055 | 3704 | 61 |
1907399 | 1907399 | 2021-11-11 | Waynesboro city | Virginia | 51820 | 3704 | 49 |
1896695 | 1896695 | 2021-11-08 | Hocking | Ohio | 39073 | 3704 | 87 |
1874591 | 1874591 | 2021-11-01 | Hutchinson | Texas | 48233 | 3704 | 89 |
1874838 | 1874838 | 2021-11-01 | Hopewell city | Virginia | 51670 | 3704 | 88 |
1871342 | 1871342 | 2021-10-31 | Hutchinson | Texas | 48233 | 3704 | 89 |
1868093 | 1868093 | 2021-10-30 | Hutchinson | Texas | 48233 | 3704 | 87 |
1863973 | 1863973 | 2021-10-29 | Lewis | New York | 36049 | 3704 | 39 |
1855579 | 1855579 | 2021-10-26 | Waushara | Wisconsin | 55137 | 3704 | 51 |
1848336 | 1848336 | 2021-10-24 | Davison | South Dakota | 46035 | 3704 | 70 |
1845086 | 1845086 | 2021-10-23 | Davison | South Dakota | 46035 | 3704 | 70 |
1841836 | 1841836 | 2021-10-22 | Davison | South Dakota | 46035 | 3704 | 70 |
1835778 | 1835778 | 2021-10-20 | Rutland | Vermont | 50021 | 3704 | 28 |
1810780 | 1810780 | 2021-10-13 | McDonough | Illinois | 17109 | 3704 | 71 |
1813191 | 1813191 | 2021-10-13 | Island | Washington | 53029 | 3704 | 43 |
1804984 | 1804984 | 2021-10-11 | Le Sueur | Minnesota | 27079 | 3704 | 30 |
1781458 | 1781458 | 2021-10-04 | Jefferson | Idaho | 16051 | 3704 | 37 |
1764066 | 1764066 | 2021-09-28 | Dimmit | Texas | 48127 | 3704 | 42 |
1752218 | 1752218 | 2021-09-25 | Jerome | Idaho | 16053 | 3704 | 37 |
1710989 | 1710989 | 2021-09-12 | Saline | Missouri | 29195 | 3704 | 44 |
1623172 | 1623172 | 2021-08-16 | Sunflower | Mississippi | 28133 | 3704 | 95 |
1607901 | 1607901 | 2021-08-11 | Marlboro | South Carolina | 45069 | 3704 | 61 |
1578528 | 1578528 | 2021-08-02 | Snyder | Pennsylvania | 42109 | 3704 | 86 |
1575280 | 1575280 | 2021-08-01 | Snyder | Pennsylvania | 42109 | 3704 | 86 |
1552963 | 1552963 | 2021-07-25 | Hopkins | Texas | 48223 | 3704 | 114 |
1501130 | 1501130 | 2021-07-09 | Uvalde | Texas | 48463 | 3704 | 73 |
1475464 | 1475464 | 2021-07-01 | Clark | Wisconsin | 55019 | 3704 | 65 |
1472218 | 1472218 | 2021-06-30 | Clark | Wisconsin | 55019 | 3704 | 65 |
1394419 | 1394419 | 2021-06-07 | Chambers | Alabama | 1017 | 3704 | 124 |
1382199 | 1382199 | 2021-06-03 | Putnam | Indiana | 18133 | 3704 | 60 |
1338102 | 1338102 | 2021-05-20 | Ottawa | Ohio | 39123 | 3704 | 81 |
1305371 | 1305371 | 2021-05-10 | Cortland | New York | 36023 | 3704 | 60 |
1283462 | 1283462 | 2021-05-03 | Cooke | Texas | 48097 | 3704 | 72 |
1280215 | 1280215 | 2021-05-02 | Cooke | Texas | 48097 | 3704 | 72 |
1276968 | 1276968 | 2021-05-01 | Cooke | Texas | 48097 | 3704 | 72 |
1265406 | 1265406 | 2021-04-28 | Lee | Iowa | 19111 | 3704 | 55 |
1249099 | 1249099 | 2021-04-23 | Steuben | Indiana | 18151 | 3704 | 59 |
1234213 | 1234213 | 2021-04-18 | Preble | Ohio | 39135 | 3704 | 98 |
1181973 | 1181973 | 2021-04-02 | Columbia | New York | 36021 | 3704 | 98 |
1171956 | 1171956 | 2021-03-30 | Phelps | Missouri | 29161 | 3704 | 127 |
1106107 | 1106107 | 2021-03-10 | Morgan | Illinois | 17137 | 3704 | 99 |
1102861 | 1102861 | 2021-03-09 | Morgan | Illinois | 17137 | 3704 | 99 |
1087815 | 1087815 | 2021-03-04 | Clinton | New York | 36019 | 3704 | 26 |
1076016 | 1076016 | 2021-02-28 | Shenandoah | Virginia | 51171 | 3704 | 119 |
1070897 | 1070897 | 2021-02-27 | St. Bernard | Louisiana | 22087 | 3704 | 46 |
1067652 | 1067652 | 2021-02-26 | St. Bernard | Louisiana | 22087 | 3704 | 46 |
1059305 | 1059305 | 2021-02-23 | Giles | Tennessee | 47055 | 3704 | 95 |
1047294 | 1047294 | 2021-02-20 | Logan | Colorado | 8075 | 3704 | 63 |
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);