ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 4418 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 10
- Oklahoma 8
- Louisiana 7
- Mississippi 7
- Ohio 7
- Georgia 6
- North Carolina 6
- Virginia 6
- Minnesota 5
- Puerto Rico 5
- Tennessee 5
- Indiana 4
- Kansas 4
- Michigan 4
- Wisconsin 4
- California 2
- Florida 2
- Illinois 2
- Kentucky 2
- Missouri 2
- West Virginia 2
- Arkansas 1
- Idaho 1
- Iowa 1
- Maryland 1
- New Mexico 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420576 | 2420576 | 2022-04-18 | Yabucoa | Puerto Rico | 72151 | 4418 | |
2302933 | 2302933 | 2022-03-13 | Avery | North Carolina | 37011 | 4418 | 42 |
2299681 | 2299681 | 2022-03-12 | Avery | North Carolina | 37011 | 4418 | 42 |
2296429 | 2296429 | 2022-03-11 | Avery | North Carolina | 37011 | 4418 | 42 |
2263064 | 2263064 | 2022-03-01 | Lewis | Kentucky | 21135 | 4418 | 79 |
2233243 | 2233243 | 2022-02-20 | Putnam | Georgia | 13237 | 4418 | 99 |
2229992 | 2229992 | 2022-02-19 | Putnam | Georgia | 13237 | 4418 | 99 |
2226741 | 2226741 | 2022-02-18 | Putnam | Georgia | 13237 | 4418 | 99 |
2171708 | 2171708 | 2022-02-01 | Perry | Indiana | 18123 | 4418 | 63 |
2168239 | 2168239 | 2022-01-31 | Worth | Georgia | 13321 | 4418 | 98 |
2163306 | 2163306 | 2022-01-29 | Paulding | Ohio | 39125 | 4418 | 69 |
2155587 | 2155587 | 2022-01-27 | Dickinson | Kansas | 20041 | 4418 | 64 |
2152334 | 2152334 | 2022-01-26 | Dickinson | Kansas | 20041 | 4418 | 64 |
2142968 | 2142968 | 2022-01-23 | Osceola | Michigan | 26133 | 4418 | 67 |
2139713 | 2139713 | 2022-01-22 | Osceola | Michigan | 26133 | 4418 | 67 |
2136457 | 2136457 | 2022-01-21 | Osceola | Michigan | 26133 | 4418 | 67 |
2133323 | 2133323 | 2022-01-20 | Clay | Mississippi | 28025 | 4418 | 80 |
2133483 | 2133483 | 2022-01-20 | Ray | Missouri | 29177 | 4418 | 76 |
2086300 | 2086300 | 2022-01-05 | Jackson | Wisconsin | 55053 | 4418 | 39 |
2074572 | 2074572 | 2022-01-02 | Caroline | Maryland | 24011 | 4418 | 57 |
2057880 | 2057880 | 2021-12-28 | Posey | Indiana | 18129 | 4418 | 46 |
2044047 | 2044047 | 2021-12-23 | Kewaunee | Wisconsin | 55061 | 4418 | 49 |
2014549 | 2014549 | 2021-12-14 | Botetourt | Virginia | 51023 | 4418 | 58 |
1992687 | 1992687 | 2021-12-08 | Jerome | Idaho | 16053 | 4418 | 55 |
1944070 | 1944070 | 2021-11-23 | Fayette | Indiana | 18041 | 4418 | 97 |
1925026 | 1925026 | 2021-11-17 | West Baton Rouge | Louisiana | 22121 | 4418 | 77 |
1923707 | 1923707 | 2021-11-16 | Hancock | West Virginia | 54029 | 4418 | 117 |
1905837 | 1905837 | 2021-11-11 | Wayne | Mississippi | 28153 | 4418 | 72 |
1902588 | 1902588 | 2021-11-10 | Wayne | Mississippi | 28153 | 4418 | 72 |
1898803 | 1898803 | 2021-11-09 | Miami | Kansas | 20121 | 4418 | 64 |
1895553 | 1895553 | 2021-11-08 | Miami | Kansas | 20121 | 4418 | 64 |
1886974 | 1886974 | 2021-11-05 | Pike | Ohio | 39131 | 4418 | 73 |
1848915 | 1848915 | 2021-10-24 | Wythe | Virginia | 51197 | 4418 | 97 |
1844511 | 1844511 | 2021-10-23 | Wyoming | New York | 36121 | 4418 | 58 |
1845665 | 1845665 | 2021-10-23 | Wythe | Virginia | 51197 | 4418 | 97 |
1842415 | 1842415 | 2021-10-22 | Wythe | Virginia | 51197 | 4418 | 97 |
1833947 | 1833947 | 2021-10-20 | Montgomery | Kentucky | 21173 | 4418 | 55 |
1824267 | 1824267 | 2021-10-17 | Morehouse | Louisiana | 22067 | 4418 | 114 |
1821018 | 1821018 | 2021-10-16 | Morehouse | Louisiana | 22067 | 4418 | 114 |
1817769 | 1817769 | 2021-10-15 | Morehouse | Louisiana | 22067 | 4418 | 114 |
1813293 | 1813293 | 2021-10-13 | Green | Wisconsin | 55045 | 4418 | 29 |
1751254 | 1751254 | 2021-09-24 | Willacy | Texas | 48489 | 4418 | 102 |
1746275 | 1746275 | 2021-09-23 | East Feliciana | Louisiana | 22037 | 4418 | 140 |
1740111 | 1740111 | 2021-09-21 | Prentiss | Mississippi | 28117 | 4418 | 77 |
1729074 | 1729074 | 2021-09-18 | Yell | Arkansas | 5149 | 4418 | 76 |
1714622 | 1714622 | 2021-09-13 | Person | North Carolina | 37145 | 4418 | 77 |
1708553 | 1708553 | 2021-09-11 | Trujillo Alto | Puerto Rico | 72139 | 4418 | |
1694474 | 1694474 | 2021-09-07 | Sanilac | Michigan | 26151 | 4418 | 127 |
1693017 | 1693017 | 2021-09-06 | Fayette | West Virginia | 54019 | 4418 | 93 |
1672739 | 1672739 | 2021-08-31 | Venango | Pennsylvania | 42121 | 4418 | 106 |
1651118 | 1651118 | 2021-08-25 | Amador | California | 6005 | 4418 | 50 |
1653394 | 1653394 | 2021-08-25 | Brookings | South Dakota | 46011 | 4418 | 37 |
1649878 | 1649878 | 2021-08-24 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1646629 | 1646629 | 2021-08-23 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1643380 | 1643380 | 2021-08-22 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1640130 | 1640130 | 2021-08-21 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1636880 | 1636880 | 2021-08-20 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1633630 | 1633630 | 2021-08-19 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1629365 | 1629365 | 2021-08-18 | Vernon | Louisiana | 22115 | 4418 | 124 |
1630383 | 1630383 | 2021-08-18 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1604205 | 1604205 | 2021-08-10 | Yadkin | North Carolina | 37197 | 4418 | 56 |
1578296 | 1578296 | 2021-08-02 | Fulton | Ohio | 39051 | 4418 | 75 |
1566078 | 1566078 | 2021-07-29 | Waller | Texas | 48473 | 4418 | 52 |
1556135 | 1556135 | 2021-07-26 | Cherokee | Texas | 48073 | 4418 | 148 |
1552888 | 1552888 | 2021-07-25 | Cherokee | Texas | 48073 | 4418 | 148 |
1549641 | 1549641 | 2021-07-24 | Cherokee | Texas | 48073 | 4418 | 148 |
1545797 | 1545797 | 2021-07-23 | Ashland | Ohio | 39005 | 4418 | 98 |
1539823 | 1539823 | 2021-07-21 | Marshall | Tennessee | 47117 | 4418 | 63 |
1525830 | 1525830 | 2021-07-17 | Platte | Missouri | 29165 | 4418 | 50 |
1510593 | 1510593 | 2021-07-12 | Lincoln | Tennessee | 47103 | 4418 | 67 |
1506123 | 1506123 | 2021-07-11 | Isanti | Minnesota | 27059 | 4418 | 65 |
1507346 | 1507346 | 2021-07-11 | Lincoln | Tennessee | 47103 | 4418 | 67 |
1502877 | 1502877 | 2021-07-10 | Isanti | Minnesota | 27059 | 4418 | 65 |
1504100 | 1504100 | 2021-07-10 | Lincoln | Tennessee | 47103 | 4418 | 67 |
1499631 | 1499631 | 2021-07-09 | Isanti | Minnesota | 27059 | 4418 | 65 |
1500854 | 1500854 | 2021-07-09 | Lincoln | Tennessee | 47103 | 4418 | 67 |
1481543 | 1481543 | 2021-07-03 | Jim Wells | Texas | 48249 | 4418 | 108 |
1466531 | 1466531 | 2021-06-29 | DeKalb | Indiana | 18033 | 4418 | 88 |
1421015 | 1421015 | 2021-06-15 | Jefferson | Illinois | 17081 | 4418 | 123 |
1381254 | 1381254 | 2021-06-02 | Grays Harbor | Washington | 53027 | 4418 | 73 |
1364063 | 1364063 | 2021-05-28 | Madison | Ohio | 39097 | 4418 | 63 |
1286980 | 1286980 | 2021-05-04 | Campbell | Virginia | 51031 | 4418 | 84 |
1264064 | 1264064 | 2021-04-27 | Kerr | Texas | 48265 | 4418 | 87 |
1243928 | 1243928 | 2021-04-21 | Knox | Ohio | 39083 | 4418 | 108 |
1230184 | 1230184 | 2021-04-17 | Douglas | Minnesota | 27041 | 4418 | 70 |
1216060 | 1216060 | 2021-04-13 | Nevada | California | 6057 | 4418 | 75 |
1212083 | 1212083 | 2021-04-11 | Hill | Texas | 48217 | 4418 | 105 |
1207571 | 1207571 | 2021-04-10 | Pearl River | Mississippi | 28109 | 4418 | 139 |
1208834 | 1208834 | 2021-04-10 | Hill | Texas | 48217 | 4418 | 105 |
1202591 | 1202591 | 2021-04-08 | Henry | Virginia | 51089 | 4418 | 121 |
1198280 | 1198280 | 2021-04-07 | Chatham | North Carolina | 37037 | 4418 | 85 |
1175092 | 1175092 | 2021-03-31 | Panola | Mississippi | 28107 | 4418 | 103 |
1170771 | 1170771 | 2021-03-30 | Baldwin | Georgia | 13009 | 4418 | 123 |
1138250 | 1138250 | 2021-03-20 | Hendry | Florida | 12051 | 4418 | 76 |
1088361 | 1088361 | 2021-03-04 | Unknown | Puerto Rico | 4418 | 2053 | |
1085908 | 1085908 | 2021-03-03 | Monroe | Wisconsin | 55081 | 4418 | 32 |
1081678 | 1081678 | 2021-03-02 | Pittsburg | Oklahoma | 40121 | 4418 | 39 |
1078056 | 1078056 | 2021-03-01 | Otero | New Mexico | 35035 | 4418 | 57 |
1064573 | 1064573 | 2021-02-25 | Benton | Minnesota | 27009 | 4418 | 90 |
1065642 | 1065642 | 2021-02-25 | Unknown | Puerto Rico | 4418 | 2016 |
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);