ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where cases = 4269 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Iowa 13
- Georgia 12
- New York 7
- Texas 7
- Illinois 6
- Kansas 6
- Louisiana 6
- Indiana 5
- Kentucky 4
- Michigan 4
- Virginia 4
- Utah 3
- Washington 3
- Arkansas 2
- Minnesota 2
- Missouri 2
- Ohio 2
- Alabama 1
- California 1
- Colorado 1
- Maine 1
- Maryland 1
- Mississippi 1
- Montana 1
- North Carolina 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492575 | 2492575 | 2022-05-10 | Lavaca | Texas | 48285 | 4269 | 120 |
2486061 | 2486061 | 2022-05-08 | Lee | Texas | 48287 | 4269 | 60 |
2482803 | 2482803 | 2022-05-07 | Lee | Texas | 48287 | 4269 | 60 |
2479545 | 2479545 | 2022-05-06 | Lee | Texas | 48287 | 4269 | 60 |
2476536 | 2476536 | 2022-05-05 | Nottoway | Virginia | 51135 | 4269 | 91 |
2476686 | 2476686 | 2022-05-05 | Crawford | Wisconsin | 55023 | 4269 | 28 |
2379384 | 2379384 | 2022-04-06 | Otero | Colorado | 8089 | 4269 | 126 |
2308423 | 2308423 | 2022-03-15 | Atchison | Kansas | 20005 | 4269 | 33 |
2305172 | 2305172 | 2022-03-14 | Atchison | Kansas | 20005 | 4269 | 33 |
2279505 | 2279505 | 2022-03-06 | Antrim | Michigan | 26009 | 4269 | 61 |
2276252 | 2276252 | 2022-03-05 | Antrim | Michigan | 26009 | 4269 | 61 |
2272999 | 2272999 | 2022-03-04 | Antrim | Michigan | 26009 | 4269 | 61 |
2269747 | 2269747 | 2022-03-03 | Antrim | Michigan | 26009 | 4269 | 60 |
2244460 | 2244460 | 2022-02-23 | Northampton | North Carolina | 37131 | 4269 | 78 |
2226046 | 2226046 | 2022-02-17 | Asotin | Washington | 53003 | 4269 | 58 |
2220797 | 2220797 | 2022-02-16 | Lawrence | Kentucky | 21127 | 4269 | 56 |
2222795 | 2222795 | 2022-02-16 | Asotin | Washington | 53003 | 4269 | 58 |
2206862 | 2206862 | 2022-02-12 | Grant | Arkansas | 5053 | 4269 | 55 |
2171762 | 2171762 | 2022-02-01 | Crawford | Iowa | 19047 | 4269 | 50 |
2168509 | 2168509 | 2022-01-31 | Crawford | Iowa | 19047 | 4269 | 50 |
2164941 | 2164941 | 2022-01-30 | Putnam | Georgia | 13237 | 4269 | 92 |
2165254 | 2165254 | 2022-01-30 | Crawford | Iowa | 19047 | 4269 | 50 |
2161686 | 2161686 | 2022-01-29 | Putnam | Georgia | 13237 | 4269 | 92 |
2161999 | 2161999 | 2022-01-29 | Crawford | Iowa | 19047 | 4269 | 50 |
2158430 | 2158430 | 2022-01-28 | Putnam | Georgia | 13237 | 4269 | 92 |
2158744 | 2158744 | 2022-01-28 | Crawford | Iowa | 19047 | 4269 | 50 |
2155490 | 2155490 | 2022-01-27 | Crawford | Iowa | 19047 | 4269 | 50 |
2152237 | 2152237 | 2022-01-26 | Crawford | Iowa | 19047 | 4269 | 50 |
2130533 | 2130533 | 2022-01-19 | Schoharie | New York | 36095 | 4269 | 32 |
2119036 | 2119036 | 2022-01-16 | Logan | Arkansas | 5083 | 4269 | 56 |
2056918 | 2056918 | 2021-12-27 | Winchester city | Virginia | 51840 | 4269 | 57 |
2035050 | 2035050 | 2021-12-21 | Shelby | Illinois | 17173 | 4269 | 57 |
2035468 | 2035468 | 2021-12-21 | Russell | Kentucky | 21207 | 4269 | 65 |
2000209 | 2000209 | 2021-12-10 | Stone | Missouri | 29209 | 4269 | 100 |
1998108 | 1998108 | 2021-12-09 | Karnes | Texas | 48255 | 4269 | 58 |
1968200 | 1968200 | 2021-11-30 | Henry | Ohio | 39069 | 4269 | 78 |
1937337 | 1937337 | 2021-11-21 | Monroe | Georgia | 13207 | 4269 | 151 |
1934087 | 1934087 | 2021-11-20 | Monroe | Georgia | 13207 | 4269 | 151 |
1930835 | 1930835 | 2021-11-19 | Monroe | Georgia | 13207 | 4269 | 151 |
1914613 | 1914613 | 2021-11-14 | Sumter | Georgia | 13261 | 4269 | 137 |
1911363 | 1911363 | 2021-11-13 | Sumter | Georgia | 13261 | 4269 | 137 |
1908114 | 1908114 | 2021-11-12 | Sumter | Georgia | 13261 | 4269 | 137 |
1879986 | 1879986 | 2021-11-03 | Lake | Montana | 30047 | 4269 | 67 |
1872571 | 1872571 | 2021-11-01 | Decatur | Indiana | 18031 | 4269 | 110 |
1826400 | 1826400 | 2021-10-18 | Lawrence | Alabama | 1079 | 4269 | 117 |
1824275 | 1824275 | 2021-10-17 | Richland | Louisiana | 22083 | 4269 | 77 |
1821026 | 1821026 | 2021-10-16 | Richland | Louisiana | 22083 | 4269 | 77 |
1817777 | 1817777 | 2021-10-15 | Richland | Louisiana | 22083 | 4269 | 77 |
1814459 | 1814459 | 2021-10-14 | Ohio | Kentucky | 21183 | 4269 | 78 |
1791397 | 1791397 | 2021-10-07 | Scott | Indiana | 18143 | 4269 | 70 |
1787188 | 1787188 | 2021-10-05 | Clallam | Washington | 53009 | 4269 | 49 |
1758848 | 1758848 | 2021-09-27 | Daviess | Indiana | 18027 | 4269 | 111 |
1697882 | 1697882 | 2021-09-08 | Scott | Mississippi | 28123 | 4269 | 89 |
1671082 | 1671082 | 2021-08-31 | Montgomery | Illinois | 17135 | 4269 | 80 |
1643038 | 1643038 | 2021-08-22 | Columbia | New York | 36021 | 4269 | 105 |
1644080 | 1644080 | 2021-08-22 | Sanpete | Utah | 49039 | 4269 | 25 |
1640830 | 1640830 | 2021-08-21 | Sanpete | Utah | 49039 | 4269 | 25 |
1637580 | 1637580 | 2021-08-20 | Sanpete | Utah | 49039 | 4269 | 25 |
1606512 | 1606512 | 2021-08-11 | Knox | Kentucky | 21121 | 4269 | 47 |
1603115 | 1603115 | 2021-08-10 | Cowley | Kansas | 20035 | 4269 | 109 |
1599866 | 1599866 | 2021-08-09 | Cowley | Kansas | 20035 | 4269 | 109 |
1565752 | 1565752 | 2021-07-29 | Campbell | Tennessee | 47013 | 4269 | 62 |
1562224 | 1562224 | 2021-07-28 | Polk | Oregon | 41053 | 4269 | 57 |
1539111 | 1539111 | 2021-07-21 | Montgomery | New York | 36057 | 4269 | 128 |
1535864 | 1535864 | 2021-07-20 | Montgomery | New York | 36057 | 4269 | 128 |
1464148 | 1464148 | 2021-06-28 | Platte | Missouri | 29165 | 4269 | 48 |
1465347 | 1465347 | 2021-06-28 | Matagorda | Texas | 48321 | 4269 | 114 |
1440658 | 1440658 | 2021-06-21 | Buena Vista | Iowa | 19021 | 4269 | 40 |
1437411 | 1437411 | 2021-06-20 | Buena Vista | Iowa | 19021 | 4269 | 40 |
1434164 | 1434164 | 2021-06-19 | Buena Vista | Iowa | 19021 | 4269 | 40 |
1430918 | 1430918 | 2021-06-18 | Buena Vista | Iowa | 19021 | 4269 | 40 |
1424428 | 1424428 | 2021-06-16 | Buena Vista | Iowa | 19021 | 4269 | 40 |
1383855 | 1383855 | 2021-06-03 | Chester | South Carolina | 45023 | 4269 | 76 |
1340599 | 1340599 | 2021-05-21 | McLeod | Minnesota | 27085 | 4269 | 59 |
1336738 | 1336738 | 2021-05-20 | Montgomery | Indiana | 18107 | 4269 | 91 |
1331572 | 1331572 | 2021-05-18 | Fulton | Ohio | 39051 | 4269 | 70 |
1203520 | 1203520 | 2021-04-09 | Monroe | Illinois | 17133 | 4269 | 90 |
1153760 | 1153760 | 2021-03-24 | Wilson | Texas | 48493 | 4269 | 66 |
1149056 | 1149056 | 2021-03-23 | Winona | Minnesota | 27169 | 4269 | 49 |
1129314 | 1129314 | 2021-03-17 | Lincoln | Louisiana | 22061 | 4269 | 91 |
1122196 | 1122196 | 2021-03-15 | Thomas | Georgia | 13275 | 4269 | 116 |
1124654 | 1124654 | 2021-03-15 | Henry | Virginia | 51089 | 4269 | 120 |
1118949 | 1118949 | 2021-03-14 | Thomas | Georgia | 13275 | 4269 | 116 |
1096351 | 1096351 | 2021-03-07 | Livingston | Illinois | 17105 | 4269 | 91 |
1048862 | 1048862 | 2021-02-20 | Cattaraugus | New York | 36009 | 4269 | 76 |
1000378 | 1000378 | 2021-02-05 | Stark | North Dakota | 38089 | 4269 | 48 |
976792 | 976792 | 2021-01-29 | Androscoggin | Maine | 23001 | 4269 | 53 |
934588 | 934588 | 2021-01-16 | St. Martin | Louisiana | 22099 | 4269 | 94 |
931343 | 931343 | 2021-01-15 | St. Martin | Louisiana | 22099 | 4269 | 94 |
931383 | 931383 | 2021-01-15 | Cecil | Maryland | 24015 | 4269 | 88 |
883376 | 883376 | 2020-12-31 | Rensselaer | New York | 36083 | 4269 | 81 |
817281 | 817281 | 2020-12-11 | Whiteside | Illinois | 17195 | 4269 | 149 |
814035 | 814035 | 2020-12-10 | Whiteside | Illinois | 17195 | 4269 | 146 |
814283 | 814283 | 2020-12-10 | Leavenworth | Kansas | 20103 | 4269 | 34 |
811038 | 811038 | 2020-12-09 | Leavenworth | Kansas | 20103 | 4269 | 34 |
771383 | 771383 | 2020-11-27 | Santa Cruz | California | 6087 | 4269 | 28 |
752423 | 752423 | 2020-11-21 | Kosciusko | Indiana | 18085 | 4269 | 40 |
676744 | 676744 | 2020-10-28 | Alexandria city | Virginia | 51510 | 4269 | 74 |
323703 | 323703 | 2020-07-11 | Dutchess | New York | 36027 | 4269 | 160 |
268630 | 268630 | 2020-06-24 | Cobb | Georgia | 13067 | 4269 | 236 |
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);