ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 5050 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Kentucky 8
- Texas 7
- New Mexico 6
- Virginia 6
- Wisconsin 6
- Kansas 5
- South Carolina 5
- Missouri 4
- Ohio 4
- Florida 3
- North Carolina 3
- Tennessee 3
- Wyoming 3
- Illinois 2
- Iowa 2
- Louisiana 2
- Maryland 2
- Mississippi 2
- New York 2
- Pennsylvania 2
- Puerto Rico 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Indiana 1
- Michigan 1
- Minnesota 1
- New Jersey 1
- North Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500251 | 2500251 | 2022-05-13 | Pike | Illinois | 17149 | 5050 | 70 |
2466853 | 2466853 | 2022-05-02 | Brooke | West Virginia | 54009 | 5050 | 104 |
2456324 | 2456324 | 2022-04-29 | Barranquitas | Puerto Rico | 72019 | 5050 | |
2427704 | 2427704 | 2022-04-20 | Prince Edward | Virginia | 51147 | 5050 | 70 |
2415391 | 2415391 | 2022-04-17 | McDuffie | Georgia | 13189 | 5050 | 96 |
2412135 | 2412135 | 2022-04-16 | McDuffie | Georgia | 13189 | 5050 | 96 |
2408879 | 2408879 | 2022-04-15 | McDuffie | Georgia | 13189 | 5050 | 96 |
2402355 | 2402355 | 2022-04-13 | Jones | Georgia | 13169 | 5050 | 108 |
2399100 | 2399100 | 2022-04-12 | Jones | Georgia | 13169 | 5050 | 108 |
2395845 | 2395845 | 2022-04-11 | Jones | Georgia | 13169 | 5050 | 108 |
2392589 | 2392589 | 2022-04-10 | Jones | Georgia | 13169 | 5050 | 108 |
2389333 | 2389333 | 2022-04-09 | Jones | Georgia | 13169 | 5050 | 108 |
2386078 | 2386078 | 2022-04-08 | Jones | Georgia | 13169 | 5050 | 108 |
2382823 | 2382823 | 2022-04-07 | Jones | Georgia | 13169 | 5050 | 108 |
2384698 | 2384698 | 2022-04-07 | Cabo Rojo | Puerto Rico | 72023 | 5050 | |
2326125 | 2326125 | 2022-03-20 | Wyoming | Pennsylvania | 42131 | 5050 | 103 |
2263076 | 2263076 | 2022-03-01 | McCreary | Kentucky | 21147 | 5050 | 73 |
2245852 | 2245852 | 2022-02-24 | Ashley | Arkansas | 5003 | 5050 | 59 |
2237123 | 2237123 | 2022-02-21 | Concordia | Louisiana | 22029 | 5050 | 89 |
2232745 | 2232745 | 2022-02-20 | Cherokee | Alabama | 1019 | 5050 | 77 |
2220177 | 2220177 | 2022-02-16 | Fannin | Georgia | 13111 | 5050 | 133 |
2194820 | 2194820 | 2022-02-08 | Spencer | Kentucky | 21215 | 5050 | 48 |
2171349 | 2171349 | 2022-02-01 | Burke | Georgia | 13033 | 5050 | 92 |
2142726 | 2142726 | 2022-01-23 | Letcher | Kentucky | 21133 | 5050 | 87 |
2139471 | 2139471 | 2022-01-22 | Letcher | Kentucky | 21133 | 5050 | 87 |
2136215 | 2136215 | 2022-01-21 | Letcher | Kentucky | 21133 | 5050 | 87 |
2128572 | 2128572 | 2022-01-18 | Jackson | Wisconsin | 55053 | 5050 | 40 |
2099154 | 2099154 | 2022-01-09 | Pulaski | Virginia | 51155 | 5050 | 106 |
2095903 | 2095903 | 2022-01-08 | Pulaski | Virginia | 51155 | 5050 | 106 |
2092651 | 2092651 | 2022-01-07 | Pulaski | Virginia | 51155 | 5050 | 106 |
2077702 | 2077702 | 2022-01-03 | Montgomery | Kentucky | 21173 | 5050 | 77 |
2028819 | 2028819 | 2021-12-19 | Miami | Kansas | 20121 | 5050 | 72 |
2025568 | 2025568 | 2021-12-18 | Miami | Kansas | 20121 | 5050 | 72 |
2022317 | 2022317 | 2021-12-17 | Miami | Kansas | 20121 | 5050 | 72 |
2016911 | 2016911 | 2021-12-15 | Stutsman | North Dakota | 38093 | 5050 | 92 |
1963336 | 1963336 | 2021-11-29 | Madison | Georgia | 13195 | 5050 | 80 |
1873285 | 1873285 | 2021-11-01 | George | Mississippi | 28039 | 5050 | 79 |
1848287 | 1848287 | 2021-10-24 | Clarendon | South Carolina | 45027 | 5050 | 135 |
1845037 | 1845037 | 2021-10-23 | Clarendon | South Carolina | 45027 | 5050 | 135 |
1841787 | 1841787 | 2021-10-22 | Clarendon | South Carolina | 45027 | 5050 | 135 |
1828433 | 1828433 | 2021-10-18 | Champaign | Ohio | 39021 | 5050 | 71 |
1828828 | 1828828 | 2021-10-18 | Brookings | South Dakota | 46011 | 5050 | 38 |
1826357 | 1826357 | 2021-10-17 | Teton | Wyoming | 56039 | 5050 | 13 |
1823108 | 1823108 | 2021-10-16 | Teton | Wyoming | 56039 | 5050 | 13 |
1819859 | 1819859 | 2021-10-15 | Teton | Wyoming | 56039 | 5050 | 13 |
1806181 | 1806181 | 2021-10-11 | Hardeman | Tennessee | 47069 | 5050 | 78 |
1792204 | 1792204 | 2021-10-07 | Polk | Missouri | 29167 | 5050 | 52 |
1723341 | 1723341 | 2021-09-16 | Lyon | Kansas | 20111 | 5050 | 90 |
1720092 | 1720092 | 2021-09-15 | Lyon | Kansas | 20111 | 5050 | 90 |
1713182 | 1713182 | 2021-09-13 | Upson | Georgia | 13293 | 5050 | 138 |
1700425 | 1700425 | 2021-09-09 | Putnam | Indiana | 18133 | 5050 | 68 |
1674204 | 1674204 | 2021-09-01 | Wayne | Georgia | 13305 | 5050 | 103 |
1656607 | 1656607 | 2021-08-26 | Dillon | South Carolina | 45033 | 5050 | 89 |
1650667 | 1650667 | 2021-08-24 | Henry | Virginia | 51089 | 5050 | 126 |
1636224 | 1636224 | 2021-08-20 | Howell | Missouri | 29091 | 5050 | 56 |
1598874 | 1598874 | 2021-08-08 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1595625 | 1595625 | 2021-08-07 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1592376 | 1592376 | 2021-08-06 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1589127 | 1589127 | 2021-08-05 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1574956 | 1574956 | 2021-08-01 | Vance | North Carolina | 37181 | 5050 | 90 |
1571708 | 1571708 | 2021-07-31 | Vance | North Carolina | 37181 | 5050 | 90 |
1568460 | 1568460 | 2021-07-30 | Vance | North Carolina | 37181 | 5050 | 90 |
1569252 | 1569252 | 2021-07-30 | Medina | Texas | 48325 | 5050 | 108 |
1532290 | 1532290 | 2021-07-19 | Johnson | Missouri | 29101 | 5050 | 59 |
1415393 | 1415393 | 2021-06-13 | Callaway | Missouri | 29027 | 5050 | 51 |
1359346 | 1359346 | 2021-05-27 | Henry | Illinois | 17073 | 5050 | 98 |
1350089 | 1350089 | 2021-05-24 | Whitley | Kentucky | 21235 | 5050 | 57 |
1322198 | 1322198 | 2021-05-15 | Newberry | South Carolina | 45071 | 5050 | 104 |
1223220 | 1223220 | 2021-04-15 | Sioux | Iowa | 19167 | 5050 | 73 |
1211170 | 1211170 | 2021-04-11 | Curry | New Mexico | 35009 | 5050 | 73 |
1211485 | 1211485 | 2021-04-11 | Seneca | Ohio | 39147 | 5050 | 118 |
1207921 | 1207921 | 2021-04-10 | Curry | New Mexico | 35009 | 5050 | 73 |
1204673 | 1204673 | 2021-04-09 | Curry | New Mexico | 35009 | 5050 | 73 |
1201425 | 1201425 | 2021-04-08 | Curry | New Mexico | 35009 | 5050 | 73 |
1202159 | 1202159 | 2021-04-08 | Franklin | Tennessee | 47051 | 5050 | 87 |
1198176 | 1198176 | 2021-04-07 | Curry | New Mexico | 35009 | 5050 | 73 |
1194927 | 1194927 | 2021-04-06 | Curry | New Mexico | 35009 | 5050 | 73 |
1145575 | 1145575 | 2021-03-22 | Vermilion | Louisiana | 22113 | 5050 | 110 |
1130030 | 1130030 | 2021-03-17 | Jefferson | New York | 36045 | 5050 | 63 |
1109502 | 1109502 | 2021-03-11 | Clinton | Iowa | 19045 | 5050 | 87 |
1106777 | 1106777 | 2021-03-10 | Chisago | Minnesota | 27025 | 5050 | 47 |
1087259 | 1087259 | 2021-03-04 | Midland | Michigan | 26111 | 5050 | 65 |
1058891 | 1058891 | 2021-02-23 | Union | Ohio | 39159 | 5050 | 52 |
1030102 | 1030102 | 2021-02-14 | Hawkins | Tennessee | 47073 | 5050 | 91 |
1023697 | 1023697 | 2021-02-12 | Caldwell | Texas | 48055 | 5050 | 71 |
987503 | 987503 | 2021-02-01 | Carter | Oklahoma | 40019 | 5050 | 32 |
975706 | 975706 | 2021-01-29 | Graham | Arizona | 4009 | 5050 | 65 |
970179 | 970179 | 2021-01-27 | Laurel | Kentucky | 21125 | 5050 | 18 |
949554 | 949554 | 2021-01-20 | Barron | Wisconsin | 55005 | 5050 | 66 |
945887 | 945887 | 2021-01-19 | Hood | Texas | 48221 | 5050 | 85 |
942640 | 942640 | 2021-01-18 | Hood | Texas | 48221 | 5050 | 85 |
939395 | 939395 | 2021-01-17 | Hood | Texas | 48221 | 5050 | 85 |
936150 | 936150 | 2021-01-16 | Hood | Texas | 48221 | 5050 | 85 |
847000 | 847000 | 2020-12-20 | Allegany | Maryland | 24001 | 5050 | 140 |
782998 | 782998 | 2020-11-30 | Marion | Ohio | 39101 | 5050 | 61 |
655796 | 655796 | 2020-10-22 | Harrison | Mississippi | 28047 | 5050 | 83 |
630191 | 630191 | 2020-10-14 | Gloucester | New Jersey | 34015 | 5050 | 233 |
615787 | 615787 | 2020-10-10 | Martin | Florida | 12085 | 5050 | 145 |
612546 | 612546 | 2020-10-09 | Martin | Florida | 12085 | 5050 | 145 |
545983 | 545983 | 2020-09-18 | Dutchess | New York | 36027 | 5050 | 156 |
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);