ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 3980 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Tennessee 12
- Georgia 9
- Mississippi 9
- Alaska 8
- Wisconsin 8
- Illinois 6
- Ohio 6
- Michigan 5
- Virginia 5
- Indiana 4
- Florida 3
- New York 3
- Oklahoma 3
- Pennsylvania 3
- Puerto Rico 3
- Texas 3
- California 2
- Kansas 2
- Kentucky 2
- Louisiana 2
- West Virginia 2
- Arkansas 1
- Colorado 1
- Iowa 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- North Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500236 | 2500236 | 2022-05-13 | Mason | Illinois | 17125 | 3980 | 61 |
2483682 | 2483682 | 2022-05-08 | Banks | Georgia | 13011 | 3980 | 94 |
2480424 | 2480424 | 2022-05-07 | Banks | Georgia | 13011 | 3980 | 94 |
2477166 | 2477166 | 2022-05-06 | Banks | Georgia | 13011 | 3980 | 94 |
2473908 | 2473908 | 2022-05-05 | Banks | Georgia | 13011 | 3980 | 94 |
2470651 | 2470651 | 2022-05-04 | Banks | Georgia | 13011 | 3980 | 94 |
2444286 | 2444286 | 2022-04-26 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2441030 | 2441030 | 2022-04-25 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2437774 | 2437774 | 2022-04-24 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2434518 | 2434518 | 2022-04-23 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2431262 | 2431262 | 2022-04-22 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2428006 | 2428006 | 2022-04-21 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2424750 | 2424750 | 2022-04-20 | Ketchikan Gateway Borough | Alaska | 2130 | 3980 | 17 |
2418071 | 2418071 | 2022-04-17 | Burnett | Wisconsin | 55013 | 3980 | 43 |
2414815 | 2414815 | 2022-04-16 | Burnett | Wisconsin | 55013 | 3980 | 43 |
2411559 | 2411559 | 2022-04-15 | Burnett | Wisconsin | 55013 | 3980 | 43 |
2408303 | 2408303 | 2022-04-14 | Burnett | Wisconsin | 55013 | 3980 | 43 |
2401851 | 2401851 | 2022-04-12 | Washburn | Wisconsin | 55129 | 3980 | 46 |
2398596 | 2398596 | 2022-04-11 | Washburn | Wisconsin | 55129 | 3980 | 46 |
2355631 | 2355631 | 2022-03-29 | Grundy | Tennessee | 47061 | 3980 | 71 |
2352378 | 2352378 | 2022-03-28 | Grundy | Tennessee | 47061 | 3980 | 71 |
2349126 | 2349126 | 2022-03-27 | Grundy | Tennessee | 47061 | 3980 | 71 |
2345873 | 2345873 | 2022-03-26 | Grundy | Tennessee | 47061 | 3980 | 71 |
2342620 | 2342620 | 2022-03-25 | Grundy | Tennessee | 47061 | 3980 | 71 |
2339367 | 2339367 | 2022-03-24 | Grundy | Tennessee | 47061 | 3980 | 71 |
2336113 | 2336113 | 2022-03-23 | Grundy | Tennessee | 47061 | 3980 | 71 |
2269143 | 2269143 | 2022-03-03 | Jo Daviess | Illinois | 17085 | 3980 | 38 |
2213633 | 2213633 | 2022-02-14 | Brantley | Georgia | 13025 | 3980 | 98 |
2183851 | 2183851 | 2022-02-04 | Wetzel | West Virginia | 54103 | 3980 | 71 |
2155569 | 2155569 | 2022-01-27 | Atchison | Kansas | 20005 | 3980 | 31 |
2152129 | 2152129 | 2022-01-26 | Carroll | Indiana | 18015 | 3980 | 53 |
2152316 | 2152316 | 2022-01-26 | Atchison | Kansas | 20005 | 3980 | 31 |
2074800 | 2074800 | 2022-01-02 | Grenada | Mississippi | 28043 | 3980 | 111 |
2071549 | 2071549 | 2022-01-01 | Grenada | Mississippi | 28043 | 3980 | 111 |
2068298 | 2068298 | 2021-12-31 | Grenada | Mississippi | 28043 | 3980 | 111 |
2065047 | 2065047 | 2021-12-30 | Grenada | Mississippi | 28043 | 3980 | 111 |
2029131 | 2029131 | 2021-12-19 | Gladwin | Michigan | 26051 | 3980 | 90 |
2025880 | 2025880 | 2021-12-18 | Gladwin | Michigan | 26051 | 3980 | 90 |
2022629 | 2022629 | 2021-12-17 | Gladwin | Michigan | 26051 | 3980 | 90 |
2016325 | 2016325 | 2021-12-15 | Newton | Mississippi | 28101 | 3980 | 83 |
2013074 | 2013074 | 2021-12-14 | Newton | Mississippi | 28101 | 3980 | 83 |
2009823 | 2009823 | 2021-12-13 | Newton | Mississippi | 28101 | 3980 | 83 |
1972455 | 1972455 | 2021-12-01 | Boone | West Virginia | 54005 | 3980 | 62 |
1958448 | 1958448 | 2021-11-27 | Hocking | Ohio | 39073 | 3980 | 93 |
1945338 | 1945338 | 2021-11-23 | Transylvania | North Carolina | 37175 | 3980 | 50 |
1945727 | 1945727 | 2021-11-23 | Mayaguez | Puerto Rico | 72097 | 3980 | |
1923300 | 1923300 | 2021-11-16 | Frio | Texas | 48163 | 3980 | 75 |
1897922 | 1897922 | 2021-11-09 | Juneau City and Borough | Alaska | 2110 | 3980 | 11 |
1826140 | 1826140 | 2021-10-17 | Pulaski | Virginia | 51155 | 3980 | 81 |
1822891 | 1822891 | 2021-10-16 | Pulaski | Virginia | 51155 | 3980 | 81 |
1819642 | 1819642 | 2021-10-15 | Pulaski | Virginia | 51155 | 3980 | 81 |
1791123 | 1791123 | 2021-10-07 | Peach | Georgia | 13225 | 3980 | 92 |
1760206 | 1760206 | 2021-09-27 | Coshocton | Ohio | 39031 | 3980 | 69 |
1745627 | 1745627 | 2021-09-23 | Monroe | Georgia | 13207 | 3980 | 132 |
1735585 | 1735585 | 2021-09-20 | Glenn | California | 6021 | 3980 | 33 |
1728296 | 1728296 | 2021-09-17 | Cass | Texas | 48067 | 3980 | 113 |
1679215 | 1679215 | 2021-09-02 | McKean | Pennsylvania | 42083 | 3980 | 75 |
1667601 | 1667601 | 2021-08-30 | Decatur | Georgia | 13087 | 3980 | 81 |
1668264 | 1668264 | 2021-08-30 | Perry | Kentucky | 21193 | 3980 | 70 |
1645983 | 1645983 | 2021-08-23 | Lafayette | Missouri | 29107 | 3980 | 62 |
1630499 | 1630499 | 2021-08-18 | Perry | Pennsylvania | 42099 | 3980 | 101 |
1627560 | 1627560 | 2021-08-17 | White | Tennessee | 47185 | 3980 | 75 |
1581315 | 1581315 | 2021-08-03 | Cortland | New York | 36023 | 3980 | 64 |
1575090 | 1575090 | 2021-08-01 | Preble | Ohio | 39135 | 3980 | 107 |
1457477 | 1457477 | 2021-06-26 | Steele | Minnesota | 27147 | 3980 | 18 |
1443212 | 1443212 | 2021-06-22 | Boone | Arkansas | 5009 | 3980 | 80 |
1401681 | 1401681 | 2021-06-09 | Steuben | Indiana | 18151 | 3980 | 61 |
1361023 | 1361023 | 2021-05-27 | Pike | Pennsylvania | 42103 | 3980 | 54 |
1330943 | 1330943 | 2021-05-18 | Lincoln | Mississippi | 28085 | 3980 | 111 |
1320031 | 1320031 | 2021-05-15 | Logan | Colorado | 8075 | 3980 | 67 |
1318889 | 1318889 | 2021-05-14 | Ponce | Puerto Rico | 72113 | 3980 | |
1303713 | 1303713 | 2021-05-10 | Humboldt | California | 6023 | 3980 | 40 |
1280098 | 1280098 | 2021-05-02 | Giles | Tennessee | 47055 | 3980 | 100 |
1276851 | 1276851 | 2021-05-01 | Giles | Tennessee | 47055 | 3980 | 100 |
1273604 | 1273604 | 2021-04-30 | Giles | Tennessee | 47055 | 3980 | 100 |
1246237 | 1246237 | 2021-04-22 | St. Bernard | Louisiana | 22087 | 3980 | 49 |
1236604 | 1236604 | 2021-04-19 | Hillsdale | Michigan | 26059 | 3980 | 82 |
1231786 | 1231786 | 2021-04-17 | Charlottesville city | Virginia | 51540 | 3980 | 55 |
1217709 | 1217709 | 2021-04-13 | Fulton | New York | 36035 | 3980 | 86 |
1204751 | 1204751 | 2021-04-09 | Tompkins | New York | 36109 | 3980 | 49 |
1200761 | 1200761 | 2021-04-08 | Natchitoches | Louisiana | 22069 | 3980 | 84 |
1191946 | 1191946 | 2021-04-05 | Fulton | Ohio | 39051 | 3980 | 64 |
1177588 | 1177588 | 2021-04-01 | DeKalb | Indiana | 18033 | 3980 | 84 |
1110792 | 1110792 | 2021-03-11 | Madison | Ohio | 39097 | 3980 | 55 |
1111672 | 1111672 | 2021-03-11 | James City | Virginia | 51095 | 3980 | 67 |
1096741 | 1096741 | 2021-03-07 | Graves | Kentucky | 21083 | 3980 | 74 |
1093167 | 1093167 | 2021-03-06 | Clinton | Indiana | 18023 | 3980 | 58 |
1094668 | 1094668 | 2021-03-06 | Sequoyah | Oklahoma | 40135 | 3980 | 31 |
1089885 | 1089885 | 2021-03-05 | Randolph | Illinois | 17157 | 3980 | 85 |
1080110 | 1080110 | 2021-03-02 | Jefferson | Illinois | 17081 | 3980 | 117 |
1076865 | 1076865 | 2021-03-01 | Jefferson | Illinois | 17081 | 3980 | 116 |
1064704 | 1064704 | 2021-02-25 | Monroe | Mississippi | 28095 | 3980 | 126 |
995736 | 995736 | 2021-02-04 | Livingston | Illinois | 17105 | 3980 | 77 |
969980 | 969980 | 2021-01-27 | Muscatine | Iowa | 19139 | 3980 | 79 |
948207 | 948207 | 2021-01-20 | Salem | New Jersey | 34033 | 3980 | 128 |
949567 | 949567 | 2021-01-20 | Douglas | Wisconsin | 55031 | 3980 | 31 |
900121 | 900121 | 2021-01-05 | Unknown | Puerto Rico | 3980 | 1562 | |
886891 | 886891 | 2021-01-01 | Bryan | Oklahoma | 40013 | 3980 | 32 |
883646 | 883646 | 2020-12-31 | Bryan | Oklahoma | 40013 | 3980 | 32 |
858299 | 858299 | 2020-12-23 | Liberty | Texas | 48291 | 3980 | 85 |
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);