ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where cases = 2391 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Virginia 20
- Louisiana 10
- Minnesota 10
- Ohio 10
- Texas 10
- Iowa 9
- Missouri 9
- Kentucky 8
- Alabama 7
- Indiana 7
- Michigan 7
- Mississippi 7
- Puerto Rico 6
- Utah 6
- Arkansas 5
- California 5
- Illinois 5
- New York 5
- South Carolina 5
- Washington 4
- West Virginia 4
- Wisconsin 4
- Colorado 3
- Idaho 3
- Kansas 3
- North Carolina 3
- South Dakota 3
- Hawaii 2
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467600 | 2467600 | 2022-05-03 | Washington | Idaho | 16087 | 2391 | 57 |
2469769 | 2469769 | 2022-05-03 | La Salle | Texas | 48283 | 2391 | 48 |
2464345 | 2464345 | 2022-05-02 | Washington | Idaho | 16087 | 2391 | 57 |
2369864 | 2369864 | 2022-04-03 | Towns | Georgia | 13281 | 2391 | 107 |
2366611 | 2366611 | 2022-04-02 | Towns | Georgia | 13281 | 2391 | 107 |
2363358 | 2363358 | 2022-04-01 | Towns | Georgia | 13281 | 2391 | 107 |
2360104 | 2360104 | 2022-03-31 | Towns | Georgia | 13281 | 2391 | 107 |
2338416 | 2338416 | 2022-03-24 | Wayne | Missouri | 29223 | 2391 | 51 |
2271642 | 2271642 | 2022-03-03 | Ritchie | West Virginia | 54085 | 2391 | 30 |
2239037 | 2239037 | 2022-02-21 | Sussex | Virginia | 51183 | 2391 | 37 |
2219231 | 2219231 | 2022-02-15 | Jim Hogg | Texas | 48247 | 2391 | 20 |
2194777 | 2194777 | 2022-02-08 | Lee | Kentucky | 21129 | 2391 | 44 |
2179103 | 2179103 | 2022-02-03 | Richland | Montana | 30083 | 2391 | 30 |
2173916 | 2173916 | 2022-02-01 | Franklin city | Virginia | 51620 | 2391 | 43 |
2167583 | 2167583 | 2022-01-30 | Summers | West Virginia | 54089 | 2391 | 43 |
2131069 | 2131069 | 2022-01-19 | Calhoun | South Carolina | 45017 | 2391 | 54 |
2128281 | 2128281 | 2022-01-18 | Juab | Utah | 49023 | 2391 | 21 |
2125029 | 2125029 | 2022-01-17 | Juab | Utah | 49023 | 2391 | 21 |
2121777 | 2121777 | 2022-01-16 | Juab | Utah | 49023 | 2391 | 21 |
2118525 | 2118525 | 2022-01-15 | Juab | Utah | 49023 | 2391 | 21 |
2114389 | 2114389 | 2022-01-14 | Barnes | North Dakota | 38003 | 2391 | 41 |
2115273 | 2115273 | 2022-01-14 | Juab | Utah | 49023 | 2391 | 21 |
2111787 | 2111787 | 2022-01-13 | Camp | Texas | 48063 | 2391 | 69 |
2100715 | 2100715 | 2022-01-10 | Chippewa | Minnesota | 27023 | 2391 | 43 |
2085810 | 2085810 | 2022-01-05 | Eastland | Texas | 48133 | 2391 | 90 |
2077045 | 2077045 | 2022-01-03 | Dade | Georgia | 13083 | 2391 | 22 |
2077746 | 2077746 | 2022-01-03 | Caldwell | Louisiana | 22021 | 2391 | 42 |
2079846 | 2079846 | 2022-01-03 | Converse | Wyoming | 56009 | 2391 | 48 |
2073794 | 2073794 | 2022-01-02 | Dade | Georgia | 13083 | 2391 | 22 |
2076368 | 2076368 | 2022-01-02 | Martinsville city | Virginia | 51690 | 2391 | 100 |
2070543 | 2070543 | 2022-01-01 | Dade | Georgia | 13083 | 2391 | 22 |
2073117 | 2073117 | 2022-01-01 | Martinsville city | Virginia | 51690 | 2391 | 100 |
2067292 | 2067292 | 2021-12-31 | Dade | Georgia | 13083 | 2391 | 22 |
2069866 | 2069866 | 2021-12-31 | Martinsville city | Virginia | 51690 | 2391 | 100 |
2065501 | 2065501 | 2021-12-30 | Schuyler | New York | 36097 | 2391 | 23 |
2062456 | 2062456 | 2021-12-29 | Harrison | Ohio | 39067 | 2391 | 58 |
2062483 | 2062483 | 2021-12-29 | Noble | Ohio | 39121 | 2391 | 50 |
2058594 | 2058594 | 2021-12-28 | Tallahatchie | Mississippi | 28135 | 2391 | 53 |
2049706 | 2049706 | 2021-12-25 | Cabo Rojo | Puerto Rico | 72023 | 2391 | |
2032849 | 2032849 | 2021-12-20 | Otoe | Nebraska | 31131 | 2391 | 16 |
2030339 | 2030339 | 2021-12-19 | Clay | South Dakota | 46027 | 2391 | 17 |
2027088 | 2027088 | 2021-12-18 | Clay | South Dakota | 46027 | 2391 | 17 |
2023837 | 2023837 | 2021-12-17 | Clay | South Dakota | 46027 | 2391 | 17 |
2021041 | 2021041 | 2021-12-16 | Alleghany | Virginia | 51005 | 2391 | 85 |
2009701 | 2009701 | 2021-12-13 | Cottonwood | Minnesota | 27033 | 2391 | 33 |
2011251 | 2011251 | 2021-12-13 | Millard | Utah | 49027 | 2391 | 31 |
2007779 | 2007779 | 2021-12-12 | Comanche | Texas | 48093 | 2391 | 66 |
1994222 | 1994222 | 2021-12-08 | Monroe | Ohio | 39111 | 2391 | 61 |
1985757 | 1985757 | 2021-12-06 | Marion | Arkansas | 5089 | 2391 | 63 |
1987168 | 1987168 | 2021-12-06 | Mississippi | Missouri | 29133 | 2391 | 49 |
1952824 | 1952824 | 2021-11-25 | Giles | Virginia | 51071 | 2391 | 32 |
1941182 | 1941182 | 2021-11-22 | Monroe | Kentucky | 21171 | 2391 | 64 |
1929149 | 1929149 | 2021-11-18 | Walsh | North Dakota | 38099 | 2391 | 29 |
1921378 | 1921378 | 2021-11-16 | Tipton | Indiana | 18159 | 2391 | 66 |
1906109 | 1906109 | 2021-11-11 | York | Nebraska | 31185 | 2391 | 19 |
1903965 | 1903965 | 2021-11-10 | Wilbarger | Texas | 48487 | 2391 | 62 |
1900715 | 1900715 | 2021-11-09 | Wilbarger | Texas | 48487 | 2391 | 62 |
1891546 | 1891546 | 2021-11-07 | Inyo | California | 6027 | 2391 | 41 |
1888296 | 1888296 | 2021-11-06 | Inyo | California | 6027 | 2391 | 41 |
1885046 | 1885046 | 2021-11-05 | Inyo | California | 6027 | 2391 | 41 |
1879844 | 1879844 | 2021-11-03 | Yalobusha | Mississippi | 28161 | 2391 | 47 |
1880733 | 1880733 | 2021-11-03 | Naranjito | Puerto Rico | 72105 | 2391 | |
1875935 | 1875935 | 2021-11-02 | Hamilton | Iowa | 19079 | 2391 | 56 |
1872686 | 1872686 | 2021-11-01 | Hamilton | Iowa | 19079 | 2391 | 56 |
1869437 | 1869437 | 2021-10-31 | Hamilton | Iowa | 19079 | 2391 | 56 |
1866188 | 1866188 | 2021-10-30 | Hamilton | Iowa | 19079 | 2391 | 56 |
1862939 | 1862939 | 2021-10-29 | Hamilton | Iowa | 19079 | 2391 | 56 |
1859690 | 1859690 | 2021-10-28 | Hamilton | Iowa | 19079 | 2391 | 56 |
1856441 | 1856441 | 2021-10-27 | Hamilton | Iowa | 19079 | 2391 | 56 |
1830925 | 1830925 | 2021-10-19 | Roscommon | Michigan | 26143 | 2391 | 62 |
1827676 | 1827676 | 2021-10-18 | Roscommon | Michigan | 26143 | 2391 | 62 |
1787777 | 1787777 | 2021-10-06 | Brooks | Georgia | 13027 | 2391 | 65 |
1761398 | 1761398 | 2021-09-28 | Crenshaw | Alabama | 1041 | 2391 | 71 |
1755275 | 1755275 | 2021-09-26 | Bacon | Georgia | 13005 | 2391 | 51 |
1757328 | 1757328 | 2021-09-26 | Lee | South Carolina | 45061 | 2391 | 68 |
1752027 | 1752027 | 2021-09-25 | Bacon | Georgia | 13005 | 2391 | 51 |
1754080 | 1754080 | 2021-09-25 | Lee | South Carolina | 45061 | 2391 | 68 |
1748778 | 1748778 | 2021-09-24 | Bacon | Georgia | 13005 | 2391 | 51 |
1750832 | 1750832 | 2021-09-24 | Lee | South Carolina | 45061 | 2391 | 68 |
1741653 | 1741653 | 2021-09-21 | Nottoway | Virginia | 51135 | 2391 | 58 |
1709464 | 1709464 | 2021-09-12 | Washington | Alabama | 1129 | 2391 | 43 |
1705202 | 1705202 | 2021-09-10 | Juniata | Pennsylvania | 42067 | 2391 | 94 |
1705272 | 1705272 | 2021-09-10 | Isabela | Puerto Rico | 72071 | 2391 | |
1702351 | 1702351 | 2021-09-09 | Falls | Texas | 48145 | 2391 | 36 |
1699102 | 1699102 | 2021-09-08 | Falls | Texas | 48145 | 2391 | 36 |
1673949 | 1673949 | 2021-09-01 | Montezuma | Colorado | 8083 | 2391 | 29 |
1670353 | 1670353 | 2021-08-30 | Langlade | Wisconsin | 55067 | 2391 | 51 |
1657050 | 1657050 | 2021-08-26 | Young | Texas | 48503 | 2391 | 46 |
1657147 | 1657147 | 2021-08-26 | Fredericksburg city | Virginia | 51630 | 2391 | 25 |
1626436 | 1626436 | 2021-08-17 | Andrew | Missouri | 29003 | 2391 | 23 |
1608832 | 1608832 | 2021-08-12 | Drew | Arkansas | 5043 | 2391 | 49 |
1600324 | 1600324 | 2021-08-09 | Martin | Minnesota | 27091 | 2391 | 33 |
1595875 | 1595875 | 2021-08-08 | Randolph | Arkansas | 5121 | 2391 | 48 |
1586149 | 1586149 | 2021-08-05 | Colusa | California | 6011 | 2391 | 18 |
1583394 | 1583394 | 2021-08-04 | Shelby | Illinois | 17173 | 2391 | 41 |
1550282 | 1550282 | 2021-07-25 | Pickens | Alabama | 1107 | 2391 | 62 |
1547035 | 1547035 | 2021-07-24 | Pickens | Alabama | 1107 | 2391 | 62 |
1537538 | 1537538 | 2021-07-21 | Routt | Colorado | 8107 | 2391 | 21 |
1534495 | 1534495 | 2021-07-20 | Pike | Georgia | 13231 | 2391 | 44 |
1528762 | 1528762 | 2021-07-18 | Emmet | Michigan | 26047 | 2391 | 43 |
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);