ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where cases = 2881 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Kentucky 11
- Illinois 10
- Indiana 10
- Utah 10
- Iowa 9
- Minnesota 9
- Ohio 8
- Georgia 6
- Louisiana 6
- Missouri 6
- Tennessee 6
- Mississippi 5
- North Carolina 5
- Washington 5
- Arkansas 4
- California 4
- Idaho 4
- South Dakota 4
- West Virginia 4
- Nebraska 3
- Pennsylvania 3
- Virginia 3
- Arizona 2
- Florida 2
- Michigan 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Alabama 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500650 | 2500650 | 2022-05-13 | Lyon | Kentucky | 21143 | 2881 | 34 |
2497392 | 2497392 | 2022-05-12 | Lyon | Kentucky | 21143 | 2881 | 34 |
2494134 | 2494134 | 2022-05-11 | Lyon | Kentucky | 21143 | 2881 | 34 |
2490601 | 2490601 | 2022-05-10 | Allamakee | Iowa | 19005 | 2881 | 60 |
2490876 | 2490876 | 2022-05-10 | Lyon | Kentucky | 21143 | 2881 | 34 |
2487344 | 2487344 | 2022-05-09 | Allamakee | Iowa | 19005 | 2881 | 60 |
2487619 | 2487619 | 2022-05-09 | Lyon | Kentucky | 21143 | 2881 | 34 |
2484086 | 2484086 | 2022-05-08 | Allamakee | Iowa | 19005 | 2881 | 60 |
2480828 | 2480828 | 2022-05-07 | Allamakee | Iowa | 19005 | 2881 | 60 |
2477570 | 2477570 | 2022-05-06 | Allamakee | Iowa | 19005 | 2881 | 60 |
2474312 | 2474312 | 2022-05-05 | Allamakee | Iowa | 19005 | 2881 | 60 |
2471055 | 2471055 | 2022-05-04 | Allamakee | Iowa | 19005 | 2881 | 60 |
2472613 | 2472613 | 2022-05-04 | Ciales | Puerto Rico | 72039 | 2881 | |
2336444 | 2336444 | 2022-03-23 | Juab | Utah | 49023 | 2881 | 23 |
2333190 | 2333190 | 2022-03-22 | Juab | Utah | 49023 | 2881 | 23 |
2329937 | 2329937 | 2022-03-21 | Juab | Utah | 49023 | 2881 | 23 |
2326685 | 2326685 | 2022-03-20 | Juab | Utah | 49023 | 2881 | 23 |
2323432 | 2323432 | 2022-03-19 | Juab | Utah | 49023 | 2881 | 23 |
2320178 | 2320178 | 2022-03-18 | Juab | Utah | 49023 | 2881 | 23 |
2316924 | 2316924 | 2022-03-17 | Juab | Utah | 49023 | 2881 | 23 |
2313671 | 2313671 | 2022-03-16 | Juab | Utah | 49023 | 2881 | 23 |
2310418 | 2310418 | 2022-03-15 | Juab | Utah | 49023 | 2881 | 23 |
2271930 | 2271930 | 2022-03-04 | Stone | Arkansas | 5137 | 2881 | 60 |
2251137 | 2251137 | 2022-02-25 | Vinton | Ohio | 39163 | 2881 | 55 |
2241146 | 2241146 | 2022-02-22 | Alleghany | North Carolina | 37005 | 2881 | 11 |
2183843 | 2183843 | 2022-02-04 | Roane | West Virginia | 54087 | 2881 | 31 |
2177666 | 2177666 | 2022-02-03 | Plumas | California | 6063 | 2881 | 12 |
2165448 | 2165448 | 2022-01-30 | Breathitt | Kentucky | 21025 | 2881 | 49 |
2162193 | 2162193 | 2022-01-29 | Breathitt | Kentucky | 21025 | 2881 | 49 |
2158938 | 2158938 | 2022-01-28 | Breathitt | Kentucky | 21025 | 2881 | 49 |
2157678 | 2157678 | 2022-01-27 | Martinsville city | Virginia | 51690 | 2881 | 100 |
2137821 | 2137821 | 2022-01-21 | Comanche | Texas | 48093 | 2881 | 70 |
2117665 | 2117665 | 2022-01-15 | McKenzie | North Dakota | 38053 | 2881 | 23 |
2100141 | 2100141 | 2022-01-10 | Parke | Indiana | 18121 | 2881 | 39 |
2081215 | 2081215 | 2022-01-04 | Faribault | Minnesota | 27043 | 2881 | 41 |
2051308 | 2051308 | 2021-12-26 | Warren | Illinois | 17187 | 2881 | 73 |
2048058 | 2048058 | 2021-12-25 | Warren | Illinois | 17187 | 2881 | 73 |
2044246 | 2044246 | 2021-12-24 | Franklin | Arkansas | 5047 | 2881 | 58 |
2044808 | 2044808 | 2021-12-24 | Warren | Illinois | 17187 | 2881 | 73 |
2041559 | 2041559 | 2021-12-23 | Warren | Illinois | 17187 | 2881 | 73 |
2028490 | 2028490 | 2021-12-19 | Ford | Illinois | 17053 | 2881 | 67 |
2025239 | 2025239 | 2021-12-18 | Ford | Illinois | 17053 | 2881 | 67 |
2021988 | 2021988 | 2021-12-17 | Ford | Illinois | 17053 | 2881 | 67 |
1962934 | 1962934 | 2021-11-29 | North Slope Borough | Alaska | 2185 | 2881 | 8 |
1922545 | 1922545 | 2021-11-16 | Hertford | North Carolina | 37091 | 2881 | 72 |
1919876 | 1919876 | 2021-11-15 | Benton | Tennessee | 47005 | 2881 | 55 |
1897425 | 1897425 | 2021-11-08 | San Jacinto | Texas | 48407 | 2881 | 79 |
1894175 | 1894175 | 2021-11-07 | San Jacinto | Texas | 48407 | 2881 | 79 |
1894408 | 1894408 | 2021-11-07 | Asotin | Washington | 53003 | 2881 | 50 |
1890925 | 1890925 | 2021-11-06 | San Jacinto | Texas | 48407 | 2881 | 79 |
1891158 | 1891158 | 2021-11-06 | Asotin | Washington | 53003 | 2881 | 50 |
1886368 | 1886368 | 2021-11-05 | Clinton | Missouri | 29049 | 2881 | 77 |
1887908 | 1887908 | 2021-11-05 | Asotin | Washington | 53003 | 2881 | 50 |
1810145 | 1810145 | 2021-10-13 | Fayette | Alabama | 1057 | 2881 | 79 |
1789977 | 1789977 | 2021-10-06 | Sequatchie | Tennessee | 47153 | 2881 | 30 |
1785732 | 1785732 | 2021-10-05 | Vernon | Missouri | 29217 | 2881 | 64 |
1786946 | 1786946 | 2021-10-05 | Robertson | Texas | 48395 | 2881 | 61 |
1739898 | 1739898 | 2021-09-21 | Clare | Michigan | 26035 | 2881 | 90 |
1740385 | 1740385 | 2021-09-21 | Saunders | Nebraska | 31155 | 2881 | 20 |
1736649 | 1736649 | 2021-09-20 | Clare | Michigan | 26035 | 2881 | 90 |
1701564 | 1701564 | 2021-09-09 | Ashe | North Carolina | 37009 | 2881 | 45 |
1702025 | 1702025 | 2021-09-09 | Juncos | Puerto Rico | 72077 | 2881 | |
1682485 | 1682485 | 2021-09-03 | Warren | Pennsylvania | 42123 | 2881 | 107 |
1666046 | 1666046 | 2021-08-29 | Pike | Ohio | 39131 | 2881 | 38 |
1648274 | 1648274 | 2021-08-24 | Payette | Idaho | 16075 | 2881 | 39 |
1649776 | 1649776 | 2021-08-24 | Henry | Ohio | 39069 | 2881 | 67 |
1642350 | 1642350 | 2021-08-22 | St. James | Louisiana | 22093 | 2881 | 57 |
1639100 | 1639100 | 2021-08-21 | St. James | Louisiana | 22093 | 2881 | 57 |
1635850 | 1635850 | 2021-08-20 | St. James | Louisiana | 22093 | 2881 | 57 |
1630607 | 1630607 | 2021-08-18 | Barnwell | South Carolina | 45011 | 2881 | 59 |
1609107 | 1609107 | 2021-08-12 | Burke | Georgia | 13033 | 2881 | 66 |
1599415 | 1599415 | 2021-08-09 | Harris | Georgia | 13145 | 2881 | 66 |
1599472 | 1599472 | 2021-08-09 | Sumter | Georgia | 13261 | 2881 | 106 |
1589016 | 1589016 | 2021-08-05 | Wythe | Virginia | 51197 | 2881 | 81 |
1580982 | 1580982 | 2021-08-03 | Crawford | Missouri | 29055 | 2881 | 41 |
1579322 | 1579322 | 2021-08-02 | Hancock | West Virginia | 54029 | 2881 | 90 |
1559009 | 1559009 | 2021-07-27 | Elk | Pennsylvania | 42047 | 2881 | 41 |
1551564 | 1551564 | 2021-07-25 | Cass | Minnesota | 27021 | 2881 | 33 |
1551630 | 1551630 | 2021-07-25 | Todd | Minnesota | 27153 | 2881 | 33 |
1552312 | 1552312 | 2021-07-25 | Fayette | Ohio | 39047 | 2881 | 50 |
1548317 | 1548317 | 2021-07-24 | Cass | Minnesota | 27021 | 2881 | 33 |
1548383 | 1548383 | 2021-07-24 | Todd | Minnesota | 27153 | 2881 | 33 |
1549065 | 1549065 | 2021-07-24 | Fayette | Ohio | 39047 | 2881 | 50 |
1545070 | 1545070 | 2021-07-23 | Cass | Minnesota | 27021 | 2881 | 33 |
1545136 | 1545136 | 2021-07-23 | Todd | Minnesota | 27153 | 2881 | 33 |
1535078 | 1535078 | 2021-07-20 | Montgomery | Kentucky | 21173 | 2881 | 30 |
1520302 | 1520302 | 2021-07-15 | DeKalb | Tennessee | 47041 | 2881 | 56 |
1490008 | 1490008 | 2021-07-06 | Prentiss | Mississippi | 28117 | 2881 | 61 |
1469789 | 1469789 | 2021-06-30 | Greene | Indiana | 18055 | 2881 | 89 |
1471761 | 1471761 | 2021-06-30 | Frio | Texas | 48163 | 2881 | 52 |
1465931 | 1465931 | 2021-06-29 | Carroll | Arkansas | 5015 | 2881 | 46 |
1427671 | 1427671 | 2021-06-17 | Bremer | Iowa | 19017 | 2881 | 61 |
1424426 | 1424426 | 2021-06-16 | Bremer | Iowa | 19017 | 2881 | 61 |
1416963 | 1416963 | 2021-06-13 | Mason | Washington | 53045 | 2881 | 37 |
1413717 | 1413717 | 2021-06-12 | Mason | Washington | 53045 | 2881 | 37 |
1380915 | 1380915 | 2021-06-02 | Hockley | Texas | 48219 | 2881 | 103 |
1376009 | 1376009 | 2021-06-01 | Logan | Kentucky | 21141 | 2881 | 69 |
1335859 | 1335859 | 2021-05-19 | Mineral | West Virginia | 54057 | 2881 | 89 |
1332191 | 1332191 | 2021-05-18 | Frio | Texas | 48163 | 2881 | 51 |
1311491 | 1311491 | 2021-05-12 | Tippah | Mississippi | 28139 | 2881 | 68 |
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);