ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 3361 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Arkansas 10
- Georgia 9
- Ohio 8
- Louisiana 6
- Minnesota 6
- New Mexico 6
- Wisconsin 6
- North Carolina 5
- Indiana 4
- Pennsylvania 4
- Tennessee 4
- West Virginia 4
- Alabama 3
- Idaho 3
- Kentucky 3
- Nebraska 3
- Puerto Rico 3
- South Carolina 3
- Illinois 2
- Maine 2
- Mississippi 2
- Missouri 2
- Oregon 2
- Colorado 1
- District of Columbia 1
- Florida 1
- Hawaii 1
- Maryland 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501936 | 2501936 | 2022-05-13 | Comerio | Puerto Rico | 72045 | 3361 | |
2466907 | 2466907 | 2022-05-02 | Bayfield | Wisconsin | 55007 | 3361 | 40 |
2446450 | 2446450 | 2022-04-26 | Curry | Oregon | 41015 | 3361 | 54 |
2351722 | 2351722 | 2022-03-28 | Yates | New York | 36123 | 3361 | 39 |
2266274 | 2266274 | 2022-03-02 | Clinton | Kentucky | 21053 | 3361 | 42 |
2266996 | 2266996 | 2022-03-02 | Seward | Nebraska | 31159 | 3361 | 41 |
2263745 | 2263745 | 2022-03-01 | Seward | Nebraska | 31159 | 3361 | 41 |
2264849 | 2264849 | 2022-03-01 | Tyler | Texas | 48457 | 3361 | 83 |
2214462 | 2214462 | 2022-02-14 | Dukes | Massachusetts | 25007 | 3361 | 0 |
2192577 | 2192577 | 2022-02-07 | Monroe | Ohio | 39111 | 3361 | 69 |
2145422 | 2145422 | 2022-01-24 | Rabun | Georgia | 13241 | 3361 | 84 |
2144289 | 2144289 | 2022-01-23 | Aransas | Texas | 48007 | 3361 | 69 |
2144794 | 2144794 | 2022-01-23 | Monroe | West Virginia | 54063 | 3361 | 33 |
2144870 | 2144870 | 2022-01-23 | Richland | Wisconsin | 55103 | 3361 | 38 |
2141615 | 2141615 | 2022-01-22 | Richland | Wisconsin | 55103 | 3361 | 38 |
2138359 | 2138359 | 2022-01-21 | Richland | Wisconsin | 55103 | 3361 | 38 |
2133093 | 2133093 | 2022-01-20 | Sagadahoc | Maine | 23023 | 3361 | 24 |
2119005 | 2119005 | 2022-01-16 | Clay | Arkansas | 5021 | 3361 | 77 |
2121763 | 2121763 | 2022-01-16 | Young | Texas | 48503 | 3361 | 75 |
2115120 | 2115120 | 2022-01-14 | Houston | Texas | 48225 | 3361 | 91 |
2108701 | 2108701 | 2022-01-12 | Robertson | Texas | 48395 | 3361 | 68 |
2101670 | 2101670 | 2022-01-10 | Fulton | Pennsylvania | 42057 | 3361 | 51 |
2096716 | 2096716 | 2022-01-09 | Minidoka | Idaho | 16067 | 3361 | 54 |
2093464 | 2093464 | 2022-01-08 | Minidoka | Idaho | 16067 | 3361 | 54 |
2053364 | 2053364 | 2021-12-26 | Jones | Texas | 48253 | 3361 | 79 |
2050114 | 2050114 | 2021-12-25 | Jones | Texas | 48253 | 3361 | 79 |
2046864 | 2046864 | 2021-12-24 | Jones | Texas | 48253 | 3361 | 79 |
2043614 | 2043614 | 2021-12-23 | Jones | Texas | 48253 | 3361 | 79 |
2040587 | 2040587 | 2021-12-22 | Fredericksburg city | Virginia | 51630 | 3361 | 27 |
2036978 | 2036978 | 2021-12-21 | Unicoi | Tennessee | 47171 | 3361 | 73 |
2021388 | 2021388 | 2021-12-17 | Fayette | Alabama | 1057 | 3361 | 86 |
1988039 | 1988039 | 2021-12-06 | Fairfield | South Carolina | 45039 | 3361 | 93 |
1941203 | 1941203 | 2021-11-22 | Simpson | Kentucky | 21213 | 3361 | 62 |
1943313 | 1943313 | 2021-11-22 | Vilas | Wisconsin | 55125 | 3361 | 60 |
1936894 | 1936894 | 2021-11-21 | Monroe | Alabama | 1099 | 3361 | 66 |
1922418 | 1922418 | 2021-11-16 | Grant | New Mexico | 35017 | 3361 | 54 |
1902503 | 1902503 | 2021-11-10 | Wabasha | Minnesota | 27157 | 3361 | 8 |
1898627 | 1898627 | 2021-11-09 | Sullivan | Indiana | 18153 | 3361 | 55 |
1899385 | 1899385 | 2021-11-09 | Henry | Missouri | 29083 | 3361 | 51 |
1895218 | 1895218 | 2021-11-08 | Douglas | Illinois | 17041 | 3361 | 44 |
1881768 | 1881768 | 2021-11-04 | Randolph | Arkansas | 5121 | 3361 | 60 |
1859472 | 1859472 | 2021-10-28 | Crawford | Illinois | 17033 | 3361 | 46 |
1784598 | 1784598 | 2021-10-05 | Jones | Georgia | 13169 | 3361 | 83 |
1781037 | 1781037 | 2021-10-04 | Ouachita | Arkansas | 5103 | 3361 | 76 |
1781926 | 1781926 | 2021-10-04 | Hart | Kentucky | 21099 | 3361 | 60 |
1777787 | 1777787 | 2021-10-03 | Ouachita | Arkansas | 5103 | 3361 | 75 |
1779769 | 1779769 | 2021-10-03 | Van Wert | Ohio | 39161 | 3361 | 73 |
1779983 | 1779983 | 2021-10-03 | Dorado | Puerto Rico | 72051 | 3361 | |
1774537 | 1774537 | 2021-10-02 | Ouachita | Arkansas | 5103 | 3361 | 75 |
1766871 | 1766871 | 2021-09-29 | Jefferson | Oregon | 41031 | 3361 | 49 |
1735540 | 1735540 | 2021-09-20 | Logan | Arkansas | 5083 | 3361 | 34 |
1716014 | 1716014 | 2021-09-14 | Cleburne | Arkansas | 5023 | 3361 | 85 |
1717259 | 1717259 | 2021-09-14 | Le Sueur | Minnesota | 27079 | 3361 | 29 |
1707372 | 1707372 | 2021-09-11 | Queen Anne's | Maryland | 24035 | 3361 | 59 |
1644935 | 1644935 | 2021-08-23 | Pierce | Georgia | 13229 | 3361 | 65 |
1629613 | 1629613 | 2021-08-18 | Coahoma | Mississippi | 28027 | 3361 | 86 |
1626097 | 1626097 | 2021-08-17 | Plaquemines | Louisiana | 22075 | 3361 | 30 |
1604162 | 1604162 | 2021-08-10 | Macon | North Carolina | 37113 | 3361 | 41 |
1586075 | 1586075 | 2021-08-05 | Carroll | Arkansas | 5015 | 3361 | 52 |
1584085 | 1584085 | 2021-08-04 | Nicollet | Minnesota | 27103 | 3361 | 45 |
1560454 | 1560454 | 2021-07-28 | Madison | Georgia | 13195 | 3361 | 56 |
1561151 | 1561151 | 2021-07-28 | West Baton Rouge | Louisiana | 22121 | 3361 | 63 |
1556866 | 1556866 | 2021-07-27 | Jackson | Arkansas | 5067 | 3361 | 38 |
1535170 | 1535170 | 2021-07-20 | Vernon | Louisiana | 22115 | 3361 | 107 |
1490828 | 1490828 | 2021-07-06 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1487581 | 1487581 | 2021-07-05 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1484334 | 1484334 | 2021-07-04 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1405976 | 1405976 | 2021-06-10 | Luna | New Mexico | 35029 | 3361 | 92 |
1392993 | 1392993 | 2021-06-06 | Luna | New Mexico | 35029 | 3361 | 92 |
1389748 | 1389748 | 2021-06-05 | Luna | New Mexico | 35029 | 3361 | 92 |
1386503 | 1386503 | 2021-06-04 | Luna | New Mexico | 35029 | 3361 | 92 |
1277403 | 1277403 | 2021-05-01 | Fayette | West Virginia | 54019 | 3361 | 75 |
1277418 | 1277418 | 2021-05-01 | Marshall | West Virginia | 54051 | 3361 | 76 |
1239107 | 1239107 | 2021-04-20 | Toombs | Georgia | 13279 | 3361 | 110 |
1222629 | 1222629 | 2021-04-15 | Montrose | Colorado | 8085 | 3361 | 57 |
1180653 | 1180653 | 2021-04-02 | Upson | Georgia | 13293 | 3361 | 123 |
1146844 | 1146844 | 2021-03-22 | Marion | South Carolina | 45067 | 3361 | 101 |
1132114 | 1132114 | 2021-03-18 | Adams | Indiana | 18001 | 3361 | 51 |
1115718 | 1115718 | 2021-03-13 | Wayne | Georgia | 13305 | 3361 | 79 |
1113305 | 1113305 | 2021-03-12 | Morrison | Minnesota | 27097 | 3361 | 52 |
1103745 | 1103745 | 2021-03-09 | Lawrence | Missouri | 29109 | 3361 | 77 |
1077496 | 1077496 | 2021-03-01 | Hillsdale | Michigan | 26059 | 3361 | 73 |
1079294 | 1079294 | 2021-03-01 | Grays Harbor | Washington | 53027 | 3361 | 46 |
1058124 | 1058124 | 2021-02-23 | McLeod | Minnesota | 27085 | 3361 | 49 |
1058825 | 1058825 | 2021-02-23 | Clinton | Ohio | 39027 | 3361 | 62 |
1046624 | 1046624 | 2021-02-19 | Waller | Texas | 48473 | 3361 | 38 |
1039110 | 1039110 | 2021-02-17 | Rio Arriba | New Mexico | 35039 | 3361 | 62 |
1036017 | 1036017 | 2021-02-16 | Scotland | North Carolina | 37165 | 3361 | 71 |
1001753 | 1001753 | 2021-02-06 | St. Francis | Arkansas | 5123 | 3361 | 35 |
987293 | 987293 | 2021-02-01 | Haywood | North Carolina | 37087 | 3361 | 76 |
985311 | 985311 | 2021-01-31 | Trempealeau | Wisconsin | 55121 | 3361 | 38 |
978736 | 978736 | 2021-01-29 | Ohio | West Virginia | 54069 | 3361 | 63 |
967950 | 967950 | 2021-01-26 | Defiance | Ohio | 39039 | 3361 | 88 |
964822 | 964822 | 2021-01-25 | McCurtain | Oklahoma | 40089 | 3361 | 57 |
960126 | 960126 | 2021-01-24 | Knox | Indiana | 18083 | 3361 | 39 |
936674 | 936674 | 2021-01-17 | Chilton | Alabama | 1021 | 3361 | 65 |
934599 | 934599 | 2021-01-16 | Webster | Louisiana | 22119 | 3361 | 74 |
931354 | 931354 | 2021-01-15 | Webster | Louisiana | 22119 | 3361 | 74 |
899683 | 899683 | 2021-01-05 | McDowell | North Carolina | 37111 | 3361 | 39 |
899849 | 899849 | 2021-01-05 | Putnam | Ohio | 39137 | 3361 | 67 |
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);