ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
385 rows where cases = 1190 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 43
- Georgia 29
- Texas 21
- Kentucky 16
- Kansas 15
- Virginia 15
- Indiana 14
- Missouri 14
- Tennessee 14
- Minnesota 12
- Mississippi 11
- North Carolina 11
- South Dakota 11
- West Virginia 11
- Colorado 10
- Illinois 10
- Puerto Rico 10
- Montana 9
- Alabama 8
- Arkansas 8
- Michigan 7
- Pennsylvania 7
- Idaho 6
- Iowa 6
- California 5
- Florida 5
- Louisiana 5
- Ohio 5
- Oregon 5
- New Jersey 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491521 | 2491521 | 2022-05-10 | Howard | Nebraska | 31093 | 1190 | 15 |
2488263 | 2488263 | 2022-05-09 | Howard | Nebraska | 31093 | 1190 | 15 |
2485006 | 2485006 | 2022-05-08 | Howard | Nebraska | 31093 | 1190 | 15 |
2481748 | 2481748 | 2022-05-07 | Howard | Nebraska | 31093 | 1190 | 15 |
2478490 | 2478490 | 2022-05-06 | Howard | Nebraska | 31093 | 1190 | 15 |
2475232 | 2475232 | 2022-05-05 | Howard | Nebraska | 31093 | 1190 | 15 |
2471975 | 2471975 | 2022-05-04 | Howard | Nebraska | 31093 | 1190 | 15 |
2468719 | 2468719 | 2022-05-03 | Howard | Nebraska | 31093 | 1190 | 15 |
2465463 | 2465463 | 2022-05-02 | Howard | Nebraska | 31093 | 1190 | 15 |
2462208 | 2462208 | 2022-05-01 | Howard | Nebraska | 31093 | 1190 | 15 |
2458952 | 2458952 | 2022-04-30 | Howard | Nebraska | 31093 | 1190 | 15 |
2455696 | 2455696 | 2022-04-29 | Howard | Nebraska | 31093 | 1190 | 15 |
2437996 | 2437996 | 2022-04-24 | Saguache | Colorado | 8109 | 1190 | 12 |
2434740 | 2434740 | 2022-04-23 | Saguache | Colorado | 8109 | 1190 | 12 |
2431484 | 2431484 | 2022-04-22 | Saguache | Colorado | 8109 | 1190 | 12 |
2428228 | 2428228 | 2022-04-21 | Saguache | Colorado | 8109 | 1190 | 12 |
2424972 | 2424972 | 2022-04-20 | Saguache | Colorado | 8109 | 1190 | 12 |
2285730 | 2285730 | 2022-03-08 | Ottawa | Kansas | 20143 | 1190 | 16 |
2282478 | 2282478 | 2022-03-07 | Ottawa | Kansas | 20143 | 1190 | 16 |
2256461 | 2256461 | 2022-02-27 | Ottawa | Kansas | 20143 | 1190 | 16 |
2253210 | 2253210 | 2022-02-26 | Ottawa | Kansas | 20143 | 1190 | 16 |
2249959 | 2249959 | 2022-02-25 | Ottawa | Kansas | 20143 | 1190 | 16 |
2246708 | 2246708 | 2022-02-24 | Ottawa | Kansas | 20143 | 1190 | 16 |
2243457 | 2243457 | 2022-02-23 | Ottawa | Kansas | 20143 | 1190 | 16 |
2237120 | 2237120 | 2022-02-21 | Cameron | Louisiana | 22023 | 1190 | 8 |
2216191 | 2216191 | 2022-02-14 | Cumberland | Virginia | 51049 | 1190 | 22 |
2194667 | 2194667 | 2022-02-08 | Meade | Kansas | 20119 | 1190 | 17 |
2191413 | 2191413 | 2022-02-07 | Meade | Kansas | 20119 | 1190 | 17 |
2152750 | 2152750 | 2022-01-26 | Big Stone | Minnesota | 27011 | 1190 | 7 |
2153098 | 2153098 | 2022-01-26 | Burt | Nebraska | 31021 | 1190 | 15 |
2151399 | 2151399 | 2022-01-25 | Crook | Wyoming | 56011 | 1190 | 22 |
2118377 | 2118377 | 2022-01-15 | Jack | Texas | 48237 | 1190 | 23 |
2109615 | 2109615 | 2022-01-13 | Marion | Georgia | 13197 | 1190 | 43 |
2108385 | 2108385 | 2022-01-12 | McCook | South Dakota | 46087 | 1190 | 30 |
2104315 | 2104315 | 2022-01-11 | Clay | Nebraska | 31035 | 1190 | 17 |
2104320 | 2104320 | 2022-01-11 | Dawes | Nebraska | 31045 | 1190 | 21 |
2105225 | 2105225 | 2022-01-11 | Pickett | Tennessee | 47137 | 1190 | 28 |
2101974 | 2101974 | 2022-01-10 | Pickett | Tennessee | 47137 | 1190 | 28 |
2097859 | 2097859 | 2022-01-09 | Nemaha | Nebraska | 31127 | 1190 | 16 |
2098723 | 2098723 | 2022-01-09 | Pickett | Tennessee | 47137 | 1190 | 28 |
2094607 | 2094607 | 2022-01-08 | Nemaha | Nebraska | 31127 | 1190 | 16 |
2095471 | 2095471 | 2022-01-08 | Pickett | Tennessee | 47137 | 1190 | 28 |
2091355 | 2091355 | 2022-01-07 | Nemaha | Nebraska | 31127 | 1190 | 16 |
2092219 | 2092219 | 2022-01-07 | Pickett | Tennessee | 47137 | 1190 | 28 |
2088967 | 2088967 | 2022-01-06 | Pickett | Tennessee | 47137 | 1190 | 28 |
2085716 | 2085716 | 2022-01-05 | Pickett | Tennessee | 47137 | 1190 | 28 |
2082464 | 2082464 | 2022-01-04 | Pickett | Tennessee | 47137 | 1190 | 28 |
2078981 | 2078981 | 2022-01-03 | Hormigueros | Puerto Rico | 72067 | 1190 | |
2057789 | 2057789 | 2021-12-28 | Pulaski | Illinois | 17153 | 1190 | 15 |
2034969 | 2034969 | 2021-12-21 | Brown | Illinois | 17009 | 1190 | 19 |
2036305 | 2036305 | 2021-12-21 | Gates | North Carolina | 37073 | 1190 | 18 |
1992380 | 1992380 | 2021-12-08 | Kit Carson | Colorado | 8063 | 1190 | 24 |
1988269 | 1988269 | 2021-12-06 | Coleman | Texas | 48083 | 1190 | 55 |
1951259 | 1951259 | 2021-11-25 | Wilkin | Minnesota | 27167 | 1190 | 15 |
1948008 | 1948008 | 2021-11-24 | Wilkin | Minnesota | 27167 | 1190 | 15 |
1939921 | 1939921 | 2021-11-21 | Jefferson | Washington | 53031 | 1190 | 17 |
1936671 | 1936671 | 2021-11-20 | Jefferson | Washington | 53031 | 1190 | 17 |
1931882 | 1931882 | 2021-11-19 | Harrison | Missouri | 29081 | 1190 | 22 |
1933421 | 1933421 | 2021-11-19 | Jefferson | Washington | 53031 | 1190 | 17 |
1930093 | 1930093 | 2021-11-18 | Lunenburg | Virginia | 51111 | 1190 | 22 |
1922514 | 1922514 | 2021-11-16 | Camden | North Carolina | 37029 | 1190 | 8 |
1919264 | 1919264 | 2021-11-15 | Camden | North Carolina | 37029 | 1190 | 8 |
1910731 | 1910731 | 2021-11-12 | Pocahontas | West Virginia | 54075 | 1190 | 18 |
1906007 | 1906007 | 2021-11-11 | Stillwater | Montana | 30095 | 1190 | 27 |
1902758 | 1902758 | 2021-11-10 | Stillwater | Montana | 30095 | 1190 | 27 |
1903798 | 1903798 | 2021-11-10 | Floyd | Texas | 48153 | 1190 | 39 |
1900548 | 1900548 | 2021-11-09 | Floyd | Texas | 48153 | 1190 | 39 |
1894683 | 1894683 | 2021-11-08 | Sitka City and Borough | Alaska | 2220 | 1190 | 4 |
1891818 | 1891818 | 2021-11-07 | Jenkins | Georgia | 13165 | 1190 | 58 |
1888197 | 1888197 | 2021-11-06 | Greenlee | Arizona | 4011 | 1190 | 16 |
1888568 | 1888568 | 2021-11-06 | Jenkins | Georgia | 13165 | 1190 | 58 |
1885318 | 1885318 | 2021-11-05 | Jenkins | Georgia | 13165 | 1190 | 58 |
1882069 | 1882069 | 2021-11-04 | Jenkins | Georgia | 13165 | 1190 | 58 |
1878820 | 1878820 | 2021-11-03 | Jenkins | Georgia | 13165 | 1190 | 57 |
1875571 | 1875571 | 2021-11-02 | Jenkins | Georgia | 13165 | 1190 | 57 |
1872322 | 1872322 | 2021-11-01 | Jenkins | Georgia | 13165 | 1190 | 57 |
1869073 | 1869073 | 2021-10-31 | Jenkins | Georgia | 13165 | 1190 | 57 |
1865824 | 1865824 | 2021-10-30 | Jenkins | Georgia | 13165 | 1190 | 57 |
1862575 | 1862575 | 2021-10-29 | Jenkins | Georgia | 13165 | 1190 | 57 |
1859326 | 1859326 | 2021-10-28 | Jenkins | Georgia | 13165 | 1190 | 57 |
1860569 | 1860569 | 2021-10-28 | Holt | Nebraska | 31089 | 1190 | 16 |
1857320 | 1857320 | 2021-10-27 | Holt | Nebraska | 31089 | 1190 | 16 |
1839515 | 1839515 | 2021-10-22 | Monroe | Arkansas | 5095 | 1190 | 24 |
1836266 | 1836266 | 2021-10-21 | Monroe | Arkansas | 5095 | 1190 | 24 |
1833017 | 1833017 | 2021-10-20 | Monroe | Arkansas | 5095 | 1190 | 24 |
1835965 | 1835965 | 2021-10-20 | Clay | West Virginia | 54015 | 1190 | 18 |
1814396 | 1814396 | 2021-10-14 | Cumberland | Kentucky | 21057 | 1190 | 19 |
1815056 | 1815056 | 2021-10-14 | Custer | Nebraska | 31041 | 1190 | 21 |
1811147 | 1811147 | 2021-10-13 | Cumberland | Kentucky | 21057 | 1190 | 19 |
1809631 | 1809631 | 2021-10-12 | La Salle | Texas | 48283 | 1190 | 37 |
1804407 | 1804407 | 2021-10-11 | Warren | Indiana | 18171 | 1190 | 18 |
1793238 | 1793238 | 2021-10-07 | Van Buren | Tennessee | 47175 | 1190 | 26 |
1787898 | 1787898 | 2021-10-06 | Terrell | Georgia | 13273 | 1190 | 56 |
1784614 | 1784614 | 2021-10-05 | Miller | Georgia | 13201 | 1190 | 20 |
1784649 | 1784649 | 2021-10-05 | Terrell | Georgia | 13273 | 1190 | 56 |
1761238 | 1761238 | 2021-09-27 | Gilmer | West Virginia | 54021 | 1190 | 7 |
1749920 | 1749920 | 2021-09-24 | Gentry | Missouri | 29075 | 1190 | 24 |
1748282 | 1748282 | 2021-09-23 | Tyler | West Virginia | 54095 | 1190 | 14 |
1728524 | 1728524 | 2021-09-17 | Emery | Utah | 49015 | 1190 | 12 |
1725110 | 1725110 | 2021-09-16 | Hamilton | Texas | 48193 | 1190 | 29 |
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);