ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 9
- Texas 9
- Minnesota 8
- Mississippi 8
- Kansas 7
- Illinois 5
- Indiana 5
- Tennessee 5
- Alaska 4
- Georgia 4
- Kentucky 4
- Virginia 4
- Alabama 3
- Florida 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Wisconsin 3
- Colorado 2
- Michigan 2
- North Carolina 2
- Washington 2
- West Virginia 2
- Arkansas 1
- Iowa 1
- Louisiana 1
- Maryland 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450690 | 2450690 | 2022-04-27 | Washburn | Wisconsin | 55129 | 4021 | 46 |
2339787 | 2339787 | 2022-03-24 | Greene | Virginia | 51079 | 4021 | 61 |
2294243 | 2294243 | 2022-03-10 | Giles | Virginia | 51071 | 4021 | 44 |
2256527 | 2256527 | 2022-02-27 | Estill | Kentucky | 21065 | 4021 | 42 |
2253276 | 2253276 | 2022-02-26 | Estill | Kentucky | 21065 | 4021 | 42 |
2250025 | 2250025 | 2022-02-25 | Estill | Kentucky | 21065 | 4021 | 42 |
2236658 | 2236658 | 2022-02-21 | Moultrie | Illinois | 17139 | 4021 | 51 |
2233407 | 2233407 | 2022-02-20 | Moultrie | Illinois | 17139 | 4021 | 51 |
2230156 | 2230156 | 2022-02-19 | Moultrie | Illinois | 17139 | 4021 | 51 |
2226905 | 2226905 | 2022-02-18 | Moultrie | Illinois | 17139 | 4021 | 51 |
2200231 | 2200231 | 2022-02-10 | Clay | Alabama | 1027 | 4021 | 73 |
2180614 | 2180614 | 2022-02-03 | Crawford | Wisconsin | 55023 | 4021 | 28 |
2157356 | 2157356 | 2022-01-27 | Deaf Smith | Texas | 48117 | 4021 | 104 |
2152458 | 2152458 | 2022-01-26 | Garrard | Kentucky | 21079 | 4021 | 64 |
2099381 | 2099381 | 2022-01-10 | Butler | Alabama | 1013 | 4021 | 102 |
2082116 | 2082116 | 2022-01-04 | Lincoln | Oregon | 41041 | 4021 | 58 |
2036435 | 2036435 | 2021-12-21 | Carroll | Ohio | 39019 | 4021 | 86 |
1961101 | 1961101 | 2021-11-28 | Audrain | Missouri | 29007 | 4021 | 77 |
1957850 | 1957850 | 2021-11-27 | Audrain | Missouri | 29007 | 4021 | 77 |
1954599 | 1954599 | 2021-11-26 | Audrain | Missouri | 29007 | 4021 | 77 |
1951348 | 1951348 | 2021-11-25 | Audrain | Missouri | 29007 | 4021 | 77 |
1948097 | 1948097 | 2021-11-24 | Audrain | Missouri | 29007 | 4021 | 77 |
1929026 | 1929026 | 2021-11-18 | Dare | North Carolina | 37055 | 4021 | 15 |
1925002 | 1925002 | 2021-11-17 | Plaquemines | Louisiana | 22075 | 4021 | 40 |
1876662 | 1876662 | 2021-11-02 | McDonald | Missouri | 29119 | 4021 | 58 |
1873413 | 1873413 | 2021-11-01 | McDonald | Missouri | 29119 | 4021 | 58 |
1790560 | 1790560 | 2021-10-06 | Lincoln | Wisconsin | 55069 | 4021 | 106 |
1778346 | 1778346 | 2021-10-03 | Decatur | Indiana | 18031 | 4021 | 105 |
1779080 | 1779080 | 2021-10-03 | Leake | Mississippi | 28079 | 4021 | 87 |
1775096 | 1775096 | 2021-10-02 | Decatur | Indiana | 18031 | 4021 | 105 |
1775830 | 1775830 | 2021-10-02 | Leake | Mississippi | 28079 | 4021 | 87 |
1771846 | 1771846 | 2021-10-01 | Decatur | Indiana | 18031 | 4021 | 105 |
1772580 | 1772580 | 2021-10-01 | Leake | Mississippi | 28079 | 4021 | 87 |
1768368 | 1768368 | 2021-09-30 | Monroe | Georgia | 13207 | 4021 | 138 |
1711680 | 1711680 | 2021-09-12 | Clinton | Pennsylvania | 42035 | 4021 | 69 |
1696305 | 1696305 | 2021-09-07 | Wayne | West Virginia | 54099 | 4021 | 49 |
1691259 | 1691259 | 2021-09-06 | Freeborn | Minnesota | 27047 | 4021 | 37 |
1688009 | 1688009 | 2021-09-05 | Freeborn | Minnesota | 27047 | 4021 | 37 |
1684759 | 1684759 | 2021-09-04 | Freeborn | Minnesota | 27047 | 4021 | 37 |
1681508 | 1681508 | 2021-09-03 | Freeborn | Minnesota | 27047 | 4021 | 37 |
1655727 | 1655727 | 2021-08-26 | Lafayette | Missouri | 29107 | 4021 | 62 |
1635909 | 1635909 | 2021-08-20 | Worcester | Maryland | 24047 | 4021 | 108 |
1608878 | 1608878 | 2021-08-12 | St. Francis | Arkansas | 5123 | 4021 | 46 |
1603128 | 1603128 | 2021-08-10 | Geary | Kansas | 20061 | 4021 | 47 |
1604059 | 1604059 | 2021-08-10 | Cortland | New York | 36023 | 4021 | 64 |
1599879 | 1599879 | 2021-08-09 | Geary | Kansas | 20061 | 4021 | 47 |
1573032 | 1573032 | 2021-08-01 | Bethel Census Area | Alaska | 2050 | 4021 | 22 |
1569784 | 1569784 | 2021-07-31 | Bethel Census Area | Alaska | 2050 | 4021 | 22 |
1566536 | 1566536 | 2021-07-30 | Bethel Census Area | Alaska | 2050 | 4021 | 22 |
1554458 | 1554458 | 2021-07-26 | Seward | Kansas | 20175 | 4021 | 42 |
1551211 | 1551211 | 2021-07-25 | Seward | Kansas | 20175 | 4021 | 42 |
1547964 | 1547964 | 2021-07-24 | Seward | Kansas | 20175 | 4021 | 42 |
1470514 | 1470514 | 2021-06-30 | Lincoln | Mississippi | 28085 | 4021 | 113 |
1421287 | 1421287 | 2021-06-15 | Cowley | Kansas | 20035 | 4021 | 109 |
1422441 | 1422441 | 2021-06-15 | Brown | Ohio | 39015 | 4021 | 61 |
1418042 | 1418042 | 2021-06-14 | Cowley | Kansas | 20035 | 4021 | 109 |
1384958 | 1384958 | 2021-06-04 | Logan | Colorado | 8075 | 4021 | 68 |
1364778 | 1364778 | 2021-05-28 | Rusk | Texas | 48401 | 4021 | 108 |
1359971 | 1359971 | 2021-05-27 | Delta | Michigan | 26041 | 4021 | 94 |
1353012 | 1353012 | 2021-05-25 | Whitley | Indiana | 18183 | 4021 | 40 |
1348279 | 1348279 | 2021-05-23 | Giles | Tennessee | 47055 | 4021 | 101 |
1343806 | 1343806 | 2021-05-22 | Beltrami | Minnesota | 27007 | 4021 | 59 |
1345031 | 1345031 | 2021-05-22 | Giles | Tennessee | 47055 | 4021 | 101 |
1340557 | 1340557 | 2021-05-21 | Beltrami | Minnesota | 27007 | 4021 | 59 |
1341783 | 1341783 | 2021-05-21 | Giles | Tennessee | 47055 | 4021 | 101 |
1297390 | 1297390 | 2021-05-08 | Okeechobee | Florida | 12093 | 4021 | 89 |
1291027 | 1291027 | 2021-05-06 | Oconee | Georgia | 13219 | 4021 | 72 |
1279007 | 1279007 | 2021-05-02 | Neshoba | Mississippi | 28099 | 4021 | 176 |
1275760 | 1275760 | 2021-05-01 | Neshoba | Mississippi | 28099 | 4021 | 176 |
1272513 | 1272513 | 2021-04-30 | Neshoba | Mississippi | 28099 | 4021 | 176 |
1263768 | 1263768 | 2021-04-27 | Williamsburg | South Carolina | 45089 | 4021 | 98 |
1224204 | 1224204 | 2021-04-15 | Fulton | New York | 36035 | 4021 | 86 |
1208188 | 1208188 | 2021-04-10 | Fulton | Ohio | 39051 | 4021 | 65 |
1199583 | 1199583 | 2021-04-07 | Albany | Wyoming | 56001 | 4021 | 11 |
1138618 | 1138618 | 2021-03-20 | Clinton | Indiana | 18023 | 4021 | 58 |
1132758 | 1132758 | 2021-03-18 | Douglas | Minnesota | 27041 | 4021 | 70 |
1125557 | 1125557 | 2021-03-16 | Jefferson | Illinois | 17081 | 4021 | 119 |
1108294 | 1108294 | 2021-03-10 | Van Zandt | Texas | 48467 | 4021 | 107 |
1105048 | 1105048 | 2021-03-09 | Van Zandt | Texas | 48467 | 4021 | 106 |
1100454 | 1100454 | 2021-03-08 | Butler | Missouri | 29023 | 4021 | 35 |
1101802 | 1101802 | 2021-03-08 | Van Zandt | Texas | 48467 | 4021 | 106 |
1082412 | 1082412 | 2021-03-02 | Campbell | Virginia | 51031 | 4021 | 58 |
1062655 | 1062655 | 2021-02-24 | Cherokee | Texas | 48073 | 4021 | 119 |
1056460 | 1056460 | 2021-02-22 | Culpeper | Virginia | 51047 | 4021 | 46 |
1037717 | 1037717 | 2021-02-17 | Effingham | Georgia | 13103 | 4021 | 55 |
1024112 | 1024112 | 2021-02-12 | Cowlitz | Washington | 53015 | 4021 | 51 |
1019292 | 1019292 | 2021-02-11 | Warren | Mississippi | 28149 | 4021 | 113 |
995889 | 995889 | 2021-02-04 | Buena Vista | Iowa | 19021 | 4021 | 35 |
990004 | 990004 | 2021-02-02 | Winona | Minnesota | 27169 | 4021 | 48 |
990459 | 990459 | 2021-02-02 | Jefferson | New York | 36045 | 4021 | 48 |
948950 | 948950 | 2021-01-20 | Fayette | Tennessee | 47047 | 4021 | 51 |
943020 | 943020 | 2021-01-18 | Harrison | West Virginia | 54033 | 4021 | 43 |
906947 | 906947 | 2021-01-07 | Howard | Texas | 48227 | 4021 | 68 |
890554 | 890554 | 2021-01-02 | Jefferson | Tennessee | 47089 | 4021 | 65 |
864320 | 864320 | 2020-12-25 | Lawrence | Pennsylvania | 42073 | 4021 | 120 |
851024 | 851024 | 2020-12-21 | Rockingham | North Carolina | 37157 | 4021 | 25 |
841616 | 841616 | 2020-12-18 | Northumberland | Pennsylvania | 42097 | 4021 | 186 |
819048 | 819048 | 2020-12-11 | Brown | South Dakota | 46013 | 4021 | 35 |
813805 | 813805 | 2020-12-10 | Jackson | Georgia | 13157 | 4021 | 60 |
806884 | 806884 | 2020-12-08 | Jackson | Alabama | 1071 | 4021 | 23 |
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);