ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 3823 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 8
- Indiana 8
- Missouri 8
- North Carolina 8
- Texas 7
- Georgia 6
- Kentucky 6
- Ohio 6
- Alabama 5
- South Carolina 5
- Virginia 5
- Iowa 4
- Pennsylvania 4
- Tennessee 4
- Arkansas 3
- Louisiana 3
- Minnesota 3
- New York 3
- Wisconsin 3
- Idaho 2
- Kansas 2
- Nebraska 2
- Puerto Rico 2
- Alaska 1
- California 1
- Colorado 1
- Connecticut 1
- Florida 1
- New Jersey 1
- North Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475923 | 2475923 | 2022-05-05 | Utuado | Puerto Rico | 72141 | 3823 | |
2450740 | 2450740 | 2022-04-28 | Crenshaw | Alabama | 1041 | 3823 | 99 |
2309139 | 2309139 | 2022-03-15 | Wright | Missouri | 29229 | 3823 | 80 |
2305887 | 2305887 | 2022-03-14 | Wright | Missouri | 29229 | 3823 | 79 |
2302636 | 2302636 | 2022-03-13 | Wright | Missouri | 29229 | 3823 | 79 |
2303002 | 2303002 | 2022-03-13 | Polk | North Carolina | 37149 | 3823 | 53 |
2299384 | 2299384 | 2022-03-12 | Wright | Missouri | 29229 | 3823 | 79 |
2299750 | 2299750 | 2022-03-12 | Polk | North Carolina | 37149 | 3823 | 53 |
2296132 | 2296132 | 2022-03-11 | Wright | Missouri | 29229 | 3823 | 79 |
2296498 | 2296498 | 2022-03-11 | Polk | North Carolina | 37149 | 3823 | 53 |
2258200 | 2258200 | 2022-02-27 | Freestone | Texas | 48161 | 3823 | 82 |
2254949 | 2254949 | 2022-02-26 | Freestone | Texas | 48161 | 3823 | 82 |
2246331 | 2246331 | 2022-02-24 | Minidoka | Idaho | 16067 | 3823 | 58 |
2232261 | 2232261 | 2022-02-19 | Llano | Texas | 48299 | 3823 | 91 |
2225963 | 2225963 | 2022-02-17 | Grayson | Virginia | 51077 | 3823 | 75 |
2219875 | 2219875 | 2022-02-16 | Izard | Arkansas | 5065 | 3823 | 63 |
2172987 | 2172987 | 2022-02-01 | Richland | North Dakota | 38077 | 3823 | 21 |
2165583 | 2165583 | 2022-01-30 | LaSalle | Louisiana | 22059 | 3823 | 48 |
2162328 | 2162328 | 2022-01-29 | LaSalle | Louisiana | 22059 | 3823 | 48 |
2159073 | 2159073 | 2022-01-28 | LaSalle | Louisiana | 22059 | 3823 | 48 |
2142293 | 2142293 | 2022-01-23 | Hancock | Illinois | 17067 | 3823 | 53 |
2142699 | 2142699 | 2022-01-23 | Garrard | Kentucky | 21079 | 3823 | 61 |
2139038 | 2139038 | 2022-01-22 | Hancock | Illinois | 17067 | 3823 | 53 |
2139444 | 2139444 | 2022-01-22 | Garrard | Kentucky | 21079 | 3823 | 61 |
2135782 | 2135782 | 2022-01-21 | Hancock | Illinois | 17067 | 3823 | 53 |
2136188 | 2136188 | 2022-01-21 | Garrard | Kentucky | 21079 | 3823 | 61 |
2110046 | 2110046 | 2022-01-13 | Dickinson | Kansas | 20041 | 3823 | 63 |
2106795 | 2106795 | 2022-01-12 | Dickinson | Kansas | 20041 | 3823 | 63 |
2101381 | 2101381 | 2022-01-10 | Yancey | North Carolina | 37199 | 3823 | 37 |
2092306 | 2092306 | 2022-01-07 | Deaf Smith | Texas | 48117 | 3823 | 101 |
2081222 | 2081222 | 2022-01-04 | Hubbard | Minnesota | 27057 | 3823 | 51 |
2036996 | 2036996 | 2021-12-21 | Austin | Texas | 48015 | 3823 | 57 |
1963150 | 1963150 | 2021-11-29 | Routt | Colorado | 8107 | 3823 | 23 |
1891807 | 1891807 | 2021-11-07 | Haralson | Georgia | 13143 | 3823 | 120 |
1892115 | 1892115 | 2021-11-07 | Posey | Indiana | 18129 | 3823 | 44 |
1893205 | 1893205 | 2021-11-07 | Delaware | New York | 36025 | 3823 | 49 |
1894384 | 1894384 | 2021-11-07 | Russell | Virginia | 51167 | 3823 | 64 |
1888557 | 1888557 | 2021-11-06 | Haralson | Georgia | 13143 | 3823 | 120 |
1888865 | 1888865 | 2021-11-06 | Posey | Indiana | 18129 | 3823 | 44 |
1891134 | 1891134 | 2021-11-06 | Russell | Virginia | 51167 | 3823 | 64 |
1885307 | 1885307 | 2021-11-05 | Haralson | Georgia | 13143 | 3823 | 120 |
1885615 | 1885615 | 2021-11-05 | Posey | Indiana | 18129 | 3823 | 44 |
1887884 | 1887884 | 2021-11-05 | Russell | Virginia | 51167 | 3823 | 64 |
1882058 | 1882058 | 2021-11-04 | Haralson | Georgia | 13143 | 3823 | 120 |
1802656 | 1802656 | 2021-10-10 | Elk | Pennsylvania | 42047 | 3823 | 51 |
1768460 | 1768460 | 2021-09-30 | Jerome | Idaho | 16053 | 3823 | 38 |
1759733 | 1759733 | 2021-09-27 | Stone | Missouri | 29209 | 3823 | 78 |
1749950 | 1749950 | 2021-09-24 | Miller | Missouri | 29131 | 3823 | 73 |
1732853 | 1732853 | 2021-09-19 | Clay | Indiana | 18021 | 3823 | 56 |
1729603 | 1729603 | 2021-09-18 | Clay | Indiana | 18021 | 3823 | 56 |
1726353 | 1726353 | 2021-09-17 | Clay | Indiana | 18021 | 3823 | 56 |
1724946 | 1724946 | 2021-09-16 | Grainger | Tennessee | 47057 | 3823 | 54 |
1709596 | 1709596 | 2021-09-12 | Glenn | California | 6021 | 3823 | 31 |
1710038 | 1710038 | 2021-09-12 | Iroquois | Illinois | 17075 | 3823 | 72 |
1706791 | 1706791 | 2021-09-11 | Iroquois | Illinois | 17075 | 3823 | 72 |
1703543 | 1703543 | 2021-09-10 | Iroquois | Illinois | 17075 | 3823 | 72 |
1665894 | 1665894 | 2021-08-29 | Pasquotank | North Carolina | 37139 | 3823 | 88 |
1662646 | 1662646 | 2021-08-28 | Pasquotank | North Carolina | 37139 | 3823 | 88 |
1659398 | 1659398 | 2021-08-27 | Pasquotank | North Carolina | 37139 | 3823 | 88 |
1656029 | 1656029 | 2021-08-26 | Chenango | New York | 36017 | 3823 | 82 |
1653246 | 1653246 | 2021-08-25 | Snyder | Pennsylvania | 42109 | 3823 | 87 |
1643632 | 1643632 | 2021-08-22 | Marlboro | South Carolina | 45069 | 3823 | 61 |
1640382 | 1640382 | 2021-08-21 | Marlboro | South Carolina | 45069 | 3823 | 61 |
1637132 | 1637132 | 2021-08-20 | Marlboro | South Carolina | 45069 | 3823 | 61 |
1625125 | 1625125 | 2021-08-17 | Yell | Arkansas | 5149 | 3823 | 66 |
1617293 | 1617293 | 2021-08-14 | Highland | Ohio | 39071 | 3823 | 69 |
1611862 | 1611862 | 2021-08-12 | Clark | Wisconsin | 55019 | 3823 | 66 |
1607574 | 1607574 | 2021-08-11 | Ottawa | Ohio | 39123 | 3823 | 82 |
1595717 | 1595717 | 2021-08-08 | Clarke | Alabama | 1025 | 3823 | 63 |
1592468 | 1592468 | 2021-08-07 | Clarke | Alabama | 1025 | 3823 | 63 |
1562400 | 1562400 | 2021-07-28 | Colleton | South Carolina | 45029 | 3823 | 134 |
1534659 | 1534659 | 2021-07-20 | Montgomery | Illinois | 17135 | 3823 | 80 |
1531412 | 1531412 | 2021-07-19 | Montgomery | Illinois | 17135 | 3823 | 80 |
1532304 | 1532304 | 2021-07-19 | Marion | Missouri | 29127 | 3823 | 53 |
1452782 | 1452782 | 2021-06-24 | Oneida | Wisconsin | 55085 | 3823 | 78 |
1440703 | 1440703 | 2021-06-21 | Lee | Iowa | 19111 | 3823 | 56 |
1437456 | 1437456 | 2021-06-20 | Lee | Iowa | 19111 | 3823 | 56 |
1434209 | 1434209 | 2021-06-19 | Lee | Iowa | 19111 | 3823 | 56 |
1427718 | 1427718 | 2021-06-17 | Lee | Iowa | 19111 | 3823 | 56 |
1358028 | 1358028 | 2021-05-26 | Henderson | Tennessee | 47077 | 3823 | 76 |
1341356 | 1341356 | 2021-05-21 | Preble | Ohio | 39135 | 3823 | 101 |
1312113 | 1312113 | 2021-05-12 | Logan | Ohio | 39091 | 3823 | 76 |
1308485 | 1308485 | 2021-05-11 | Lincoln | Nebraska | 31111 | 3823 | 57 |
1308866 | 1308866 | 2021-05-11 | Logan | Ohio | 39091 | 3823 | 76 |
1293890 | 1293890 | 2021-05-07 | Boone | Arkansas | 5009 | 3823 | 80 |
1287055 | 1287055 | 2021-05-04 | Petersburg city | Virginia | 51730 | 3823 | 84 |
1213077 | 1213077 | 2021-04-12 | Liberty | Georgia | 13179 | 3823 | 60 |
1210723 | 1210723 | 2021-04-11 | McLeod | Minnesota | 27085 | 3823 | 54 |
1135695 | 1135695 | 2021-03-19 | Franklin | Kentucky | 21073 | 3823 | 40 |
1088419 | 1088419 | 2021-03-04 | Williamsburg | South Carolina | 45089 | 3823 | 92 |
1079804 | 1079804 | 2021-03-02 | DeSoto | Florida | 12027 | 3823 | 75 |
1065640 | 1065640 | 2021-02-25 | Toa Baja | Puerto Rico | 72137 | 3823 | |
1015292 | 1015292 | 2021-02-10 | Harrison | Indiana | 18061 | 3823 | 62 |
1004799 | 1004799 | 2021-02-06 | Albany | Wyoming | 56001 | 3823 | 11 |
993760 | 993760 | 2021-02-03 | Chatham | North Carolina | 37037 | 3823 | 70 |
990441 | 990441 | 2021-02-02 | Cattaraugus | New York | 36009 | 3823 | 68 |
968140 | 968140 | 2021-01-26 | Bradford | Pennsylvania | 42015 | 3823 | 65 |
957226 | 957226 | 2021-01-23 | Nelson | Kentucky | 21179 | 3823 | 23 |
940657 | 940657 | 2021-01-18 | Lawrence | Indiana | 18093 | 3823 | 78 |
917145 | 917145 | 2021-01-10 | Pierce | Wisconsin | 55093 | 3823 | 35 |
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);