ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 6903 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Kentucky 8
- Ohio 8
- Mississippi 6
- Tennessee 6
- Texas 6
- Indiana 5
- North Carolina 5
- Wisconsin 4
- Arizona 3
- Illinois 3
- Nebraska 3
- Pennsylvania 3
- Puerto Rico 3
- Virginia 3
- West Virginia 3
- Florida 2
- Georgia 2
- Kansas 2
- New Jersey 2
- Alabama 1
- California 1
- Delaware 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- New Hampshire 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461611 | 2461611 | 2022-05-01 | Woodford | Kentucky | 21239 | 6903 | 48 |
2458355 | 2458355 | 2022-04-30 | Woodford | Kentucky | 21239 | 6903 | 48 |
2455099 | 2455099 | 2022-04-29 | Woodford | Kentucky | 21239 | 6903 | 48 |
2451843 | 2451843 | 2022-04-28 | Woodford | Kentucky | 21239 | 6903 | 48 |
2448587 | 2448587 | 2022-04-27 | Woodford | Kentucky | 21239 | 6903 | 48 |
2445331 | 2445331 | 2022-04-26 | Woodford | Kentucky | 21239 | 6903 | 48 |
2442075 | 2442075 | 2022-04-25 | Woodford | Kentucky | 21239 | 6903 | 48 |
2318976 | 2318976 | 2022-03-18 | Dakota | Nebraska | 31043 | 6903 | 82 |
2315723 | 2315723 | 2022-03-17 | Dakota | Nebraska | 31043 | 6903 | 82 |
2292191 | 2292191 | 2022-03-10 | Franklin | Kansas | 20059 | 6903 | 77 |
2288939 | 2288939 | 2022-03-09 | Franklin | Kansas | 20059 | 6903 | 77 |
2291169 | 2291169 | 2022-03-09 | Wyoming | West Virginia | 54109 | 6903 | 100 |
2270563 | 2270563 | 2022-03-03 | Adams | Ohio | 39001 | 6903 | 138 |
2258663 | 2258663 | 2022-02-27 | Door | Wisconsin | 55029 | 6903 | 58 |
2255412 | 2255412 | 2022-02-26 | Door | Wisconsin | 55029 | 6903 | 58 |
2252161 | 2252161 | 2022-02-25 | Door | Wisconsin | 55029 | 6903 | 58 |
2241574 | 2241574 | 2022-02-22 | Aguadilla | Puerto Rico | 72005 | 6903 | |
2188688 | 2188688 | 2022-02-06 | Tate | Mississippi | 28137 | 6903 | 131 |
2185435 | 2185435 | 2022-02-05 | Tate | Mississippi | 28137 | 6903 | 131 |
2186047 | 2186047 | 2022-02-05 | Hardin | Ohio | 39065 | 6903 | 138 |
2182183 | 2182183 | 2022-02-04 | Tate | Mississippi | 28137 | 6903 | 131 |
2113580 | 2113580 | 2022-01-14 | Somerset | Maine | 23025 | 6903 | 77 |
2107604 | 2107604 | 2022-01-12 | Lincoln | Nebraska | 31111 | 6903 | 87 |
2099263 | 2099263 | 2022-01-09 | Preston | West Virginia | 54077 | 6903 | 112 |
2076413 | 2076413 | 2022-01-02 | Tazewell | Virginia | 51185 | 6903 | 121 |
2073162 | 2073162 | 2022-01-01 | Tazewell | Virginia | 51185 | 6903 | 121 |
2069911 | 2069911 | 2021-12-31 | Tazewell | Virginia | 51185 | 6903 | 121 |
2011020 | 2011020 | 2021-12-13 | Cherokee | Texas | 48073 | 6903 | 228 |
1996134 | 1996134 | 2021-12-09 | Steuben | Indiana | 18151 | 6903 | 92 |
1948960 | 1948960 | 2021-11-24 | Guaynabo | Puerto Rico | 72061 | 6903 | |
1928566 | 1928566 | 2021-11-18 | Pontotoc | Mississippi | 28115 | 6903 | 109 |
1891214 | 1891214 | 2021-11-06 | Jefferson | West Virginia | 54037 | 6903 | 88 |
1876264 | 1876264 | 2021-11-02 | St. Bernard | Louisiana | 22087 | 6903 | 98 |
1837146 | 1837146 | 2021-10-21 | Franklin | Kentucky | 21073 | 6903 | 76 |
1778274 | 1778274 | 2021-10-03 | Knox | Illinois | 17095 | 6903 | 198 |
1775024 | 1775024 | 2021-10-02 | Knox | Illinois | 17095 | 6903 | 198 |
1771774 | 1771774 | 2021-10-01 | Knox | Illinois | 17095 | 6903 | 198 |
1718159 | 1718159 | 2021-09-14 | Armstrong | Pennsylvania | 42005 | 6903 | 155 |
1690129 | 1690129 | 2021-09-06 | San Benito | California | 6069 | 6903 | 64 |
1682878 | 1682878 | 2021-09-03 | Hale | Texas | 48189 | 6903 | 167 |
1679628 | 1679628 | 2021-09-02 | Hale | Texas | 48189 | 6903 | 167 |
1675957 | 1675957 | 2021-09-01 | Indiana | Pennsylvania | 42063 | 6903 | 183 |
1676380 | 1676380 | 2021-09-01 | Hale | Texas | 48189 | 6903 | 166 |
1673133 | 1673133 | 2021-08-31 | Hale | Texas | 48189 | 6903 | 165 |
1669234 | 1669234 | 2021-08-30 | Belmont | Ohio | 39013 | 6903 | 181 |
1642392 | 1642392 | 2021-08-22 | Cecil | Maryland | 24015 | 6903 | 161 |
1574889 | 1574889 | 2021-08-01 | Columbus | North Carolina | 37047 | 6903 | 157 |
1571641 | 1571641 | 2021-07-31 | Columbus | North Carolina | 37047 | 6903 | 157 |
1568393 | 1568393 | 2021-07-30 | Columbus | North Carolina | 37047 | 6903 | 157 |
1550986 | 1550986 | 2021-07-25 | Morgan | Indiana | 18109 | 6903 | 147 |
1547739 | 1547739 | 2021-07-24 | Morgan | Indiana | 18109 | 6903 | 147 |
1544492 | 1544492 | 2021-07-23 | Morgan | Indiana | 18109 | 6903 | 147 |
1529585 | 1529585 | 2021-07-18 | Geauga | Ohio | 39055 | 6903 | 153 |
1374240 | 1374240 | 2021-05-31 | Dickson | Tennessee | 47043 | 6903 | 114 |
1370995 | 1370995 | 2021-05-30 | Dickson | Tennessee | 47043 | 6903 | 114 |
1367749 | 1367749 | 2021-05-29 | Dickson | Tennessee | 47043 | 6903 | 114 |
1364503 | 1364503 | 2021-05-28 | Dickson | Tennessee | 47043 | 6903 | 114 |
1360839 | 1360839 | 2021-05-27 | Ross | Ohio | 39141 | 6903 | 158 |
1357593 | 1357593 | 2021-05-26 | Ross | Ohio | 39141 | 6903 | 158 |
1354347 | 1354347 | 2021-05-25 | Ross | Ohio | 39141 | 6903 | 158 |
1326339 | 1326339 | 2021-05-17 | Gila | Arizona | 4007 | 6903 | 228 |
1319847 | 1319847 | 2021-05-15 | Gila | Arizona | 4007 | 6903 | 228 |
1293071 | 1293071 | 2021-05-06 | Coffee | Tennessee | 47031 | 6903 | 121 |
1280889 | 1280889 | 2021-05-03 | Gila | Arizona | 4007 | 6903 | 227 |
1257157 | 1257157 | 2021-04-25 | Caguas | Puerto Rico | 72025 | 6903 | |
1145662 | 1145662 | 2021-03-22 | Eaton | Michigan | 26045 | 6903 | 160 |
1106890 | 1106890 | 2021-03-10 | Lauderdale | Mississippi | 28075 | 6903 | 229 |
1102704 | 1102704 | 2021-03-09 | Rockdale | Georgia | 13247 | 6903 | 153 |
1097682 | 1097682 | 2021-03-07 | Rockingham | North Carolina | 37157 | 6903 | 61 |
1094434 | 1094434 | 2021-03-06 | Rockingham | North Carolina | 37157 | 6903 | 61 |
1077564 | 1077564 | 2021-03-01 | Clay | Minnesota | 27027 | 6903 | 87 |
1061786 | 1061786 | 2021-02-24 | Strafford | New Hampshire | 33017 | 6903 | 72 |
891560 | 891560 | 2021-01-03 | Citrus | Florida | 12017 | 6903 | 283 |
885482 | 885482 | 2021-01-01 | Kosciusko | Indiana | 18085 | 6903 | 73 |
884105 | 884105 | 2020-12-31 | Unknown | Tennessee | 6903 | 59 | |
842963 | 842963 | 2020-12-19 | Carroll | Georgia | 13045 | 6903 | 110 |
820147 | 820147 | 2020-12-12 | Kent | Delaware | 10001 | 6903 | 142 |
748810 | 748810 | 2020-11-20 | Santa Rosa | Florida | 12113 | 6903 | 97 |
722444 | 722444 | 2020-11-11 | Washington | Wisconsin | 55131 | 6903 | 56 |
715376 | 715376 | 2020-11-09 | Bell | Texas | 48027 | 6903 | 104 |
709539 | 709539 | 2020-11-08 | Lee | Alabama | 1081 | 6903 | 65 |
559344 | 559344 | 2020-09-22 | Berks | Pennsylvania | 42011 | 6903 | 391 |
542331 | 542331 | 2020-09-17 | Hinds | Mississippi | 28049 | 6903 | 153 |
533287 | 533287 | 2020-09-14 | Lucas | Ohio | 39095 | 6903 | 350 |
313583 | 313583 | 2020-07-08 | Hampden | Massachusetts | 25013 | 6903 | 672 |
291973 | 291973 | 2020-07-01 | Morris | New Jersey | 34027 | 6903 | 799 |
226311 | 226311 | 2020-06-10 | Camden | New Jersey | 34007 | 6903 | 394 |
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);