ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where cases = 2711 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 18
- Texas 17
- Missouri 14
- Kentucky 12
- Georgia 10
- Tennessee 10
- Ohio 9
- Indiana 8
- Virginia 8
- Idaho 7
- Mississippi 7
- Oklahoma 7
- Wisconsin 7
- Arkansas 6
- Illinois 6
- Puerto Rico 6
- Oregon 5
- Alabama 4
- Colorado 4
- Louisiana 4
- Michigan 4
- North Carolina 4
- Maine 3
- Minnesota 3
- Nebraska 3
- South Carolina 3
- Florida 2
- Kansas 2
- New Mexico 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459616 | 2459616 | 2022-04-30 | Luquillo | Puerto Rico | 72089 | 2711 | |
2402479 | 2402479 | 2022-04-13 | Teton | Idaho | 16081 | 2711 | 9 |
2399224 | 2399224 | 2022-04-12 | Teton | Idaho | 16081 | 2711 | 9 |
2395969 | 2395969 | 2022-04-11 | Teton | Idaho | 16081 | 2711 | 9 |
2358153 | 2358153 | 2022-03-30 | Los Alamos | New Mexico | 35028 | 2711 | 14 |
2328802 | 2328802 | 2022-03-21 | Unknown | Nebraska | 2711 | 436 | |
2219139 | 2219139 | 2022-02-15 | Camp | Texas | 48063 | 2711 | 71 |
2202576 | 2202576 | 2022-02-10 | Comerio | Puerto Rico | 72045 | 2711 | |
2199659 | 2199659 | 2022-02-09 | Eastland | Texas | 48133 | 2711 | 99 |
2199830 | 2199830 | 2022-02-09 | Ward | Texas | 48475 | 2711 | 42 |
2177512 | 2177512 | 2022-02-03 | Wilcox | Alabama | 1131 | 2711 | 39 |
2174259 | 2174259 | 2022-02-02 | Wilcox | Alabama | 1131 | 2711 | 39 |
2173466 | 2173466 | 2022-02-01 | Todd | South Dakota | 46121 | 2711 | 43 |
2168767 | 2168767 | 2022-01-31 | Martin | Kentucky | 21159 | 2711 | 44 |
2133931 | 2133931 | 2022-01-20 | Mountrail | North Dakota | 38061 | 2711 | 32 |
2129412 | 2129412 | 2022-01-19 | Pulaski | Indiana | 18131 | 2711 | 75 |
2126196 | 2126196 | 2022-01-18 | Butler | Iowa | 19023 | 2711 | 48 |
2122944 | 2122944 | 2022-01-17 | Butler | Iowa | 19023 | 2711 | 48 |
2124395 | 2124395 | 2022-01-17 | Tillamook | Oregon | 41057 | 2711 | 54 |
2119692 | 2119692 | 2022-01-16 | Butler | Iowa | 19023 | 2711 | 48 |
2121143 | 2121143 | 2022-01-16 | Tillamook | Oregon | 41057 | 2711 | 54 |
2116440 | 2116440 | 2022-01-15 | Butler | Iowa | 19023 | 2711 | 48 |
2117891 | 2117891 | 2022-01-15 | Tillamook | Oregon | 41057 | 2711 | 54 |
2113189 | 2113189 | 2022-01-14 | Butler | Iowa | 19023 | 2711 | 48 |
2114640 | 2114640 | 2022-01-14 | Tillamook | Oregon | 41057 | 2711 | 54 |
2109937 | 2109937 | 2022-01-13 | Butler | Iowa | 19023 | 2711 | 48 |
2106686 | 2106686 | 2022-01-12 | Butler | Iowa | 19023 | 2711 | 48 |
2084193 | 2084193 | 2022-01-05 | Magoffin | Kentucky | 21153 | 2711 | 35 |
2084678 | 2084678 | 2022-01-05 | Madison | Missouri | 29123 | 2711 | 42 |
2082212 | 2082212 | 2022-01-04 | Camuy | Puerto Rico | 72027 | 2711 | |
2060753 | 2060753 | 2021-12-29 | Bacon | Georgia | 13005 | 2711 | 64 |
2060344 | 2060344 | 2021-12-28 | Goshen | Wyoming | 56015 | 2711 | 52 |
2046468 | 2046468 | 2021-12-24 | Corozal | Puerto Rico | 72047 | 2711 | |
2043218 | 2043218 | 2021-12-23 | Corozal | Puerto Rico | 72047 | 2711 | |
2032306 | 2032306 | 2021-12-20 | Knox | Maine | 23013 | 2711 | 17 |
2029055 | 2029055 | 2021-12-19 | Knox | Maine | 23013 | 2711 | 17 |
2025804 | 2025804 | 2021-12-18 | Knox | Maine | 23013 | 2711 | 17 |
1991054 | 1991054 | 2021-12-07 | Murray | Oklahoma | 40099 | 2711 | 57 |
1987803 | 1987803 | 2021-12-06 | Murray | Oklahoma | 40099 | 2711 | 57 |
1984553 | 1984553 | 2021-12-05 | Murray | Oklahoma | 40099 | 2711 | 57 |
1981303 | 1981303 | 2021-12-04 | Murray | Oklahoma | 40099 | 2711 | 57 |
1978053 | 1978053 | 2021-12-03 | Murray | Oklahoma | 40099 | 2711 | 57 |
1974803 | 1974803 | 2021-12-02 | Murray | Oklahoma | 40099 | 2711 | 53 |
1971554 | 1971554 | 2021-12-01 | Murray | Oklahoma | 40099 | 2711 | 53 |
1944786 | 1944786 | 2021-11-23 | Holmes | Mississippi | 28051 | 2711 | 89 |
1904956 | 1904956 | 2021-11-11 | Cass | Illinois | 17017 | 2711 | 40 |
1901706 | 1901706 | 2021-11-10 | Cass | Illinois | 17017 | 2711 | 40 |
1882325 | 1882325 | 2021-11-04 | Franklin | Indiana | 18047 | 2711 | 46 |
1852812 | 1852812 | 2021-10-26 | Greene | Georgia | 13133 | 2711 | 70 |
1849373 | 1849373 | 2021-10-25 | Elbert | Colorado | 8039 | 2711 | 23 |
1838019 | 1838019 | 2021-10-21 | Avery | North Carolina | 37011 | 2711 | 33 |
1834008 | 1834008 | 2021-10-20 | LaSalle | Louisiana | 22059 | 2711 | 46 |
1815327 | 1815327 | 2021-10-14 | Madison | North Carolina | 37115 | 2711 | 57 |
1811616 | 1811616 | 2021-10-13 | Andrew | Missouri | 29003 | 2711 | 24 |
1812822 | 1812822 | 2021-10-13 | Freestone | Texas | 48161 | 2711 | 64 |
1807685 | 1807685 | 2021-10-12 | Clay | Iowa | 19041 | 2711 | 29 |
1809892 | 1809892 | 2021-10-12 | Powhatan | Virginia | 51145 | 2711 | 27 |
1804434 | 1804434 | 2021-10-11 | Clay | Iowa | 19041 | 2711 | 29 |
1801185 | 1801185 | 2021-10-10 | Clay | Iowa | 19041 | 2711 | 29 |
1797936 | 1797936 | 2021-10-09 | Clay | Iowa | 19041 | 2711 | 29 |
1794687 | 1794687 | 2021-10-08 | Clay | Iowa | 19041 | 2711 | 29 |
1791439 | 1791439 | 2021-10-07 | Clay | Iowa | 19041 | 2711 | 29 |
1788190 | 1788190 | 2021-10-06 | Clay | Iowa | 19041 | 2711 | 29 |
1785233 | 1785233 | 2021-10-05 | Spencer | Kentucky | 21215 | 2711 | 28 |
1779047 | 1779047 | 2021-10-03 | Calhoun | Mississippi | 28013 | 2711 | 44 |
1775797 | 1775797 | 2021-10-02 | Calhoun | Mississippi | 28013 | 2711 | 44 |
1772547 | 1772547 | 2021-10-01 | Calhoun | Mississippi | 28013 | 2711 | 44 |
1759276 | 1759276 | 2021-09-27 | Jackson | Louisiana | 22049 | 2711 | 59 |
1734821 | 1734821 | 2021-09-19 | DeWitt | Texas | 48123 | 2711 | 69 |
1731571 | 1731571 | 2021-09-18 | DeWitt | Texas | 48123 | 2711 | 69 |
1728321 | 1728321 | 2021-09-17 | DeWitt | Texas | 48123 | 2711 | 68 |
1722518 | 1722518 | 2021-09-16 | Cross | Arkansas | 5037 | 2711 | 58 |
1725072 | 1725072 | 2021-09-16 | DeWitt | Texas | 48123 | 2711 | 67 |
1721823 | 1721823 | 2021-09-15 | DeWitt | Texas | 48123 | 2711 | 67 |
1718575 | 1718575 | 2021-09-14 | DeWitt | Texas | 48123 | 2711 | 67 |
1712813 | 1712813 | 2021-09-13 | Polk | Arkansas | 5113 | 2711 | 93 |
1715327 | 1715327 | 2021-09-13 | DeWitt | Texas | 48123 | 2711 | 67 |
1712081 | 1712081 | 2021-09-12 | DeWitt | Texas | 48123 | 2711 | 67 |
1708834 | 1708834 | 2021-09-11 | DeWitt | Texas | 48123 | 2711 | 67 |
1705587 | 1705587 | 2021-09-10 | DeWitt | Texas | 48123 | 2711 | 66 |
1693627 | 1693627 | 2021-09-07 | Jeff Davis | Georgia | 13161 | 2711 | 45 |
1676942 | 1676942 | 2021-09-02 | Hale | Alabama | 1065 | 2711 | 81 |
1619665 | 1619665 | 2021-08-15 | Somerset | Maryland | 24039 | 2711 | 42 |
1609321 | 1609321 | 2021-08-12 | Douglas | Illinois | 17041 | 2711 | 42 |
1605497 | 1605497 | 2021-08-11 | Marengo | Alabama | 1091 | 2711 | 67 |
1607868 | 1607868 | 2021-08-11 | Abbeville | South Carolina | 45001 | 2711 | 41 |
1578117 | 1578117 | 2021-08-02 | Anson | North Carolina | 37007 | 2711 | 57 |
1573544 | 1573544 | 2021-08-01 | Jerome | Idaho | 16053 | 2711 | 25 |
1570296 | 1570296 | 2021-07-31 | Jerome | Idaho | 16053 | 2711 | 25 |
1567048 | 1567048 | 2021-07-30 | Jerome | Idaho | 16053 | 2711 | 25 |
1512784 | 1512784 | 2021-07-13 | Crawford | Missouri | 29055 | 2711 | 40 |
1507712 | 1507712 | 2021-07-11 | Caroline | Virginia | 51033 | 2711 | 40 |
1503597 | 1503597 | 2021-07-10 | Coshocton | Ohio | 39031 | 2711 | 60 |
1504466 | 1504466 | 2021-07-10 | Caroline | Virginia | 51033 | 2711 | 40 |
1500351 | 1500351 | 2021-07-09 | Coshocton | Ohio | 39031 | 2711 | 60 |
1488275 | 1488275 | 2021-07-05 | Hopewell city | Virginia | 51670 | 2711 | 79 |
1471154 | 1471154 | 2021-06-30 | Holmes | Ohio | 39075 | 2711 | 102 |
1463342 | 1463342 | 2021-06-28 | Scott | Indiana | 18143 | 2711 | 59 |
1464153 | 1464153 | 2021-06-28 | Randolph | Missouri | 29175 | 2711 | 30 |
1460097 | 1460097 | 2021-06-27 | Scott | Indiana | 18143 | 2711 | 59 |
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);