ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where cases = 4590 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 13
- Oklahoma 8
- Florida 7
- Arkansas 6
- Nevada 6
- Ohio 6
- Colorado 4
- Georgia 4
- Louisiana 4
- Michigan 4
- Alabama 3
- Illinois 3
- Kentucky 3
- Minnesota 3
- Nebraska 3
- New York 3
- Puerto Rico 3
- West Virginia 3
- California 2
- Indiana 2
- Iowa 2
- Mississippi 2
- North Carolina 2
- Oregon 2
- Pennsylvania 2
- Virginia 2
- Washington 2
- Wisconsin 2
- Wyoming 2
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415157 | 2415157 | 2022-04-17 | Chaffee | Colorado | 8015 | 4590 | 44 |
2411901 | 2411901 | 2022-04-16 | Chaffee | Colorado | 8015 | 4590 | 44 |
2408645 | 2408645 | 2022-04-15 | Chaffee | Colorado | 8015 | 4590 | 44 |
2358558 | 2358558 | 2022-03-30 | Clatsop | Oregon | 41007 | 4590 | 46 |
2348950 | 2348950 | 2022-03-27 | Morovis | Puerto Rico | 72101 | 4590 | |
2316853 | 2316853 | 2022-03-17 | Reeves | Texas | 48389 | 4590 | 73 |
2313600 | 2313600 | 2022-03-16 | Reeves | Texas | 48389 | 4590 | 73 |
2310347 | 2310347 | 2022-03-15 | Reeves | Texas | 48389 | 4590 | 73 |
2307094 | 2307094 | 2022-03-14 | Reeves | Texas | 48389 | 4590 | 73 |
2302336 | 2302336 | 2022-03-13 | Roscommon | Michigan | 26143 | 4590 | 111 |
2303843 | 2303843 | 2022-03-13 | Reeves | Texas | 48389 | 4590 | 73 |
2299084 | 2299084 | 2022-03-12 | Roscommon | Michigan | 26143 | 4590 | 111 |
2295832 | 2295832 | 2022-03-11 | Roscommon | Michigan | 26143 | 4590 | 111 |
2296861 | 2296861 | 2022-03-11 | Barranquitas | Puerto Rico | 72019 | 4590 | |
2291442 | 2291442 | 2022-03-10 | Sharp | Arkansas | 5135 | 4590 | 100 |
2291875 | 2291875 | 2022-03-10 | Cass | Illinois | 17017 | 4590 | 44 |
2268478 | 2268478 | 2022-03-02 | Carbon | Wyoming | 56007 | 4590 | 51 |
2200524 | 2200524 | 2022-02-10 | Teller | Colorado | 8119 | 4590 | 55 |
2197094 | 2197094 | 2022-02-09 | Cross | Arkansas | 5037 | 4590 | 75 |
2171113 | 2171113 | 2022-02-01 | Randolph | Arkansas | 5121 | 4590 | 73 |
2167559 | 2167559 | 2022-01-30 | Lewis | West Virginia | 54041 | 4590 | 73 |
2154635 | 2154635 | 2022-01-26 | Taylor | Wisconsin | 55119 | 4590 | 63 |
2131641 | 2131641 | 2022-01-19 | Lee | Virginia | 51105 | 4590 | 72 |
2124844 | 2124844 | 2022-01-17 | Frio | Texas | 48163 | 4590 | 80 |
2118266 | 2118266 | 2022-01-15 | Austin | Texas | 48015 | 4590 | 58 |
2109578 | 2109578 | 2022-01-13 | Franklin | Georgia | 13119 | 4590 | 86 |
2085646 | 2085646 | 2022-01-05 | Yankton | South Dakota | 46135 | 4590 | 46 |
2063728 | 2063728 | 2021-12-30 | Carroll | Arkansas | 5015 | 4590 | 81 |
2051752 | 2051752 | 2021-12-26 | East Feliciana | Louisiana | 22037 | 4590 | 145 |
2048502 | 2048502 | 2021-12-25 | East Feliciana | Louisiana | 22037 | 4590 | 145 |
2045252 | 2045252 | 2021-12-24 | East Feliciana | Louisiana | 22037 | 4590 | 145 |
2042003 | 2042003 | 2021-12-23 | East Feliciana | Louisiana | 22037 | 4590 | 145 |
2011017 | 2011017 | 2021-12-13 | Cass | Texas | 48067 | 4590 | 158 |
1969217 | 1969217 | 2021-11-30 | Hancock | West Virginia | 54029 | 4590 | 118 |
1964980 | 1964980 | 2021-11-29 | Pike | Ohio | 39131 | 4590 | 76 |
1919430 | 1919430 | 2021-11-15 | Fayette | Ohio | 39047 | 4590 | 67 |
1905121 | 1905121 | 2021-11-11 | Scott | Indiana | 18143 | 4590 | 79 |
1896563 | 1896563 | 2021-11-08 | Montgomery | North Carolina | 37123 | 4590 | 108 |
1881981 | 1881981 | 2021-11-04 | Taylor | Florida | 12123 | 4590 | 79 |
1878732 | 1878732 | 2021-11-03 | Taylor | Florida | 12123 | 4590 | 79 |
1875483 | 1875483 | 2021-11-02 | Taylor | Florida | 12123 | 4590 | 79 |
1872234 | 1872234 | 2021-11-01 | Taylor | Florida | 12123 | 4590 | 79 |
1868985 | 1868985 | 2021-10-31 | Taylor | Florida | 12123 | 4590 | 79 |
1865736 | 1865736 | 2021-10-30 | Taylor | Florida | 12123 | 4590 | 74 |
1862133 | 1862133 | 2021-10-29 | Geneva | Alabama | 1061 | 4590 | 127 |
1862487 | 1862487 | 2021-10-29 | Taylor | Florida | 12123 | 4590 | 74 |
1858884 | 1858884 | 2021-10-28 | Geneva | Alabama | 1061 | 4590 | 127 |
1814809 | 1814809 | 2021-10-14 | Itawamba | Mississippi | 28057 | 4590 | 104 |
1810303 | 1810303 | 2021-10-13 | Yell | Arkansas | 5149 | 4590 | 77 |
1784659 | 1784659 | 2021-10-05 | Unknown | Georgia | 4590 | 6 | |
1750510 | 1750510 | 2021-09-24 | Perry | Ohio | 39127 | 4590 | 54 |
1738470 | 1738470 | 2021-09-20 | Mason | Washington | 53045 | 4590 | 52 |
1656048 | 1656048 | 2021-08-26 | Montgomery | New York | 36057 | 4590 | 128 |
1610596 | 1610596 | 2021-08-12 | Tompkins | New York | 36109 | 4590 | 54 |
1601649 | 1601649 | 2021-08-09 | Erath | Texas | 48143 | 4590 | 71 |
1598401 | 1598401 | 2021-08-08 | Erath | Texas | 48143 | 4590 | 71 |
1595152 | 1595152 | 2021-08-07 | Erath | Texas | 48143 | 4590 | 71 |
1576239 | 1576239 | 2021-08-02 | Franklin | Alabama | 1059 | 4590 | 81 |
1540642 | 1540642 | 2021-07-22 | Miller | Arkansas | 5091 | 4590 | 37 |
1537880 | 1537880 | 2021-07-21 | Jefferson | Illinois | 17081 | 4590 | 124 |
1531473 | 1531473 | 2021-07-19 | Gibson | Indiana | 18051 | 4590 | 99 |
1529367 | 1529367 | 2021-07-18 | Madison | New York | 36053 | 4590 | 89 |
1526352 | 1526352 | 2021-07-17 | Knox | Ohio | 39083 | 4590 | 112 |
1523105 | 1523105 | 2021-07-16 | Knox | Ohio | 39083 | 4590 | 112 |
1468567 | 1468567 | 2021-06-29 | Kerr | Texas | 48265 | 4590 | 92 |
1426564 | 1426564 | 2021-06-16 | Campbell | Virginia | 51031 | 4590 | 88 |
1401956 | 1401956 | 2021-06-09 | Hopkins | Kentucky | 21107 | 4590 | 147 |
1384021 | 1384021 | 2021-06-03 | Obion | Tennessee | 47131 | 4590 | 97 |
1374488 | 1374488 | 2021-05-31 | Nacogdoches | Texas | 48347 | 4590 | 171 |
1360120 | 1360120 | 2021-05-27 | Winona | Minnesota | 27169 | 4590 | 50 |
1354484 | 1354484 | 2021-05-25 | Bedford | Pennsylvania | 42009 | 4590 | 138 |
1323818 | 1323818 | 2021-05-16 | Des Moines | Iowa | 19057 | 4590 | 66 |
1303384 | 1303384 | 2021-05-09 | Jefferson | West Virginia | 54037 | 4590 | 50 |
1293718 | 1293718 | 2021-05-06 | Marinette | Wisconsin | 55075 | 4590 | 70 |
1271264 | 1271264 | 2021-04-30 | Nevada | California | 6057 | 4590 | 75 |
1265661 | 1265661 | 2021-04-28 | Shelby | Kentucky | 21211 | 4590 | 70 |
1262775 | 1262775 | 2021-04-27 | Oktibbeha | Mississippi | 28105 | 4590 | 98 |
1218056 | 1218056 | 2021-04-13 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1214808 | 1214808 | 2021-04-12 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1211561 | 1211561 | 2021-04-11 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1208312 | 1208312 | 2021-04-10 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1205064 | 1205064 | 2021-04-09 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1201816 | 1201816 | 2021-04-08 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1198567 | 1198567 | 2021-04-07 | Pittsburg | Oklahoma | 40121 | 4590 | 68 |
1198719 | 1198719 | 2021-04-07 | Guaynabo | Puerto Rico | 72061 | 4590 | |
1187236 | 1187236 | 2021-04-04 | Effingham | Illinois | 17049 | 4590 | 82 |
1165629 | 1165629 | 2021-03-28 | Scotts Bluff | Nebraska | 31157 | 4590 | 95 |
1162381 | 1162381 | 2021-03-27 | Scotts Bluff | Nebraska | 31157 | 4590 | 95 |
1159133 | 1159133 | 2021-03-26 | Scotts Bluff | Nebraska | 31157 | 4590 | 95 |
1156195 | 1156195 | 2021-03-25 | Williams | North Dakota | 38105 | 4590 | 37 |
1122165 | 1122165 | 2021-03-15 | Murray | Georgia | 13213 | 4590 | 77 |
1107205 | 1107205 | 2021-03-10 | Elko | Nevada | 32007 | 4590 | 51 |
1103959 | 1103959 | 2021-03-09 | Elko | Nevada | 32007 | 4590 | 51 |
1100713 | 1100713 | 2021-03-08 | Elko | Nevada | 32007 | 4590 | 51 |
1097466 | 1097466 | 2021-03-07 | Elko | Nevada | 32007 | 4590 | 51 |
1094219 | 1094219 | 2021-03-06 | Elko | Nevada | 32007 | 4590 | 51 |
1090973 | 1090973 | 2021-03-05 | Elko | Nevada | 32007 | 4590 | 51 |
1081775 | 1081775 | 2021-03-02 | Mifflin | Pennsylvania | 42087 | 4590 | 167 |
1076462 | 1076462 | 2021-03-01 | Tehama | California | 6103 | 4590 | 52 |
1077829 | 1077829 | 2021-03-01 | Taney | Missouri | 29213 | 4590 | 88 |
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);