ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 5036 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 9
- Illinois 7
- Pennsylvania 7
- Nebraska 6
- Utah 6
- Wisconsin 6
- Alabama 5
- Arkansas 5
- Missouri 4
- North Carolina 4
- Ohio 4
- Puerto Rico 4
- Virginia 4
- Michigan 3
- Minnesota 3
- New York 3
- West Virginia 3
- Georgia 2
- Idaho 2
- Indiana 2
- North Dakota 2
- Arizona 1
- California 1
- Iowa 1
- Maine 1
- Massachusetts 1
- Mississippi 1
- Nevada 1
- New Jersey 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501149 | 2501149 | 2022-05-13 | New Madrid | Missouri | 29143 | 5036 | 86 |
2485037 | 2485037 | 2022-05-08 | Saunders | Nebraska | 31155 | 5036 | 30 |
2481779 | 2481779 | 2022-05-07 | Saunders | Nebraska | 31155 | 5036 | 30 |
2478521 | 2478521 | 2022-05-06 | Saunders | Nebraska | 31155 | 5036 | 30 |
2475263 | 2475263 | 2022-05-05 | Saunders | Nebraska | 31155 | 5036 | 30 |
2472006 | 2472006 | 2022-05-04 | Saunders | Nebraska | 31155 | 5036 | 30 |
2444062 | 2444062 | 2022-04-25 | Brooke | West Virginia | 54009 | 5036 | 104 |
2428604 | 2428604 | 2022-04-21 | Pike | Illinois | 17149 | 5036 | 70 |
2422092 | 2422092 | 2022-04-19 | Pike | Illinois | 17149 | 5036 | 70 |
2353641 | 2353641 | 2022-03-29 | Cassia | Idaho | 16031 | 5036 | 52 |
2350389 | 2350389 | 2022-03-28 | Cassia | Idaho | 16031 | 5036 | 52 |
2332665 | 2332665 | 2022-03-22 | Hatillo | Puerto Rico | 72065 | 5036 | |
2329412 | 2329412 | 2022-03-21 | Hatillo | Puerto Rico | 72065 | 5036 | |
2326160 | 2326160 | 2022-03-20 | Hatillo | Puerto Rico | 72065 | 5036 | |
2322907 | 2322907 | 2022-03-19 | Hatillo | Puerto Rico | 72065 | 5036 | |
2293228 | 2293228 | 2022-03-10 | Madison | North Carolina | 37115 | 5036 | 79 |
2283842 | 2283842 | 2022-03-07 | Wyoming | Pennsylvania | 42131 | 5036 | 100 |
2280590 | 2280590 | 2022-03-06 | Wyoming | Pennsylvania | 42131 | 5036 | 100 |
2277337 | 2277337 | 2022-03-05 | Wyoming | Pennsylvania | 42131 | 5036 | 100 |
2261923 | 2261923 | 2022-02-28 | Green Lake | Wisconsin | 55047 | 5036 | 58 |
2249046 | 2249046 | 2022-02-25 | Randolph | Alabama | 1111 | 5036 | 74 |
2200339 | 2200339 | 2022-02-10 | Clark | Arkansas | 5019 | 5036 | 73 |
2190581 | 2190581 | 2022-02-07 | Columbia | Arkansas | 5027 | 5036 | 77 |
2187328 | 2187328 | 2022-02-06 | Columbia | Arkansas | 5027 | 5036 | 77 |
2155397 | 2155397 | 2022-01-27 | Fountain | Indiana | 18045 | 5036 | 87 |
2155753 | 2155753 | 2022-01-27 | Meade | Kentucky | 21163 | 5036 | 58 |
2142662 | 2142662 | 2022-01-23 | Anderson | Kentucky | 21005 | 5036 | 58 |
2139407 | 2139407 | 2022-01-22 | Anderson | Kentucky | 21005 | 5036 | 58 |
2136151 | 2136151 | 2022-01-21 | Anderson | Kentucky | 21005 | 5036 | 58 |
2134318 | 2134318 | 2022-01-20 | Barnwell | South Carolina | 45011 | 5036 | 88 |
2042096 | 2042096 | 2021-12-23 | Franklin | Massachusetts | 25011 | 5036 | 128 |
2039702 | 2039702 | 2021-12-22 | Gallia | Ohio | 39053 | 5036 | 81 |
2012091 | 2012091 | 2021-12-14 | Lumpkin | Georgia | 13187 | 5036 | 110 |
2013093 | 2013093 | 2021-12-14 | Tippah | Mississippi | 28139 | 5036 | 84 |
2010049 | 2010049 | 2021-12-13 | Dakota | Nebraska | 31043 | 5036 | 82 |
1994190 | 1994190 | 2021-12-08 | Fayette | Ohio | 39047 | 5036 | 72 |
1940748 | 1940748 | 2021-11-22 | Lee | Illinois | 17103 | 5036 | 104 |
1921793 | 1921793 | 2021-11-16 | Somerset | Maine | 23025 | 5036 | 56 |
1897708 | 1897708 | 2021-11-08 | Greenbrier | West Virginia | 54025 | 5036 | 98 |
1892621 | 1892621 | 2021-11-07 | Huron | Michigan | 26063 | 5036 | 96 |
1889371 | 1889371 | 2021-11-06 | Huron | Michigan | 26063 | 5036 | 96 |
1886121 | 1886121 | 2021-11-05 | Huron | Michigan | 26063 | 5036 | 96 |
1876935 | 1876935 | 2021-11-02 | Rio Arriba | New Mexico | 35039 | 5036 | 85 |
1870210 | 1870210 | 2021-10-31 | Warren | Missouri | 29219 | 5036 | 47 |
1858802 | 1858802 | 2021-10-27 | Oneida | Wisconsin | 55085 | 5036 | 91 |
1831507 | 1831507 | 2021-10-19 | Tioga | New York | 36107 | 5036 | 71 |
1825090 | 1825090 | 2021-10-17 | Person | North Carolina | 37145 | 5036 | 87 |
1821841 | 1821841 | 2021-10-16 | Person | North Carolina | 37145 | 5036 | 87 |
1818592 | 1818592 | 2021-10-15 | Person | North Carolina | 37145 | 5036 | 87 |
1815832 | 1815832 | 2021-10-14 | Brookings | South Dakota | 46011 | 5036 | 38 |
1790495 | 1790495 | 2021-10-06 | Marshall | West Virginia | 54051 | 5036 | 102 |
1759486 | 1759486 | 2021-09-27 | Isanti | Minnesota | 27059 | 5036 | 70 |
1648096 | 1648096 | 2021-08-24 | Chattahoochee | Georgia | 13053 | 5036 | 17 |
1641872 | 1641872 | 2021-08-22 | Stephenson | Illinois | 17177 | 5036 | 106 |
1638622 | 1638622 | 2021-08-21 | Stephenson | Illinois | 17177 | 5036 | 106 |
1635372 | 1635372 | 2021-08-20 | Stephenson | Illinois | 17177 | 5036 | 106 |
1625001 | 1625001 | 2021-08-17 | Tallapoosa | Alabama | 1123 | 5036 | 157 |
1626289 | 1626289 | 2021-08-17 | Goodhue | Minnesota | 27049 | 5036 | 75 |
1608856 | 1608856 | 2021-08-12 | Miller | Arkansas | 5091 | 5036 | 37 |
1598973 | 1598973 | 2021-08-09 | Covington | Alabama | 1039 | 5036 | 126 |
1596762 | 1596762 | 2021-08-08 | Jessamine | Kentucky | 21113 | 5036 | 75 |
1592570 | 1592570 | 2021-08-07 | Boone | Arkansas | 5009 | 5036 | 84 |
1593513 | 1593513 | 2021-08-07 | Jessamine | Kentucky | 21113 | 5036 | 75 |
1590264 | 1590264 | 2021-08-06 | Jessamine | Kentucky | 21113 | 5036 | 75 |
1582660 | 1582660 | 2021-08-03 | Pierce | Wisconsin | 55093 | 5036 | 44 |
1504572 | 1504572 | 2021-07-10 | Washington | Virginia | 51191 | 5036 | 111 |
1494833 | 1494833 | 2021-07-07 | Washington | Virginia | 51191 | 5036 | 111 |
1477606 | 1477606 | 2021-07-02 | Williams | North Dakota | 38105 | 5036 | 40 |
1402411 | 1402411 | 2021-06-09 | Callaway | Missouri | 29027 | 5036 | 51 |
1379950 | 1379950 | 2021-06-02 | Elko | Nevada | 32007 | 5036 | 56 |
1345962 | 1345962 | 2021-05-23 | Tehama | California | 6103 | 5036 | 63 |
1346734 | 1346734 | 2021-05-23 | Boyd | Kentucky | 21019 | 5036 | 75 |
1343486 | 1343486 | 2021-05-22 | Boyd | Kentucky | 21019 | 5036 | 75 |
1320487 | 1320487 | 2021-05-15 | Jackson | Indiana | 18071 | 5036 | 74 |
1290451 | 1290451 | 2021-05-05 | Dunn | Wisconsin | 55033 | 5036 | 32 |
1227453 | 1227453 | 2021-04-16 | Genesee | New York | 36037 | 5036 | 121 |
1185398 | 1185398 | 2021-04-03 | Morton | North Dakota | 38059 | 5036 | 98 |
1168018 | 1168018 | 2021-03-29 | Webster | Iowa | 19187 | 5036 | 89 |
1169230 | 1169230 | 2021-03-29 | Jefferson | Ohio | 39081 | 5036 | 144 |
1163512 | 1163512 | 2021-03-27 | Box Elder | Utah | 49003 | 5036 | 47 |
1098587 | 1098587 | 2021-03-07 | Iron | Utah | 49021 | 5036 | 32 |
1095339 | 1095339 | 2021-03-06 | Iron | Utah | 49021 | 5036 | 32 |
1092093 | 1092093 | 2021-03-05 | Iron | Utah | 49021 | 5036 | 32 |
1092116 | 1092116 | 2021-03-05 | Chittenden | Vermont | 50007 | 5036 | 88 |
1088847 | 1088847 | 2021-03-04 | Iron | Utah | 49021 | 5036 | 32 |
1083386 | 1083386 | 2021-03-03 | Ogle | Illinois | 17141 | 5036 | 81 |
1084794 | 1084794 | 2021-03-03 | Darke | Ohio | 39037 | 5036 | 114 |
1085602 | 1085602 | 2021-03-03 | Iron | Utah | 49021 | 5036 | 32 |
1081664 | 1081664 | 2021-03-02 | McClain | Oklahoma | 40087 | 5036 | 49 |
995099 | 995099 | 2021-02-04 | Coffee | Alabama | 1031 | 5036 | 76 |
945389 | 945389 | 2021-01-19 | Deschutes | Oregon | 41017 | 5036 | 37 |
930134 | 930134 | 2021-01-14 | Sauk | Wisconsin | 55111 | 5036 | 37 |
878043 | 878043 | 2020-12-29 | Stafford | Virginia | 51179 | 5036 | 24 |
868576 | 868576 | 2020-12-27 | Walker | Alabama | 1127 | 5036 | 133 |
805867 | 805867 | 2020-12-07 | Beaver | Pennsylvania | 42007 | 5036 | 170 |
775995 | 775995 | 2020-11-28 | St. Francois | Missouri | 29187 | 5036 | 44 |
770206 | 770206 | 2020-11-26 | Lebanon | Pennsylvania | 42075 | 5036 | 106 |
761513 | 761513 | 2020-11-24 | Apache | Arizona | 4001 | 5036 | 195 |
723869 | 723869 | 2020-11-12 | St. Louis | Minnesota | 27137 | 5036 | 79 |
712427 | 712427 | 2020-11-08 | Arlington | Virginia | 51013 | 5036 | 155 |
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);