ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 5175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Kentucky 9
- Ohio 9
- Virginia 8
- Wisconsin 8
- Oklahoma 7
- Rhode Island 7
- Illinois 6
- Minnesota 6
- Missouri 4
- Wyoming 4
- Georgia 3
- Indiana 3
- Utah 3
- California 2
- Iowa 2
- Louisiana 2
- South Dakota 2
- Arkansas 1
- Florida 1
- Hawaii 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Mississippi 1
- New Hampshire 1
- New York 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2303906 | 2303906 | 2022-03-13 | Carbon | Utah | 49007 | 5175 | 44 |
2300654 | 2300654 | 2022-03-12 | Carbon | Utah | 49007 | 5175 | 44 |
2297402 | 2297402 | 2022-03-11 | Carbon | Utah | 49007 | 5175 | 44 |
2279374 | 2279374 | 2022-03-06 | Wayne | Kentucky | 21231 | 5175 | 87 |
2276121 | 2276121 | 2022-03-05 | Wayne | Kentucky | 21231 | 5175 | 87 |
2272868 | 2272868 | 2022-03-04 | Wayne | Kentucky | 21231 | 5175 | 87 |
2265213 | 2265213 | 2022-03-01 | Vilas | Wisconsin | 55125 | 5175 | 85 |
2235448 | 2235448 | 2022-02-20 | Gillespie | Texas | 48171 | 5175 | 104 |
2232197 | 2232197 | 2022-02-19 | Gillespie | Texas | 48171 | 5175 | 104 |
2221151 | 2221151 | 2022-02-16 | Attala | Mississippi | 28007 | 5175 | 106 |
2219536 | 2219536 | 2022-02-15 | Waynesboro city | Virginia | 51820 | 5175 | 59 |
2186024 | 2186024 | 2022-02-05 | Carroll | Ohio | 39019 | 5175 | 113 |
2173576 | 2173576 | 2022-02-01 | Austin | Texas | 48015 | 5175 | 61 |
2145917 | 2145917 | 2022-01-24 | Anderson | Kentucky | 21005 | 5175 | 58 |
2106069 | 2106069 | 2022-01-12 | Calaveras | California | 6009 | 5175 | 93 |
2105684 | 2105684 | 2022-01-11 | Winchester city | Virginia | 51840 | 5175 | 59 |
2083862 | 2083862 | 2022-01-05 | Jennings | Indiana | 18079 | 5175 | 75 |
2072164 | 2072164 | 2022-01-01 | Stutsman | North Dakota | 38093 | 5175 | 92 |
2067039 | 2067039 | 2021-12-31 | St. Francis | Arkansas | 5123 | 5175 | 73 |
2009695 | 2009695 | 2021-12-13 | Cass | Minnesota | 27021 | 5175 | 59 |
1969145 | 1969145 | 2021-11-30 | Smyth | Virginia | 51173 | 5175 | 123 |
1960255 | 1960255 | 2021-11-28 | Logan | Illinois | 17107 | 5175 | 89 |
1960627 | 1960627 | 2021-11-28 | Clay | Kentucky | 21051 | 5175 | 62 |
1957004 | 1957004 | 2021-11-27 | Logan | Illinois | 17107 | 5175 | 89 |
1957376 | 1957376 | 2021-11-27 | Clay | Kentucky | 21051 | 5175 | 62 |
1953753 | 1953753 | 2021-11-26 | Logan | Illinois | 17107 | 5175 | 89 |
1954125 | 1954125 | 2021-11-26 | Clay | Kentucky | 21051 | 5175 | 62 |
1950502 | 1950502 | 2021-11-25 | Logan | Illinois | 17107 | 5175 | 89 |
1950874 | 1950874 | 2021-11-25 | Clay | Kentucky | 21051 | 5175 | 62 |
1947251 | 1947251 | 2021-11-24 | Logan | Illinois | 17107 | 5175 | 89 |
1947623 | 1947623 | 2021-11-24 | Clay | Kentucky | 21051 | 5175 | 62 |
1944573 | 1944573 | 2021-11-23 | Worcester | Maryland | 24047 | 5175 | 124 |
1933018 | 1933018 | 2021-11-19 | Cooke | Texas | 48097 | 5175 | 105 |
1929767 | 1929767 | 2021-11-18 | Cooke | Texas | 48097 | 5175 | 105 |
1926517 | 1926517 | 2021-11-17 | Cooke | Texas | 48097 | 5175 | 103 |
1923267 | 1923267 | 2021-11-16 | Cooke | Texas | 48097 | 5175 | 103 |
1854514 | 1854514 | 2021-10-26 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1851265 | 1851265 | 2021-10-25 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1848015 | 1848015 | 2021-10-24 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1844765 | 1844765 | 2021-10-23 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1840911 | 1840911 | 2021-10-22 | Lawrence | Missouri | 29109 | 5175 | 104 |
1841515 | 1841515 | 2021-10-22 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1838266 | 1838266 | 2021-10-21 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1835017 | 1835017 | 2021-10-20 | Caddo | Oklahoma | 40015 | 5175 | 129 |
1807480 | 1807480 | 2021-10-12 | Christian | Illinois | 17021 | 5175 | 100 |
1806568 | 1806568 | 2021-10-11 | Charlottesville city | Virginia | 51540 | 5175 | 58 |
1801744 | 1801744 | 2021-10-10 | Morrison | Minnesota | 27097 | 5175 | 63 |
1803318 | 1803318 | 2021-10-10 | Charlottesville city | Virginia | 51540 | 5175 | 58 |
1798495 | 1798495 | 2021-10-09 | Morrison | Minnesota | 27097 | 5175 | 63 |
1800069 | 1800069 | 2021-10-09 | Charlottesville city | Virginia | 51540 | 5175 | 58 |
1795246 | 1795246 | 2021-10-08 | Morrison | Minnesota | 27097 | 5175 | 63 |
1796820 | 1796820 | 2021-10-08 | Charlottesville city | Virginia | 51540 | 5175 | 58 |
1779177 | 1779177 | 2021-10-03 | Laclede | Missouri | 29105 | 5175 | 125 |
1760766 | 1760766 | 2021-09-27 | Bee | Texas | 48025 | 5175 | 111 |
1757518 | 1757518 | 2021-09-26 | Bee | Texas | 48025 | 5175 | 111 |
1737170 | 1737170 | 2021-09-20 | Belknap | New Hampshire | 33001 | 5175 | 111 |
1734213 | 1734213 | 2021-09-19 | Clinton | Ohio | 39027 | 5175 | 80 |
1712589 | 1712589 | 2021-09-12 | Marinette | Wisconsin | 55075 | 5175 | 77 |
1708261 | 1708261 | 2021-09-11 | Madison | Ohio | 39097 | 5175 | 68 |
1709342 | 1709342 | 2021-09-11 | Marinette | Wisconsin | 55075 | 5175 | 77 |
1706095 | 1706095 | 2021-09-10 | Marinette | Wisconsin | 55075 | 5175 | 77 |
1701923 | 1701923 | 2021-09-09 | Bedford | Pennsylvania | 42009 | 5175 | 145 |
1672529 | 1672529 | 2021-08-31 | Mercer | Ohio | 39107 | 5175 | 86 |
1667088 | 1667088 | 2021-08-29 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1663840 | 1663840 | 2021-08-28 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1660592 | 1660592 | 2021-08-27 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1648835 | 1648835 | 2021-08-24 | Natchitoches | Louisiana | 22069 | 5175 | 103 |
1628665 | 1628665 | 2021-08-18 | Liberty | Georgia | 13179 | 5175 | 73 |
1624658 | 1624658 | 2021-08-16 | Fauquier | Virginia | 51061 | 5175 | 71 |
1611448 | 1611448 | 2021-08-12 | Jim Wells | Texas | 48249 | 5175 | 112 |
1560525 | 1560525 | 2021-07-28 | Maui | Hawaii | 15009 | 5175 | 60 |
1452311 | 1452311 | 2021-06-24 | Harrison | Texas | 48203 | 5175 | 110 |
1437484 | 1437484 | 2021-06-20 | Sioux | Iowa | 19167 | 5175 | 74 |
1422783 | 1422783 | 2021-06-15 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1419537 | 1419537 | 2021-06-14 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1416292 | 1416292 | 2021-06-13 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1413046 | 1413046 | 2021-06-12 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1409801 | 1409801 | 2021-06-11 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1406556 | 1406556 | 2021-06-10 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1403310 | 1403310 | 2021-06-09 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1341477 | 1341477 | 2021-05-21 | Linn | Oregon | 41043 | 5175 | 72 |
1312152 | 1312152 | 2021-05-12 | Washington | Ohio | 39167 | 5175 | 109 |
1286398 | 1286398 | 2021-05-04 | Guaynabo | Puerto Rico | 72061 | 5175 | |
1284021 | 1284021 | 2021-05-03 | Fremont | Wyoming | 56013 | 5175 | 84 |
1280774 | 1280774 | 2021-05-02 | Fremont | Wyoming | 56013 | 5175 | 84 |
1277527 | 1277527 | 2021-05-01 | Fremont | Wyoming | 56013 | 5175 | 84 |
1274280 | 1274280 | 2021-04-30 | Fremont | Wyoming | 56013 | 5175 | 84 |
1266419 | 1266419 | 2021-04-28 | Genesee | New York | 36037 | 5175 | 121 |
1203665 | 1203665 | 2021-04-09 | Cerro Gordo | Iowa | 19033 | 5175 | 86 |
1188690 | 1188690 | 2021-04-04 | Darke | Ohio | 39037 | 5175 | 121 |
1185443 | 1185443 | 2021-04-03 | Darke | Ohio | 39037 | 5175 | 121 |
1181500 | 1181500 | 2021-04-02 | Otter Tail | Minnesota | 27111 | 5175 | 72 |
1173586 | 1173586 | 2021-03-30 | Shawano | Wisconsin | 55115 | 5175 | 81 |
1161972 | 1161972 | 2021-03-27 | Chisago | Minnesota | 27025 | 5175 | 48 |
1162238 | 1162238 | 2021-03-27 | Taney | Missouri | 29213 | 5175 | 90 |
1158990 | 1158990 | 2021-03-26 | Taney | Missouri | 29213 | 5175 | 90 |
1147534 | 1147534 | 2021-03-22 | Raleigh | West Virginia | 54081 | 5175 | 67 |
1122430 | 1122430 | 2021-03-15 | Noble | Indiana | 18113 | 5175 | 82 |
1106604 | 1106604 | 2021-03-10 | St. Charles | Louisiana | 22089 | 5175 | 90 |
1101085 | 1101085 | 2021-03-08 | Union | Ohio | 39159 | 5175 | 41 |
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);