ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 2571 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 20
- Illinois 13
- Virginia 12
- Georgia 10
- Missouri 10
- North Dakota 8
- Oklahoma 8
- Minnesota 7
- Tennessee 7
- Indiana 6
- Nebraska 6
- North Carolina 6
- Puerto Rico 6
- Colorado 5
- Arkansas 4
- Kansas 4
- Kentucky 4
- Maine 4
- Mississippi 4
- New Hampshire 4
- Louisiana 3
- Ohio 3
- South Carolina 3
- Texas 3
- West Virginia 3
- Wisconsin 3
- Alabama 2
- Arizona 2
- California 2
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479164 | 2479164 | 2022-05-06 | Patillas | Puerto Rico | 72109 | 2571 | |
2475551 | 2475551 | 2022-05-05 | Mercer | North Dakota | 38057 | 2571 | 24 |
2472294 | 2472294 | 2022-05-04 | Mercer | North Dakota | 38057 | 2571 | 24 |
2469038 | 2469038 | 2022-05-03 | Mercer | North Dakota | 38057 | 2571 | 24 |
2465782 | 2465782 | 2022-05-02 | Mercer | North Dakota | 38057 | 2571 | 24 |
2462527 | 2462527 | 2022-05-01 | Mercer | North Dakota | 38057 | 2571 | 24 |
2463526 | 2463526 | 2022-05-01 | Richmond | Virginia | 51159 | 2571 | 25 |
2459271 | 2459271 | 2022-04-30 | Mercer | North Dakota | 38057 | 2571 | 24 |
2459632 | 2459632 | 2022-04-30 | Sabana Grande | Puerto Rico | 72121 | 2571 | |
2460270 | 2460270 | 2022-04-30 | Richmond | Virginia | 51159 | 2571 | 25 |
2456015 | 2456015 | 2022-04-29 | Mercer | North Dakota | 38057 | 2571 | 24 |
2457014 | 2457014 | 2022-04-29 | Richmond | Virginia | 51159 | 2571 | 25 |
2264927 | 2264927 | 2022-03-01 | Amelia | Virginia | 51007 | 2571 | 57 |
2259039 | 2259039 | 2022-02-28 | Prowers | Colorado | 8099 | 2571 | 47 |
2258448 | 2258448 | 2022-02-27 | Clarke | Virginia | 51043 | 2571 | 40 |
2255197 | 2255197 | 2022-02-26 | Clarke | Virginia | 51043 | 2571 | 40 |
2251946 | 2251946 | 2022-02-25 | Clarke | Virginia | 51043 | 2571 | 40 |
2246716 | 2246716 | 2022-02-24 | Rice | Kansas | 20159 | 2571 | 22 |
2243465 | 2243465 | 2022-02-23 | Rice | Kansas | 20159 | 2571 | 22 |
2240640 | 2240640 | 2022-02-22 | Stevens | Minnesota | 27149 | 2571 | 13 |
2219165 | 2219165 | 2022-02-15 | Dawson | Texas | 48115 | 2571 | 92 |
2201498 | 2201498 | 2022-02-10 | Iron | Michigan | 26071 | 2571 | 79 |
2203254 | 2203254 | 2022-02-10 | Richmond | Virginia | 51159 | 2571 | 19 |
2198244 | 2198244 | 2022-02-09 | Iron | Michigan | 26071 | 2571 | 79 |
2195530 | 2195530 | 2022-02-08 | Colfax | New Mexico | 35007 | 2571 | 62 |
2142986 | 2142986 | 2022-01-23 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2139731 | 2139731 | 2022-01-22 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2136475 | 2136475 | 2022-01-21 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2111373 | 2111373 | 2022-01-13 | Hood River | Oregon | 41027 | 2571 | 38 |
2108795 | 2108795 | 2022-01-12 | Lamoille | Vermont | 50015 | 2571 | 12 |
2103246 | 2103246 | 2022-01-11 | Cumberland | Illinois | 17035 | 2571 | 43 |
2104619 | 2104619 | 2022-01-11 | Swain | North Carolina | 37173 | 2571 | 32 |
2079775 | 2079775 | 2022-01-03 | Buffalo | Wisconsin | 55011 | 2571 | 10 |
2073633 | 2073633 | 2022-01-02 | Grand | Colorado | 8049 | 2571 | 20 |
2070382 | 2070382 | 2022-01-01 | Grand | Colorado | 8049 | 2571 | 20 |
2067131 | 2067131 | 2021-12-31 | Grand | Colorado | 8049 | 2571 | 20 |
2054990 | 2054990 | 2021-12-27 | Bienville | Louisiana | 22013 | 2571 | 100 |
2055612 | 2055612 | 2021-12-27 | Seward | Nebraska | 31159 | 2571 | 38 |
2056730 | 2056730 | 2021-12-27 | Wilbarger | Texas | 48487 | 2571 | 72 |
2052362 | 2052362 | 2021-12-26 | Seward | Nebraska | 31159 | 2571 | 38 |
2049112 | 2049112 | 2021-12-25 | Seward | Nebraska | 31159 | 2571 | 38 |
2049712 | 2049712 | 2021-12-25 | Cayey | Puerto Rico | 72035 | 2571 | |
2045862 | 2045862 | 2021-12-24 | Seward | Nebraska | 31159 | 2571 | 38 |
2042612 | 2042612 | 2021-12-23 | Seward | Nebraska | 31159 | 2571 | 38 |
2039992 | 2039992 | 2021-12-22 | Manati | Puerto Rico | 72091 | 2571 | |
2034216 | 2034216 | 2021-12-20 | Braxton | West Virginia | 54007 | 2571 | 29 |
2028529 | 2028529 | 2021-12-19 | Mercer | Illinois | 17131 | 2571 | 37 |
2029389 | 2029389 | 2021-12-19 | Dallas | Missouri | 29059 | 2571 | 57 |
2025278 | 2025278 | 2021-12-18 | Mercer | Illinois | 17131 | 2571 | 37 |
2022027 | 2022027 | 2021-12-17 | Mercer | Illinois | 17131 | 2571 | 37 |
2005871 | 2005871 | 2021-12-12 | Parke | Indiana | 18121 | 2571 | 33 |
2002620 | 2002620 | 2021-12-11 | Parke | Indiana | 18121 | 2571 | 33 |
2003888 | 2003888 | 2021-12-11 | McKenzie | North Dakota | 38053 | 2571 | 23 |
1999370 | 1999370 | 2021-12-10 | Parke | Indiana | 18121 | 2571 | 33 |
1995311 | 1995311 | 2021-12-08 | Richland | Wisconsin | 55103 | 2571 | 32 |
1988536 | 1988536 | 2021-12-06 | Appomattox | Virginia | 51011 | 2571 | 36 |
1984932 | 1984932 | 2021-12-05 | Lewis | Tennessee | 47101 | 2571 | 43 |
1981682 | 1981682 | 2021-12-04 | Lewis | Tennessee | 47101 | 2571 | 43 |
1978432 | 1978432 | 2021-12-03 | Lewis | Tennessee | 47101 | 2571 | 43 |
1975182 | 1975182 | 2021-12-02 | Lewis | Tennessee | 47101 | 2571 | 43 |
1966933 | 1966933 | 2021-11-30 | Floyd | Iowa | 19067 | 2571 | 49 |
1963681 | 1963681 | 2021-11-29 | Floyd | Iowa | 19067 | 2571 | 49 |
1960271 | 1960271 | 2021-11-28 | Moultrie | Illinois | 17139 | 2571 | 41 |
1960430 | 1960430 | 2021-11-28 | Floyd | Iowa | 19067 | 2571 | 49 |
1957020 | 1957020 | 2021-11-27 | Moultrie | Illinois | 17139 | 2571 | 41 |
1957179 | 1957179 | 2021-11-27 | Floyd | Iowa | 19067 | 2571 | 49 |
1953769 | 1953769 | 2021-11-26 | Moultrie | Illinois | 17139 | 2571 | 41 |
1953928 | 1953928 | 2021-11-26 | Floyd | Iowa | 19067 | 2571 | 49 |
1950518 | 1950518 | 2021-11-25 | Moultrie | Illinois | 17139 | 2571 | 41 |
1950677 | 1950677 | 2021-11-25 | Floyd | Iowa | 19067 | 2571 | 49 |
1947267 | 1947267 | 2021-11-24 | Moultrie | Illinois | 17139 | 2571 | 41 |
1947426 | 1947426 | 2021-11-24 | Floyd | Iowa | 19067 | 2571 | 49 |
1943256 | 1943256 | 2021-11-22 | Burnett | Wisconsin | 55013 | 2571 | 33 |
1936999 | 1936999 | 2021-11-21 | Madison | Arkansas | 5087 | 2571 | 40 |
1917972 | 1917972 | 2021-11-15 | Ford | Illinois | 17053 | 2571 | 67 |
1897500 | 1897500 | 2021-11-08 | Unknown | Utah | 2571 | 41 | |
1887516 | 1887516 | 2021-11-05 | Colorado | Texas | 48089 | 2571 | 52 |
1879448 | 1879448 | 2021-11-03 | Powell | Kentucky | 21197 | 2571 | 22 |
1873464 | 1873464 | 2021-11-01 | Wright | Missouri | 29229 | 2571 | 51 |
1834426 | 1834426 | 2021-10-20 | Moniteau | Missouri | 29135 | 2571 | 38 |
1811512 | 1811512 | 2021-10-13 | Roseau | Minnesota | 27135 | 2571 | 24 |
1788388 | 1788388 | 2021-10-06 | Breckinridge | Kentucky | 21027 | 2571 | 26 |
1779416 | 1779416 | 2021-10-03 | Sullivan | New Hampshire | 33019 | 2571 | 31 |
1776166 | 1776166 | 2021-10-02 | Sullivan | New Hampshire | 33019 | 2571 | 31 |
1772916 | 1772916 | 2021-10-01 | Sullivan | New Hampshire | 33019 | 2571 | 31 |
1770900 | 1770900 | 2021-09-30 | Powhatan | Virginia | 51145 | 2571 | 23 |
1766034 | 1766034 | 2021-09-29 | Wabasha | Minnesota | 27157 | 2571 | 5 |
1743646 | 1743646 | 2021-09-22 | Washington | Nebraska | 31177 | 2571 | 29 |
1737393 | 1737393 | 2021-09-20 | Yancey | North Carolina | 37199 | 2571 | 29 |
1728548 | 1728548 | 2021-09-17 | Bennington | Vermont | 50003 | 2571 | 16 |
1718091 | 1718091 | 2021-09-14 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1714843 | 1714843 | 2021-09-13 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1711597 | 1711597 | 2021-09-12 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1708350 | 1708350 | 2021-09-11 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1705103 | 1705103 | 2021-09-10 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1700800 | 1700800 | 2021-09-09 | Jackson | Louisiana | 22049 | 2571 | 58 |
1701853 | 1701853 | 2021-09-09 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1698604 | 1698604 | 2021-09-08 | McIntosh | Oklahoma | 40091 | 2571 | 67 |
1693186 | 1693186 | 2021-09-07 | Fayette | Alabama | 1057 | 2571 | 66 |
1694015 | 1694015 | 2021-09-07 | Mahaska | Iowa | 19123 | 2571 | 52 |
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);