ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 4741 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 10
- Kentucky 7
- Alabama 6
- Arkansas 6
- Indiana 6
- Texas 6
- Virginia 5
- New York 4
- North Carolina 4
- Utah 4
- Colorado 3
- Michigan 3
- Mississippi 3
- Pennsylvania 3
- Tennessee 3
- Illinois 2
- Minnesota 2
- Missouri 2
- Nebraska 2
- Ohio 2
- South Carolina 2
- Wisconsin 2
- Wyoming 2
- Arizona 1
- California 1
- Florida 1
- Iowa 1
- Kansas 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499607 | 2499607 | 2022-05-13 | Hale | Alabama | 1065 | 4741 | 106 |
2496349 | 2496349 | 2022-05-12 | Hale | Alabama | 1065 | 4741 | 106 |
2493091 | 2493091 | 2022-05-11 | Hale | Alabama | 1065 | 4741 | 106 |
2459649 | 2459649 | 2022-04-30 | Yauco | Puerto Rico | 72153 | 4741 | |
2376106 | 2376106 | 2022-04-05 | Elbert | Colorado | 8039 | 4741 | 37 |
2360354 | 2360354 | 2022-03-31 | Starke | Indiana | 18149 | 4741 | 96 |
2357100 | 2357100 | 2022-03-30 | Starke | Indiana | 18149 | 4741 | 96 |
2293967 | 2293967 | 2022-03-10 | Fayette | Texas | 48149 | 4741 | 100 |
2290715 | 2290715 | 2022-03-09 | Fayette | Texas | 48149 | 4741 | 100 |
2281674 | 2281674 | 2022-03-07 | Phillips | Arkansas | 5107 | 4741 | 94 |
2278421 | 2278421 | 2022-03-06 | Phillips | Arkansas | 5107 | 4741 | 94 |
2275168 | 2275168 | 2022-03-05 | Phillips | Arkansas | 5107 | 4741 | 94 |
2247018 | 2247018 | 2022-02-24 | Iosco | Michigan | 26069 | 4741 | 133 |
2243767 | 2243767 | 2022-02-23 | Iosco | Michigan | 26069 | 4741 | 133 |
2213764 | 2213764 | 2022-02-14 | Union | Georgia | 13291 | 4741 | 142 |
2201638 | 2201638 | 2022-02-10 | Attala | Mississippi | 28007 | 4741 | 104 |
2196929 | 2196929 | 2022-02-08 | Taylor | Wisconsin | 55119 | 4741 | 65 |
2147743 | 2147743 | 2022-01-24 | San Jacinto | Texas | 48407 | 4741 | 87 |
2144371 | 2144371 | 2022-01-23 | Gillespie | Texas | 48171 | 4741 | 89 |
2144658 | 2144658 | 2022-01-23 | Lee | Virginia | 51105 | 4741 | 72 |
2141403 | 2141403 | 2022-01-22 | Lee | Virginia | 51105 | 4741 | 72 |
2137902 | 2137902 | 2022-01-21 | Karnes | Texas | 48255 | 4741 | 60 |
2138147 | 2138147 | 2022-01-21 | Lee | Virginia | 51105 | 4741 | 72 |
2125390 | 2125390 | 2022-01-18 | Barbour | Alabama | 1005 | 4741 | 83 |
2063754 | 2063754 | 2021-12-30 | Jackson | Arkansas | 5067 | 4741 | 47 |
2056419 | 2056419 | 2021-12-27 | Grainger | Tennessee | 47057 | 4741 | 89 |
2030787 | 2030787 | 2021-12-19 | Windsor | Vermont | 50027 | 4741 | 40 |
1996447 | 1996447 | 2021-12-09 | Ohio | Kentucky | 21183 | 4741 | 89 |
1932210 | 1932210 | 2021-11-19 | Greene | New York | 36039 | 4741 | 87 |
1924985 | 1924985 | 2021-11-17 | Franklin | Louisiana | 22041 | 4741 | 139 |
1921026 | 1921026 | 2021-11-16 | Dawson | Georgia | 13085 | 4741 | 75 |
1918299 | 1918299 | 2021-11-15 | McPherson | Kansas | 20113 | 4741 | 98 |
1897724 | 1897724 | 2021-11-08 | Mineral | West Virginia | 54057 | 4741 | 116 |
1878581 | 1878581 | 2021-11-03 | Siskiyou | California | 6093 | 4741 | 65 |
1853833 | 1853833 | 2021-10-26 | Scott | Mississippi | 28123 | 4741 | 98 |
1836412 | 1836412 | 2021-10-21 | Summit | Colorado | 8117 | 4741 | 11 |
1813357 | 1813357 | 2021-10-13 | Park | Wyoming | 56029 | 4741 | 60 |
1792582 | 1792582 | 2021-10-07 | Macon | North Carolina | 37113 | 4741 | 54 |
1765296 | 1765296 | 2021-09-29 | Montgomery | Illinois | 17135 | 4741 | 83 |
1679763 | 1679763 | 2021-09-02 | Upshur | Texas | 48459 | 4741 | 89 |
1664418 | 1664418 | 2021-08-29 | Oconee | Georgia | 13219 | 4741 | 75 |
1661170 | 1661170 | 2021-08-28 | Oconee | Georgia | 13219 | 4741 | 75 |
1657922 | 1657922 | 2021-08-27 | Oconee | Georgia | 13219 | 4741 | 75 |
1656284 | 1656284 | 2021-08-26 | Madison | Ohio | 39097 | 4741 | 65 |
1630056 | 1630056 | 2021-08-18 | Madison | New York | 36053 | 4741 | 89 |
1606166 | 1606166 | 2021-08-11 | Clinton | Indiana | 18023 | 4741 | 63 |
1604108 | 1604108 | 2021-08-10 | Alexander | North Carolina | 37003 | 4741 | 85 |
1599995 | 1599995 | 2021-08-09 | Graves | Kentucky | 21083 | 4741 | 99 |
1526518 | 1526518 | 2021-07-17 | Bedford | Pennsylvania | 42009 | 4741 | 142 |
1523271 | 1523271 | 2021-07-16 | Bedford | Pennsylvania | 42009 | 4741 | 142 |
1520023 | 1520023 | 2021-07-15 | Bedford | Pennsylvania | 42009 | 4741 | 142 |
1504477 | 1504477 | 2021-07-10 | Culpeper | Virginia | 51047 | 4741 | 67 |
1485730 | 1485730 | 2021-07-05 | Effingham | Georgia | 13103 | 4741 | 74 |
1488192 | 1488192 | 2021-07-05 | Wasatch | Utah | 49051 | 4741 | 22 |
1482484 | 1482484 | 2021-07-04 | Effingham | Georgia | 13103 | 4741 | 74 |
1484945 | 1484945 | 2021-07-04 | Wasatch | Utah | 49051 | 4741 | 22 |
1479237 | 1479237 | 2021-07-03 | Effingham | Georgia | 13103 | 4741 | 74 |
1481699 | 1481699 | 2021-07-03 | Wasatch | Utah | 49051 | 4741 | 22 |
1475991 | 1475991 | 2021-07-02 | Effingham | Georgia | 13103 | 4741 | 74 |
1478452 | 1478452 | 2021-07-02 | Wasatch | Utah | 49051 | 4741 | 22 |
1430862 | 1430862 | 2021-06-18 | Lawrence | Indiana | 18093 | 4741 | 125 |
1427617 | 1427617 | 2021-06-17 | Lawrence | Indiana | 18093 | 4741 | 125 |
1418721 | 1418721 | 2021-06-14 | Scott | Missouri | 29201 | 4741 | 86 |
1415476 | 1415476 | 2021-06-13 | Scott | Missouri | 29201 | 4741 | 86 |
1386021 | 1386021 | 2021-06-04 | Douglas | Minnesota | 27041 | 4741 | 80 |
1383351 | 1383351 | 2021-06-03 | Chatham | North Carolina | 37037 | 4741 | 89 |
1356088 | 1356088 | 2021-05-26 | Effingham | Illinois | 17049 | 4741 | 83 |
1356520 | 1356520 | 2021-05-26 | Jessamine | Kentucky | 21113 | 4741 | 64 |
1352642 | 1352642 | 2021-05-25 | Colquitt | Georgia | 13071 | 4741 | 123 |
1330790 | 1330790 | 2021-05-18 | Newaygo | Michigan | 26123 | 4741 | 64 |
1297368 | 1297368 | 2021-05-08 | Hendry | Florida | 12051 | 4741 | 83 |
1285088 | 1285088 | 2021-05-04 | Henderson | Kentucky | 21101 | 4741 | 75 |
1277464 | 1277464 | 2021-05-01 | Douglas | Wisconsin | 55031 | 4741 | 51 |
1220212 | 1220212 | 2021-04-14 | Whitley | Kentucky | 21235 | 4741 | 48 |
1213790 | 1213790 | 2021-04-12 | Kennebec | Maine | 23011 | 4741 | 59 |
1215049 | 1215049 | 2021-04-12 | Newberry | South Carolina | 45071 | 4741 | 100 |
1177729 | 1177729 | 2021-04-01 | Marshall | Iowa | 19127 | 4741 | 74 |
1176850 | 1176850 | 2021-03-31 | Campbell | Wyoming | 56005 | 4741 | 60 |
1165301 | 1165301 | 2021-03-28 | Bolivar | Mississippi | 28011 | 4741 | 125 |
1154160 | 1154160 | 2021-03-25 | Dale | Alabama | 1045 | 4741 | 109 |
1155834 | 1155834 | 2021-03-25 | Dodge | Nebraska | 31053 | 4741 | 58 |
1151901 | 1151901 | 2021-03-24 | Boyd | Kentucky | 21019 | 4741 | 66 |
1148654 | 1148654 | 2021-03-23 | Boyd | Kentucky | 21019 | 4741 | 66 |
1130713 | 1130713 | 2021-03-17 | Fayette | Tennessee | 47047 | 4741 | 75 |
1074873 | 1074873 | 2021-02-28 | Sullivan | New York | 36105 | 4741 | 59 |
1060137 | 1060137 | 2021-02-24 | Hot Spring | Arkansas | 5059 | 4741 | 68 |
1055468 | 1055468 | 2021-02-22 | McDowell | North Carolina | 37111 | 4741 | 55 |
981784 | 981784 | 2021-01-30 | Augusta | Virginia | 51015 | 4741 | 48 |
961061 | 961061 | 2021-01-24 | Buffalo | Nebraska | 31019 | 4741 | 54 |
932638 | 932638 | 2021-01-15 | Brown | South Dakota | 46013 | 4741 | 72 |
917349 | 917349 | 2021-01-11 | Mississippi | Arkansas | 5093 | 4741 | 100 |
908214 | 908214 | 2021-01-08 | Morgan | Indiana | 18109 | 4741 | 87 |
876640 | 876640 | 2020-12-29 | Lewis and Clark | Montana | 30049 | 4741 | 37 |
863908 | 863908 | 2020-12-25 | Saratoga | New York | 36091 | 4741 | 32 |
849106 | 849106 | 2020-12-21 | Walker | Alabama | 1127 | 4741 | 131 |
812346 | 812346 | 2020-12-09 | Umatilla | Oregon | 41059 | 4741 | 52 |
756721 | 756721 | 2020-11-22 | Cumberland | New Jersey | 34011 | 4741 | 170 |
748529 | 748529 | 2020-11-20 | Apache | Arizona | 4001 | 4741 | 192 |
731541 | 731541 | 2020-11-14 | Maury | Tennessee | 47119 | 4741 | 46 |
576833 | 576833 | 2020-09-28 | Weld | Colorado | 8123 | 4741 | 150 |
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);