ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where cases = 4014 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 13
- Florida 8
- Illinois 8
- Texas 8
- Indiana 7
- Missouri 7
- North Carolina 6
- Alabama 4
- Iowa 4
- Michigan 4
- Mississippi 4
- Pennsylvania 4
- Georgia 3
- Kansas 3
- Louisiana 3
- Puerto Rico 3
- Wisconsin 3
- California 2
- Kentucky 2
- Minnesota 2
- North Dakota 2
- Ohio 2
- South Carolina 2
- South Dakota 2
- Tennessee 2
- West Virginia 2
- Arkansas 1
- Colorado 1
- Idaho 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466910 | 2466910 | 2022-05-02 | Burnett | Wisconsin | 55013 | 4014 | 43 |
2425339 | 2425339 | 2022-04-20 | Mercer | Illinois | 17131 | 4014 | 47 |
2334194 | 2334194 | 2022-03-23 | Jo Daviess | Illinois | 17085 | 4014 | 38 |
2335121 | 2335121 | 2022-03-23 | Morgan | Missouri | 29141 | 4014 | 109 |
2307253 | 2307253 | 2022-03-14 | Grayson | Virginia | 51077 | 4014 | 79 |
2291601 | 2291601 | 2022-03-10 | Dixie | Florida | 12029 | 4014 | 67 |
2288349 | 2288349 | 2022-03-09 | Dixie | Florida | 12029 | 4014 | 67 |
2285098 | 2285098 | 2022-03-08 | Dixie | Florida | 12029 | 4014 | 65 |
2287739 | 2287739 | 2022-03-08 | Giles | Virginia | 51071 | 4014 | 44 |
2281846 | 2281846 | 2022-03-07 | Dixie | Florida | 12029 | 4014 | 65 |
2284487 | 2284487 | 2022-03-07 | Giles | Virginia | 51071 | 4014 | 44 |
2278593 | 2278593 | 2022-03-06 | Dixie | Florida | 12029 | 4014 | 65 |
2275340 | 2275340 | 2022-03-05 | Dixie | Florida | 12029 | 4014 | 65 |
2272087 | 2272087 | 2022-03-04 | Dixie | Florida | 12029 | 4014 | 65 |
2264039 | 2264039 | 2022-03-01 | Richland | North Dakota | 38077 | 4014 | 22 |
2264874 | 2264874 | 2022-03-01 | Zavala | Texas | 48507 | 4014 | 66 |
2260788 | 2260788 | 2022-02-28 | Richland | North Dakota | 38077 | 4014 | 22 |
2254592 | 2254592 | 2022-02-26 | Catano | Puerto Rico | 72033 | 4014 | |
2187098 | 2187098 | 2022-02-05 | Taylor | West Virginia | 54091 | 4014 | 59 |
2165728 | 2165728 | 2022-01-30 | Manistee | Michigan | 26101 | 4014 | 77 |
2162473 | 2162473 | 2022-01-29 | Manistee | Michigan | 26101 | 4014 | 77 |
2159218 | 2159218 | 2022-01-28 | Manistee | Michigan | 26101 | 4014 | 77 |
2055328 | 2055328 | 2021-12-27 | Newton | Mississippi | 28101 | 4014 | 83 |
2017855 | 2017855 | 2021-12-15 | Lee | Virginia | 51105 | 4014 | 62 |
1971735 | 1971735 | 2021-12-01 | Mayaguez | Puerto Rico | 72097 | 4014 | |
1971881 | 1971881 | 2021-12-01 | Yankton | South Dakota | 46135 | 4014 | 42 |
1964951 | 1964951 | 2021-11-29 | Hocking | Ohio | 39073 | 4014 | 93 |
1965332 | 1965332 | 2021-11-29 | Davison | South Dakota | 46035 | 4014 | 71 |
1965830 | 1965830 | 2021-11-29 | Gloucester | Virginia | 51073 | 4014 | 80 |
1946570 | 1946570 | 2021-11-23 | Waushara | Wisconsin | 55137 | 4014 | 56 |
1939551 | 1939551 | 2021-11-21 | Frio | Texas | 48163 | 4014 | 76 |
1936301 | 1936301 | 2021-11-20 | Frio | Texas | 48163 | 4014 | 76 |
1933051 | 1933051 | 2021-11-19 | Frio | Texas | 48163 | 4014 | 75 |
1925776 | 1925776 | 2021-11-17 | Dare | North Carolina | 37055 | 4014 | 14 |
1899450 | 1899450 | 2021-11-09 | Stone | Missouri | 29209 | 4014 | 86 |
1884544 | 1884544 | 2021-11-04 | Carroll | Virginia | 51035 | 4014 | 96 |
1871748 | 1871748 | 2021-10-31 | Upshur | West Virginia | 54097 | 4014 | 65 |
1826862 | 1826862 | 2021-10-18 | Peach | Georgia | 13225 | 4014 | 95 |
1755839 | 1755839 | 2021-09-26 | Miami | Kansas | 20121 | 4014 | 57 |
1752591 | 1752591 | 2021-09-25 | Miami | Kansas | 20121 | 4014 | 57 |
1749342 | 1749342 | 2021-09-24 | Miami | Kansas | 20121 | 4014 | 57 |
1742930 | 1742930 | 2021-09-22 | Grayson | Kentucky | 21085 | 4014 | 71 |
1736163 | 1736163 | 2021-09-20 | Scott | Indiana | 18143 | 4014 | 66 |
1738046 | 1738046 | 2021-09-20 | Cass | Texas | 48067 | 4014 | 114 |
1734796 | 1734796 | 2021-09-19 | Cass | Texas | 48067 | 4014 | 114 |
1731546 | 1731546 | 2021-09-18 | Cass | Texas | 48067 | 4014 | 114 |
1671848 | 1671848 | 2021-08-31 | George | Mississippi | 28039 | 4014 | 60 |
1667652 | 1667652 | 2021-08-30 | Madison | Georgia | 13195 | 4014 | 57 |
1668775 | 1668775 | 2021-08-30 | Warren | Missouri | 29219 | 4014 | 39 |
1651535 | 1651535 | 2021-08-25 | Bureau | Illinois | 17011 | 4014 | 99 |
1632888 | 1632888 | 2021-08-19 | Leflore | Mississippi | 28083 | 4014 | 127 |
1608697 | 1608697 | 2021-08-11 | Teton | Wyoming | 56039 | 4014 | 11 |
1604115 | 1604115 | 2021-08-10 | Bladen | North Carolina | 37017 | 4014 | 61 |
1558121 | 1558121 | 2021-07-27 | Steele | Minnesota | 27147 | 4014 | 19 |
1525800 | 1525800 | 2021-07-17 | Laclede | Missouri | 29105 | 4014 | 79 |
1447121 | 1447121 | 2021-06-23 | Steuben | Indiana | 18151 | 4014 | 61 |
1406214 | 1406214 | 2021-06-10 | Brown | Ohio | 39015 | 4014 | 61 |
1387622 | 1387622 | 2021-06-04 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1384377 | 1384377 | 2021-06-03 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1377886 | 1377886 | 2021-06-01 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1374640 | 1374640 | 2021-05-31 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1358987 | 1358987 | 2021-05-27 | La Plata | Colorado | 8067 | 4014 | 41 |
1349600 | 1349600 | 2021-05-24 | Fulton | Illinois | 17057 | 4014 | 66 |
1346519 | 1346519 | 2021-05-23 | Whitley | Indiana | 18183 | 4014 | 40 |
1343346 | 1343346 | 2021-05-22 | Plymouth | Iowa | 19149 | 4014 | 80 |
1336851 | 1336851 | 2021-05-20 | Plymouth | Iowa | 19149 | 4014 | 80 |
1338368 | 1338368 | 2021-05-20 | Ponce | Puerto Rico | 72113 | 4014 | |
1333604 | 1333604 | 2021-05-19 | Plymouth | Iowa | 19149 | 4014 | 80 |
1330357 | 1330357 | 2021-05-18 | Plymouth | Iowa | 19149 | 4014 | 80 |
1328794 | 1328794 | 2021-05-17 | Giles | Tennessee | 47055 | 4014 | 100 |
1322696 | 1322696 | 2021-05-15 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1319450 | 1319450 | 2021-05-14 | Charlottesville city | Virginia | 51540 | 4014 | 57 |
1316202 | 1316202 | 2021-05-13 | Charlottesville city | Virginia | 51540 | 4014 | 56 |
1297500 | 1297500 | 2021-05-08 | Liberty | Georgia | 13179 | 4014 | 63 |
1238196 | 1238196 | 2021-04-19 | Wharton | Texas | 48481 | 4014 | 113 |
1197482 | 1197482 | 2021-04-07 | Avoyelles | Louisiana | 22009 | 4014 | 122 |
1188351 | 1188351 | 2021-04-04 | Platte | Nebraska | 31141 | 4014 | 47 |
1154148 | 1154148 | 2021-03-25 | Chilton | Alabama | 1021 | 4014 | 109 |
1150901 | 1150901 | 2021-03-24 | Chilton | Alabama | 1021 | 4014 | 109 |
1149225 | 1149225 | 2021-03-23 | Platte | Missouri | 29165 | 4014 | 44 |
1144637 | 1144637 | 2021-03-22 | Tuolumne | California | 6109 | 4014 | 62 |
1141906 | 1141906 | 2021-03-21 | Montgomery | Indiana | 18107 | 4014 | 85 |
1130068 | 1130068 | 2021-03-17 | Alexander | North Carolina | 37003 | 4014 | 82 |
1126821 | 1126821 | 2021-03-16 | Alexander | North Carolina | 37003 | 4014 | 82 |
1122311 | 1122311 | 2021-03-15 | Jefferson | Illinois | 17081 | 4014 | 119 |
1115196 | 1115196 | 2021-03-13 | Covington | Alabama | 1039 | 4014 | 108 |
1112985 | 1112985 | 2021-03-12 | Hopkins | Kentucky | 21107 | 4014 | 128 |
1089160 | 1089160 | 2021-03-04 | Polk | Wisconsin | 55095 | 4014 | 46 |
1067216 | 1067216 | 2021-02-26 | Gibson | Indiana | 18051 | 4014 | 84 |
1067863 | 1067863 | 2021-02-26 | Mower | Minnesota | 27099 | 4014 | 31 |
1060054 | 1060054 | 2021-02-24 | Russell | Alabama | 1113 | 4014 | 31 |
1048192 | 1048192 | 2021-02-20 | Washington | Louisiana | 22117 | 4014 | 120 |
1044947 | 1044947 | 2021-02-19 | Washington | Louisiana | 22117 | 4014 | 120 |
1022520 | 1022520 | 2021-02-12 | Pontotoc | Mississippi | 28115 | 4014 | 65 |
1019374 | 1019374 | 2021-02-11 | Newton | Missouri | 29145 | 4014 | 63 |
1020252 | 1020252 | 2021-02-11 | Newberry | South Carolina | 45071 | 4014 | 91 |
1020867 | 1020867 | 2021-02-11 | Cowlitz | Washington | 53015 | 4014 | 51 |
1016850 | 1016850 | 2021-02-10 | Huntingdon | Pennsylvania | 42061 | 4014 | 117 |
943790 | 943790 | 2021-01-19 | Henry | Illinois | 17073 | 4014 | 76 |
928885 | 928885 | 2021-01-14 | Lenoir | North Carolina | 37107 | 4014 | 82 |
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);