ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where cases = 5290 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 9
- Kentucky 8
- Oklahoma 8
- Virginia 8
- Indiana 7
- Illinois 6
- South Dakota 5
- Ohio 4
- Arkansas 3
- Missouri 3
- Oregon 3
- Alabama 2
- Minnesota 2
- New Mexico 2
- North Dakota 2
- Puerto Rico 2
- South Carolina 2
- Texas 2
- Wyoming 2
- Arizona 1
- California 1
- Georgia 1
- Iowa 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Montana 1
- Nevada 1
- New Jersey 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491634 | 2491634 | 2022-05-10 | Lincoln | New Mexico | 35027 | 5290 | 67 |
2468696 | 2468696 | 2022-05-03 | Dawson | Nebraska | 31047 | 5290 | 44 |
2465440 | 2465440 | 2022-05-02 | Dawson | Nebraska | 31047 | 5290 | 44 |
2462185 | 2462185 | 2022-05-01 | Dawson | Nebraska | 31047 | 5290 | 44 |
2458929 | 2458929 | 2022-04-30 | Dawson | Nebraska | 31047 | 5290 | 44 |
2455673 | 2455673 | 2022-04-29 | Dawson | Nebraska | 31047 | 5290 | 44 |
2452417 | 2452417 | 2022-04-28 | Dawson | Nebraska | 31047 | 5290 | 44 |
2449161 | 2449161 | 2022-04-27 | Dawson | Nebraska | 31047 | 5290 | 44 |
2445904 | 2445904 | 2022-04-26 | Dawson | Nebraska | 31047 | 5290 | 44 |
2442649 | 2442649 | 2022-04-25 | Dawson | Nebraska | 31047 | 5290 | 44 |
2430278 | 2430278 | 2022-04-21 | Cabo Rojo | Puerto Rico | 72023 | 5290 | |
2383047 | 2383047 | 2022-04-07 | Wayne | Illinois | 17191 | 5290 | 85 |
2385328 | 2385328 | 2022-04-07 | Fredericksburg city | Virginia | 51630 | 5290 | 41 |
2379792 | 2379792 | 2022-04-06 | Wayne | Illinois | 17191 | 5290 | 85 |
2376538 | 2376538 | 2022-04-05 | Wayne | Illinois | 17191 | 5290 | 85 |
2369483 | 2369483 | 2022-04-03 | Lawrence | Arkansas | 5075 | 5290 | 76 |
2325637 | 2325637 | 2022-03-20 | Taos | New Mexico | 35055 | 5290 | 89 |
2303997 | 2303997 | 2022-03-13 | Fredericksburg city | Virginia | 51630 | 5290 | 35 |
2300745 | 2300745 | 2022-03-12 | Fredericksburg city | Virginia | 51630 | 5290 | 35 |
2297493 | 2297493 | 2022-03-11 | Fredericksburg city | Virginia | 51630 | 5290 | 35 |
2262119 | 2262119 | 2022-03-01 | Columbia | Arkansas | 5027 | 5290 | 87 |
2233738 | 2233738 | 2022-02-20 | Adair | Kentucky | 21001 | 5290 | 96 |
2230487 | 2230487 | 2022-02-19 | Adair | Kentucky | 21001 | 5290 | 96 |
2227236 | 2227236 | 2022-02-18 | Adair | Kentucky | 21001 | 5290 | 96 |
2177216 | 2177216 | 2022-02-02 | Page | Virginia | 51139 | 5290 | 97 |
2149233 | 2149233 | 2022-01-25 | Letcher | Kentucky | 21133 | 5290 | 87 |
2133350 | 2133350 | 2022-01-20 | Leake | Mississippi | 28079 | 5290 | 92 |
2134896 | 2134896 | 2022-01-20 | Louisa | Virginia | 51109 | 5290 | 53 |
2125323 | 2125323 | 2022-01-17 | Kewaunee | Wisconsin | 55061 | 5290 | 51 |
2110464 | 2110464 | 2022-01-13 | Brown | Minnesota | 27015 | 5290 | 69 |
2060239 | 2060239 | 2021-12-28 | Mingo | West Virginia | 54059 | 5290 | 98 |
2031279 | 2031279 | 2021-12-20 | Poinsett | Arkansas | 5111 | 5290 | 104 |
1969130 | 1969130 | 2021-11-30 | Prince George | Virginia | 51149 | 5290 | 51 |
1937550 | 1937550 | 2021-11-21 | Adams | Indiana | 18001 | 5290 | 81 |
1934300 | 1934300 | 2021-11-20 | Adams | Indiana | 18001 | 5290 | 81 |
1931049 | 1931049 | 2021-11-19 | Adams | Indiana | 18001 | 5290 | 81 |
1901839 | 1901839 | 2021-11-10 | Jefferson | Indiana | 18077 | 5290 | 103 |
1869269 | 1869269 | 2021-10-31 | Monroe | Illinois | 17133 | 5290 | 104 |
1870185 | 1870185 | 2021-10-31 | Pulaski | Missouri | 29169 | 5290 | 79 |
1866020 | 1866020 | 2021-10-30 | Monroe | Illinois | 17133 | 5290 | 104 |
1862771 | 1862771 | 2021-10-29 | Monroe | Illinois | 17133 | 5290 | 104 |
1845244 | 1845244 | 2021-10-23 | Bee | Texas | 48025 | 5290 | 127 |
1832560 | 1832560 | 2021-10-19 | Charlottesville city | Virginia | 51540 | 5290 | 60 |
1806094 | 1806094 | 2021-10-11 | Codington | South Dakota | 46029 | 5290 | 83 |
1802844 | 1802844 | 2021-10-10 | Codington | South Dakota | 46029 | 5290 | 83 |
1799595 | 1799595 | 2021-10-09 | Codington | South Dakota | 46029 | 5290 | 83 |
1796346 | 1796346 | 2021-10-08 | Codington | South Dakota | 46029 | 5290 | 83 |
1781985 | 1781985 | 2021-10-04 | Taylor | Kentucky | 21217 | 5290 | 76 |
1778735 | 1778735 | 2021-10-03 | Taylor | Kentucky | 21217 | 5290 | 76 |
1775485 | 1775485 | 2021-10-02 | Taylor | Kentucky | 21217 | 5290 | 76 |
1677667 | 1677667 | 2021-09-02 | Montgomery | Indiana | 18107 | 5290 | 98 |
1666174 | 1666174 | 2021-08-29 | Polk | Oregon | 41053 | 5290 | 62 |
1662926 | 1662926 | 2021-08-28 | Polk | Oregon | 41053 | 5290 | 62 |
1659678 | 1659678 | 2021-08-27 | Polk | Oregon | 41053 | 5290 | 62 |
1646498 | 1646498 | 2021-08-23 | Auglaize | Ohio | 39011 | 5290 | 87 |
1539006 | 1539006 | 2021-07-21 | Elko | Nevada | 32007 | 5290 | 60 |
1493360 | 1493360 | 2021-07-07 | Pettis | Missouri | 29159 | 5290 | 77 |
1446326 | 1446326 | 2021-06-22 | Fremont | Wyoming | 56013 | 5290 | 86 |
1425982 | 1425982 | 2021-06-16 | Guaynabo | Puerto Rico | 72061 | 5290 | |
1338014 | 1338014 | 2021-05-20 | Morton | North Dakota | 38059 | 5290 | 100 |
1311612 | 1311612 | 2021-05-12 | Taney | Missouri | 29213 | 5290 | 92 |
1308894 | 1308894 | 2021-05-11 | Seneca | Ohio | 39147 | 5290 | 121 |
1263493 | 1263493 | 2021-04-27 | Kay | Oklahoma | 40071 | 5290 | 125 |
1260246 | 1260246 | 2021-04-26 | Kay | Oklahoma | 40071 | 5290 | 125 |
1256999 | 1256999 | 2021-04-25 | Kay | Oklahoma | 40071 | 5290 | 125 |
1253752 | 1253752 | 2021-04-24 | Kay | Oklahoma | 40071 | 5290 | 125 |
1250505 | 1250505 | 2021-04-23 | Kay | Oklahoma | 40071 | 5290 | 125 |
1246327 | 1246327 | 2021-04-22 | Branch | Michigan | 26023 | 5290 | 116 |
1247258 | 1247258 | 2021-04-22 | Kay | Oklahoma | 40071 | 5290 | 125 |
1244011 | 1244011 | 2021-04-21 | Kay | Oklahoma | 40071 | 5290 | 125 |
1200029 | 1200029 | 2021-04-08 | Coffee | Georgia | 13069 | 5290 | 168 |
1200423 | 1200423 | 2021-04-08 | Clinton | Iowa | 19045 | 5290 | 89 |
1190618 | 1190618 | 2021-04-05 | Noble | Indiana | 18113 | 5290 | 84 |
1185172 | 1185172 | 2021-04-03 | Salem | New Jersey | 34033 | 5290 | 170 |
1172843 | 1172843 | 2021-03-30 | Brown | South Dakota | 46013 | 5290 | 91 |
1165948 | 1165948 | 2021-03-28 | Belmont | Ohio | 39013 | 5290 | 159 |
1123014 | 1123014 | 2021-03-15 | Crow Wing | Minnesota | 27035 | 5290 | 85 |
1118439 | 1118439 | 2021-03-14 | Coffee | Alabama | 1031 | 5290 | 105 |
1073078 | 1073078 | 2021-02-28 | Graham | Arizona | 4009 | 5290 | 73 |
974804 | 974804 | 2021-01-28 | Laurens | South Carolina | 45059 | 5290 | 121 |
929019 | 929019 | 2021-01-14 | Hancock | Ohio | 39063 | 5290 | 88 |
856323 | 856323 | 2020-12-23 | Wayne | Indiana | 18177 | 5290 | 133 |
846870 | 846870 | 2020-12-20 | Madison | Kentucky | 21151 | 5290 | 26 |
833052 | 833052 | 2020-12-16 | Sutter | California | 6101 | 5290 | 38 |
834026 | 834026 | 2020-12-16 | Charles | Maryland | 24017 | 5290 | 115 |
805247 | 805247 | 2020-12-07 | Missoula | Montana | 30063 | 5290 | 45 |
787366 | 787366 | 2020-12-01 | Laramie | Wyoming | 56021 | 5290 | 26 |
728986 | 728986 | 2020-11-14 | Etowah | Alabama | 1055 | 5290 | 61 |
721282 | 721282 | 2020-11-11 | Ward | North Dakota | 38101 | 5290 | 85 |
634072 | 634072 | 2020-10-15 | Florence | South Carolina | 45041 | 5290 | 199 |
611769 | 611769 | 2020-10-08 | Smith | Texas | 48423 | 5290 | 112 |
543050 | 543050 | 2020-09-17 | Cleveland | Oklahoma | 40027 | 5290 | 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);