ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 3093 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 12
- Georgia 11
- Arkansas 9
- Indiana 8
- Minnesota 8
- Kentucky 7
- Mississippi 6
- Puerto Rico 6
- Louisiana 5
- Michigan 5
- Ohio 5
- Alabama 4
- Illinois 4
- Iowa 4
- New York 4
- Florida 3
- New Mexico 3
- North Carolina 3
- South Dakota 3
- California 2
- Idaho 2
- Maryland 2
- Montana 2
- Oklahoma 2
- Texas 2
- West Virginia 2
- Colorado 1
- Maine 1
- Missouri 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494258 | 2494258 | 2022-05-11 | Piscataquis | Maine | 23021 | 3093 | 31 |
2490325 | 2490325 | 2022-05-10 | Telfair | Georgia | 13271 | 3093 | 85 |
2487068 | 2487068 | 2022-05-09 | Telfair | Georgia | 13271 | 3093 | 85 |
2465085 | 2465085 | 2022-05-02 | Chippewa | Minnesota | 27023 | 3093 | 48 |
2236456 | 2236456 | 2022-02-21 | Jasper | Georgia | 13159 | 3093 | 68 |
2222738 | 2222738 | 2022-02-16 | Martinsville city | Virginia | 51690 | 3093 | 107 |
2198309 | 2198309 | 2022-02-09 | Cottonwood | Minnesota | 27033 | 3093 | 38 |
2199344 | 2199344 | 2022-02-09 | Loiza | Puerto Rico | 72087 | 3093 | |
2163567 | 2163567 | 2022-01-29 | Naguabo | Puerto Rico | 72103 | 3093 | |
2152036 | 2152036 | 2022-01-26 | Cumberland | Illinois | 17035 | 3093 | 47 |
2081307 | 2081307 | 2022-01-04 | Holmes | Mississippi | 28051 | 3093 | 93 |
2076746 | 2076746 | 2022-01-03 | Drew | Arkansas | 5043 | 3093 | 57 |
2059022 | 2059022 | 2021-12-28 | Avery | North Carolina | 37011 | 3093 | 39 |
2054962 | 2054962 | 2021-12-27 | Powell | Kentucky | 21197 | 3093 | 28 |
2035611 | 2035611 | 2021-12-21 | Antrim | Michigan | 26009 | 3093 | 50 |
2033075 | 2033075 | 2021-12-20 | Madison | North Carolina | 37115 | 3093 | 66 |
2024127 | 2024127 | 2021-12-17 | Lamb | Texas | 48279 | 3093 | 97 |
2005245 | 2005245 | 2021-12-12 | Hempstead | Arkansas | 5057 | 3093 | 44 |
1994036 | 1994036 | 2021-12-08 | Currituck | North Carolina | 37053 | 3093 | 27 |
1972532 | 1972532 | 2021-12-01 | Iowa | Wisconsin | 55049 | 3093 | 18 |
1942980 | 1942980 | 2021-11-22 | Duchesne | Utah | 49013 | 3093 | 19 |
1905109 | 1905109 | 2021-11-11 | Orange | Indiana | 18117 | 3093 | 72 |
1903443 | 1903443 | 2021-11-10 | Canovanas | Puerto Rico | 72029 | 3093 | |
1903464 | 1903464 | 2021-11-10 | Humacao | Puerto Rico | 72069 | 3093 | |
1895160 | 1895160 | 2021-11-08 | Blaine | Idaho | 16013 | 3093 | 27 |
1888105 | 1888105 | 2021-11-06 | Cherokee | Alabama | 1019 | 3093 | 62 |
1879046 | 1879046 | 2021-11-03 | Wayne | Illinois | 17191 | 3093 | 65 |
1874953 | 1874953 | 2021-11-01 | Brooke | West Virginia | 54009 | 3093 | 73 |
1869151 | 1869151 | 2021-10-31 | Worth | Georgia | 13321 | 3093 | 91 |
1865902 | 1865902 | 2021-10-30 | Worth | Georgia | 13321 | 3093 | 91 |
1862653 | 1862653 | 2021-10-29 | Worth | Georgia | 13321 | 3093 | 91 |
1860282 | 1860282 | 2021-10-28 | Clay | Mississippi | 28025 | 3093 | 77 |
1833588 | 1833588 | 2021-10-20 | Fulton | Indiana | 18049 | 3093 | 68 |
1810896 | 1810896 | 2021-10-13 | Starke | Indiana | 18149 | 3093 | 70 |
1781000 | 1781000 | 2021-10-04 | Conway | Arkansas | 5029 | 3093 | 42 |
1782370 | 1782370 | 2021-10-04 | Winston | Mississippi | 28159 | 3093 | 91 |
1758294 | 1758294 | 2021-09-27 | Phillips | Arkansas | 5107 | 3093 | 69 |
1755046 | 1755046 | 2021-09-26 | Phillips | Arkansas | 5107 | 3093 | 67 |
1739178 | 1739178 | 2021-09-21 | Washington | Georgia | 13303 | 3093 | 102 |
1733189 | 1733189 | 2021-09-19 | Hart | Kentucky | 21099 | 3093 | 58 |
1729939 | 1729939 | 2021-09-18 | Hart | Kentucky | 21099 | 3093 | 58 |
1726689 | 1726689 | 2021-09-17 | Hart | Kentucky | 21099 | 3093 | 58 |
1668210 | 1668210 | 2021-08-30 | Grayson | Kentucky | 21085 | 3093 | 60 |
1650037 | 1650037 | 2021-08-24 | Dorado | Puerto Rico | 72051 | 3093 | |
1645867 | 1645867 | 2021-08-23 | Grenada | Mississippi | 28043 | 3093 | 92 |
1646988 | 1646988 | 2021-08-23 | Grainger | Tennessee | 47057 | 3093 | 52 |
1641951 | 1641951 | 2021-08-22 | Posey | Indiana | 18129 | 3093 | 37 |
1638701 | 1638701 | 2021-08-21 | Posey | Indiana | 18129 | 3093 | 37 |
1635451 | 1635451 | 2021-08-20 | Posey | Indiana | 18129 | 3093 | 37 |
1628078 | 1628078 | 2021-08-17 | Randolph | West Virginia | 54083 | 3093 | 18 |
1623816 | 1623816 | 2021-08-16 | Perry | Ohio | 39127 | 3093 | 50 |
1612124 | 1612124 | 2021-08-13 | Sevier | Arkansas | 5133 | 3093 | 26 |
1609431 | 1609431 | 2021-08-12 | Greene | Indiana | 18055 | 3093 | 89 |
1606905 | 1606905 | 2021-08-11 | Leake | Mississippi | 28079 | 3093 | 77 |
1599020 | 1599020 | 2021-08-09 | Winston | Alabama | 1133 | 3093 | 73 |
1574295 | 1574295 | 2021-08-01 | Brown | Minnesota | 27015 | 3093 | 40 |
1571047 | 1571047 | 2021-07-31 | Brown | Minnesota | 27015 | 3093 | 40 |
1567799 | 1567799 | 2021-07-30 | Brown | Minnesota | 27015 | 3093 | 40 |
1540969 | 1540969 | 2021-07-22 | Lumpkin | Georgia | 13187 | 3093 | 82 |
1527678 | 1527678 | 2021-07-18 | Unknown | Arkansas | 3093 | 0 | |
1524431 | 1524431 | 2021-07-17 | Unknown | Arkansas | 3093 | 0 | |
1521183 | 1521183 | 2021-07-16 | Unknown | Arkansas | 3093 | 0 | |
1520349 | 1520349 | 2021-07-15 | Overton | Tennessee | 47133 | 3093 | 62 |
1517101 | 1517101 | 2021-07-14 | Overton | Tennessee | 47133 | 3093 | 62 |
1513854 | 1513854 | 2021-07-13 | Overton | Tennessee | 47133 | 3093 | 62 |
1510608 | 1510608 | 2021-07-12 | Overton | Tennessee | 47133 | 3093 | 62 |
1507361 | 1507361 | 2021-07-11 | Overton | Tennessee | 47133 | 3093 | 62 |
1504115 | 1504115 | 2021-07-10 | Overton | Tennessee | 47133 | 3093 | 62 |
1500869 | 1500869 | 2021-07-09 | Overton | Tennessee | 47133 | 3093 | 62 |
1472755 | 1472755 | 2021-07-01 | Gilmer | Georgia | 13123 | 3093 | 89 |
1401437 | 1401437 | 2021-06-09 | Unknown | Georgia | 3093 | 6 | |
1354097 | 1354097 | 2021-05-25 | Orleans | New York | 36073 | 3093 | 83 |
1350851 | 1350851 | 2021-05-24 | Orleans | New York | 36073 | 3093 | 83 |
1325519 | 1325519 | 2021-05-16 | Yankton | South Dakota | 46135 | 3093 | 33 |
1322273 | 1322273 | 2021-05-15 | Yankton | South Dakota | 46135 | 3093 | 33 |
1319027 | 1319027 | 2021-05-14 | Yankton | South Dakota | 46135 | 3093 | 33 |
1265140 | 1265140 | 2021-04-28 | Latah | Idaho | 16057 | 3093 | 10 |
1257051 | 1257051 | 2021-04-25 | Douglas | Oregon | 41019 | 3093 | 68 |
1250410 | 1250410 | 2021-04-23 | Guernsey | Ohio | 39059 | 3093 | 50 |
1245867 | 1245867 | 2021-04-22 | White | Indiana | 18181 | 3093 | 55 |
1247613 | 1247613 | 2021-04-22 | Claiborne | Tennessee | 47025 | 3093 | 73 |
1243926 | 1243926 | 2021-04-21 | Jackson | Ohio | 39079 | 3093 | 51 |
1219087 | 1219087 | 2021-04-13 | Sheridan | Wyoming | 56033 | 3093 | 31 |
1214151 | 1214151 | 2021-04-12 | Lafayette | Missouri | 29107 | 3093 | 56 |
1197833 | 1197833 | 2021-04-07 | Scott | Mississippi | 28123 | 3093 | 72 |
1187734 | 1187734 | 2021-04-04 | Allen | Louisiana | 22003 | 3093 | 91 |
1187885 | 1187885 | 2021-04-04 | Huron | Michigan | 26063 | 3093 | 62 |
1184487 | 1184487 | 2021-04-03 | Allen | Louisiana | 22003 | 3093 | 91 |
1184638 | 1184638 | 2021-04-03 | Huron | Michigan | 26063 | 3093 | 62 |
1181240 | 1181240 | 2021-04-02 | Allen | Louisiana | 22003 | 3093 | 91 |
1177993 | 1177993 | 2021-04-01 | Allen | Louisiana | 22003 | 3093 | 91 |
1175694 | 1175694 | 2021-03-31 | Champaign | Ohio | 39021 | 3093 | 53 |
1171499 | 1171499 | 2021-03-30 | Allen | Louisiana | 22003 | 3093 | 91 |
1128835 | 1128835 | 2021-03-17 | Perry | Illinois | 17145 | 3093 | 68 |
1091432 | 1091432 | 2021-03-05 | Woodward | Oklahoma | 40153 | 3093 | 18 |
1068635 | 1068635 | 2021-02-26 | Adair | Oklahoma | 40001 | 3093 | 24 |
1060476 | 1060476 | 2021-02-24 | Liberty | Georgia | 13179 | 3093 | 50 |
1062571 | 1062571 | 2021-02-24 | Lauderdale | Tennessee | 47097 | 3093 | 42 |
1033637 | 1033637 | 2021-02-15 | Upshur | Texas | 48459 | 3093 | 54 |
1028802 | 1028802 | 2021-02-14 | Delta | Michigan | 26041 | 3093 | 84 |
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);