ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
207 rows where cases = 2479 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 19
- Texas 19
- Puerto Rico 14
- Virginia 13
- Georgia 12
- Arkansas 9
- Iowa 9
- Colorado 7
- Kansas 7
- Mississippi 7
- Ohio 7
- Idaho 6
- West Virginia 6
- Alabama 5
- Arizona 5
- Illinois 5
- Indiana 5
- Minnesota 5
- Alaska 4
- Tennessee 4
- Florida 3
- Michigan 3
- Missouri 3
- Nebraska 3
- North Carolina 3
- Pennsylvania 3
- Washington 3
- Maryland 2
- New Hampshire 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500869 | 2500869 | 2022-05-13 | Mackinac | Michigan | 26097 | 2479 | 31 |
2497611 | 2497611 | 2022-05-12 | Mackinac | Michigan | 26097 | 2479 | 31 |
2494353 | 2494353 | 2022-05-11 | Mackinac | Michigan | 26097 | 2479 | 31 |
2484359 | 2484359 | 2022-05-08 | Livingston | Kentucky | 21139 | 2479 | 61 |
2481101 | 2481101 | 2022-05-07 | Livingston | Kentucky | 21139 | 2479 | 61 |
2477843 | 2477843 | 2022-05-06 | Livingston | Kentucky | 21139 | 2479 | 61 |
2474585 | 2474585 | 2022-05-05 | Livingston | Kentucky | 21139 | 2479 | 61 |
2471328 | 2471328 | 2022-05-04 | Livingston | Kentucky | 21139 | 2479 | 61 |
2468072 | 2468072 | 2022-05-03 | Livingston | Kentucky | 21139 | 2479 | 61 |
2464817 | 2464817 | 2022-05-02 | Livingston | Kentucky | 21139 | 2479 | 61 |
2401004 | 2401004 | 2022-04-12 | Lajas | Puerto Rico | 72079 | 2479 | |
2397749 | 2397749 | 2022-04-11 | Lajas | Puerto Rico | 72079 | 2479 | |
2394494 | 2394494 | 2022-04-10 | Lajas | Puerto Rico | 72079 | 2479 | |
2339893 | 2339893 | 2022-03-24 | Pend Oreille | Washington | 53051 | 2479 | 36 |
2336640 | 2336640 | 2022-03-23 | Pend Oreille | Washington | 53051 | 2479 | 36 |
2278507 | 2278507 | 2022-03-06 | Bent | Colorado | 8011 | 2479 | 47 |
2275254 | 2275254 | 2022-03-05 | Bent | Colorado | 8011 | 2479 | 47 |
2272001 | 2272001 | 2022-03-04 | Bent | Colorado | 8011 | 2479 | 47 |
2265409 | 2265409 | 2022-03-02 | Perry | Arkansas | 5105 | 2479 | 32 |
2261542 | 2261542 | 2022-02-28 | Morris | Texas | 48343 | 2479 | 68 |
2258291 | 2258291 | 2022-02-27 | Morris | Texas | 48343 | 2479 | 68 |
2194006 | 2194006 | 2022-02-08 | Prowers | Colorado | 8099 | 2479 | 45 |
2194308 | 2194308 | 2022-02-08 | Shoshone | Idaho | 16079 | 2479 | 71 |
2195541 | 2195541 | 2022-02-08 | Los Alamos | New Mexico | 35028 | 2479 | 12 |
2178402 | 2178402 | 2022-02-03 | Marshall | Kansas | 20117 | 2479 | 39 |
2175149 | 2175149 | 2022-02-02 | Marshall | Kansas | 20117 | 2479 | 39 |
2151552 | 2151552 | 2022-01-26 | Fulton | Arkansas | 5049 | 2479 | 80 |
2153007 | 2153007 | 2022-01-26 | Ripley | Missouri | 29181 | 2479 | 53 |
2149632 | 2149632 | 2022-01-25 | Noxubee | Mississippi | 28103 | 2479 | 46 |
2132973 | 2132973 | 2022-01-20 | Martin | Kentucky | 21159 | 2479 | 43 |
2134040 | 2134040 | 2022-01-20 | Vinton | Ohio | 39163 | 2479 | 45 |
2086155 | 2086155 | 2022-01-05 | Rockbridge | Virginia | 51163 | 2479 | 71 |
2078710 | 2078710 | 2022-01-03 | Harrison | Ohio | 39067 | 2479 | 58 |
2079025 | 2079025 | 2022-01-03 | Yauco | Puerto Rico | 72153 | 2479 | |
2065994 | 2065994 | 2021-12-30 | Morovis | Puerto Rico | 72101 | 2479 | |
2060764 | 2060764 | 2021-12-29 | Brooks | Georgia | 13027 | 2479 | 75 |
2061704 | 2061704 | 2021-12-29 | Cottonwood | Minnesota | 27033 | 2479 | 34 |
2056214 | 2056214 | 2021-12-27 | Cidra | Puerto Rico | 72041 | 2479 | |
2034093 | 2034093 | 2021-12-20 | Greene | Virginia | 51079 | 2479 | 45 |
2015521 | 2015521 | 2021-12-15 | Massac | Illinois | 17127 | 2479 | 59 |
2013589 | 2013589 | 2021-12-14 | Polk | North Carolina | 37149 | 2479 | 49 |
1997753 | 1997753 | 2021-12-09 | San Lorenzo | Puerto Rico | 72129 | 2479 | |
1994502 | 1994502 | 2021-12-08 | San Lorenzo | Puerto Rico | 72129 | 2479 | |
1986689 | 1986689 | 2021-12-06 | Monroe | Kentucky | 21171 | 2479 | 65 |
1971394 | 1971394 | 2021-12-01 | Ramsey | North Dakota | 38071 | 2479 | 39 |
1963635 | 1963635 | 2021-11-29 | Tipton | Indiana | 18159 | 2479 | 68 |
1963914 | 1963914 | 2021-11-29 | Larue | Kentucky | 21123 | 2479 | 53 |
1964249 | 1964249 | 2021-11-29 | Sibley | Minnesota | 27143 | 2479 | 17 |
1920794 | 1920794 | 2021-11-16 | Inyo | California | 6027 | 2479 | 42 |
1921612 | 1921612 | 2021-11-16 | Caldwell | Kentucky | 21033 | 2479 | 50 |
1895988 | 1895988 | 2021-11-08 | Renville | Minnesota | 27129 | 2479 | 51 |
1888109 | 1888109 | 2021-11-06 | Clay | Alabama | 1027 | 2479 | 70 |
1890452 | 1890452 | 2021-11-06 | Corozal | Puerto Rico | 72047 | 2479 | |
1887202 | 1887202 | 2021-11-05 | Corozal | Puerto Rico | 72047 | 2479 | |
1875995 | 1875995 | 2021-11-02 | Wright | Iowa | 19197 | 2479 | 45 |
1876144 | 1876144 | 2021-11-02 | Green | Kentucky | 21087 | 2479 | 34 |
1872004 | 1872004 | 2021-11-01 | Madison | Arkansas | 5087 | 2479 | 40 |
1872746 | 1872746 | 2021-11-01 | Wright | Iowa | 19197 | 2479 | 45 |
1872895 | 1872895 | 2021-11-01 | Green | Kentucky | 21087 | 2479 | 34 |
1868755 | 1868755 | 2021-10-31 | Madison | Arkansas | 5087 | 2479 | 40 |
1868847 | 1868847 | 2021-10-31 | Alamosa | Colorado | 8003 | 2479 | 44 |
1869497 | 1869497 | 2021-10-31 | Wright | Iowa | 19197 | 2479 | 45 |
1865506 | 1865506 | 2021-10-30 | Madison | Arkansas | 5087 | 2479 | 39 |
1865598 | 1865598 | 2021-10-30 | Alamosa | Colorado | 8003 | 2479 | 44 |
1866248 | 1866248 | 2021-10-30 | Wright | Iowa | 19197 | 2479 | 45 |
1862349 | 1862349 | 2021-10-29 | Alamosa | Colorado | 8003 | 2479 | 44 |
1862999 | 1862999 | 2021-10-29 | Wright | Iowa | 19197 | 2479 | 45 |
1863304 | 1863304 | 2021-10-29 | Waldo | Maine | 23027 | 2479 | 33 |
1859750 | 1859750 | 2021-10-28 | Wright | Iowa | 19197 | 2479 | 45 |
1856501 | 1856501 | 2021-10-27 | Wright | Iowa | 19197 | 2479 | 45 |
1852370 | 1852370 | 2021-10-26 | Cleburne | Alabama | 1029 | 2479 | 60 |
1845935 | 1845935 | 2021-10-24 | Kodiak Island Borough | Alaska | 2150 | 2479 | 7 |
1842685 | 1842685 | 2021-10-23 | Kodiak Island Borough | Alaska | 2150 | 2479 | 7 |
1839436 | 1839436 | 2021-10-22 | Kodiak Island Borough | Alaska | 2150 | 2479 | 7 |
1836009 | 1836009 | 2021-10-20 | Wetzel | West Virginia | 54103 | 2479 | 50 |
1832820 | 1832820 | 2021-10-19 | Sawyer | Wisconsin | 55113 | 2479 | 31 |
1810510 | 1810510 | 2021-10-13 | Bacon | Georgia | 13005 | 2479 | 55 |
1806951 | 1806951 | 2021-10-12 | North Slope Borough | Alaska | 2185 | 2479 | 5 |
1801331 | 1801331 | 2021-10-10 | Neosho | Kansas | 20133 | 2479 | 49 |
1798082 | 1798082 | 2021-10-09 | Neosho | Kansas | 20133 | 2479 | 49 |
1794833 | 1794833 | 2021-10-08 | Neosho | Kansas | 20133 | 2479 | 49 |
1793200 | 1793200 | 2021-10-07 | Lewis | Tennessee | 47101 | 2479 | 37 |
1793575 | 1793575 | 2021-10-07 | Colonial Heights city | Virginia | 51570 | 2479 | 64 |
1785064 | 1785064 | 2021-10-05 | Jefferson | Kansas | 20087 | 2479 | 46 |
1781815 | 1781815 | 2021-10-04 | Jefferson | Kansas | 20087 | 2479 | 46 |
1778239 | 1778239 | 2021-10-03 | Clay | Illinois | 17025 | 2479 | 54 |
1780746 | 1780746 | 2021-10-03 | Lincoln | West Virginia | 54043 | 2479 | 35 |
1774989 | 1774989 | 2021-10-02 | Clay | Illinois | 17025 | 2479 | 54 |
1771739 | 1771739 | 2021-10-01 | Clay | Illinois | 17025 | 2479 | 54 |
1767401 | 1767401 | 2021-09-29 | Llano | Texas | 48299 | 2479 | 67 |
1744254 | 1744254 | 2021-09-22 | Isabela | Puerto Rico | 72071 | 2479 | |
1717450 | 1717450 | 2021-09-14 | Livingston | Missouri | 29117 | 2479 | 61 |
1712823 | 1712823 | 2021-09-13 | Sharp | Arkansas | 5135 | 2479 | 59 |
1715568 | 1715568 | 2021-09-13 | St. Croix | Virgin Islands | 78010 | 2479 | 22 |
1710403 | 1710403 | 2021-09-12 | Anderson | Kentucky | 21005 | 2479 | 31 |
1707156 | 1707156 | 2021-09-11 | Anderson | Kentucky | 21005 | 2479 | 31 |
1703908 | 1703908 | 2021-09-10 | Anderson | Kentucky | 21005 | 2479 | 31 |
1702679 | 1702679 | 2021-09-09 | Prince Edward | Virginia | 51147 | 2479 | 40 |
1659011 | 1659011 | 2021-08-27 | Ray | Missouri | 29177 | 2479 | 39 |
1654043 | 1654043 | 2021-08-25 | Jackson | West Virginia | 54035 | 2479 | 64 |
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);