ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 5082 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Illinois 15
- Louisiana 12
- Georgia 11
- Indiana 10
- Iowa 8
- Mississippi 8
- Missouri 8
- North Carolina 8
- Texas 8
- Alabama 5
- Arkansas 5
- Pennsylvania 4
- Ohio 3
- Virginia 3
- Wisconsin 3
- Kentucky 2
- Michigan 2
- Oklahoma 2
- Florida 1
- Maryland 1
- New Mexico 1
- New York 1
- North Dakota 1
- South Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500062 | 2500062 | 2022-05-13 | McDuffie | Georgia | 13189 | 5082 | 98 |
2502687 | 2502687 | 2022-05-13 | Brooke | West Virginia | 54009 | 5082 | 104 |
2496804 | 2496804 | 2022-05-12 | McDuffie | Georgia | 13189 | 5082 | 98 |
2493546 | 2493546 | 2022-05-11 | McDuffie | Georgia | 13189 | 5082 | 98 |
2427983 | 2427983 | 2022-04-21 | Randolph | Alabama | 1111 | 5082 | 74 |
2424727 | 2424727 | 2022-04-20 | Randolph | Alabama | 1111 | 5082 | 74 |
2421471 | 2421471 | 2022-04-19 | Randolph | Alabama | 1111 | 5082 | 74 |
2404217 | 2404217 | 2022-04-13 | Wyoming | Pennsylvania | 42131 | 5082 | 104 |
2400592 | 2400592 | 2022-04-12 | Madison | North Carolina | 37115 | 5082 | 80 |
2397337 | 2397337 | 2022-04-11 | Madison | North Carolina | 37115 | 5082 | 80 |
2394082 | 2394082 | 2022-04-10 | Madison | North Carolina | 37115 | 5082 | 80 |
2390826 | 2390826 | 2022-04-09 | Madison | North Carolina | 37115 | 5082 | 80 |
2387570 | 2387570 | 2022-04-08 | Madison | North Carolina | 37115 | 5082 | 80 |
2384315 | 2384315 | 2022-04-07 | Madison | North Carolina | 37115 | 5082 | 80 |
2381060 | 2381060 | 2022-04-06 | Madison | North Carolina | 37115 | 5082 | 80 |
2375895 | 2375895 | 2022-04-05 | Randolph | Alabama | 1111 | 5082 | 74 |
2374552 | 2374552 | 2022-04-04 | Madison | North Carolina | 37115 | 5082 | 80 |
2334686 | 2334686 | 2022-03-23 | Concordia | Louisiana | 22029 | 5082 | 88 |
2331432 | 2331432 | 2022-03-22 | Concordia | Louisiana | 22029 | 5082 | 88 |
2328180 | 2328180 | 2022-03-21 | Concordia | Louisiana | 22029 | 5082 | 88 |
2324927 | 2324927 | 2022-03-20 | Concordia | Louisiana | 22029 | 5082 | 88 |
2321673 | 2321673 | 2022-03-19 | Concordia | Louisiana | 22029 | 5082 | 88 |
2318419 | 2318419 | 2022-03-18 | Concordia | Louisiana | 22029 | 5082 | 88 |
2315166 | 2315166 | 2022-03-17 | Concordia | Louisiana | 22029 | 5082 | 89 |
2311913 | 2311913 | 2022-03-16 | Concordia | Louisiana | 22029 | 5082 | 89 |
2307676 | 2307676 | 2022-03-15 | Logan | Arkansas | 5083 | 5082 | 75 |
2304425 | 2304425 | 2022-03-14 | Logan | Arkansas | 5083 | 5082 | 75 |
2301173 | 2301173 | 2022-03-13 | Logan | Arkansas | 5083 | 5082 | 75 |
2297921 | 2297921 | 2022-03-12 | Logan | Arkansas | 5083 | 5082 | 75 |
2278779 | 2278779 | 2022-03-06 | Tattnall | Georgia | 13267 | 5082 | 130 |
2275526 | 2275526 | 2022-03-05 | Tattnall | Georgia | 13267 | 5082 | 130 |
2272273 | 2272273 | 2022-03-04 | Tattnall | Georgia | 13267 | 5082 | 130 |
2257081 | 2257081 | 2022-02-27 | Ray | Missouri | 29177 | 5082 | 89 |
2253830 | 2253830 | 2022-02-26 | Ray | Missouri | 29177 | 5082 | 89 |
2250579 | 2250579 | 2022-02-25 | Ray | Missouri | 29177 | 5082 | 89 |
2246185 | 2246185 | 2022-02-24 | Fannin | Georgia | 13111 | 5082 | 138 |
2243113 | 2243113 | 2022-02-23 | Edgar | Illinois | 17045 | 5082 | 77 |
2223036 | 2223036 | 2022-02-17 | Pickens | Alabama | 1107 | 5082 | 95 |
2171746 | 2171746 | 2022-02-01 | Boone | Iowa | 19015 | 5082 | 46 |
2168493 | 2168493 | 2022-01-31 | Boone | Iowa | 19015 | 5082 | 46 |
2165238 | 2165238 | 2022-01-30 | Boone | Iowa | 19015 | 5082 | 46 |
2167485 | 2167485 | 2022-01-30 | Staunton city | Virginia | 51790 | 5082 | 91 |
2161983 | 2161983 | 2022-01-29 | Boone | Iowa | 19015 | 5082 | 46 |
2164230 | 2164230 | 2022-01-29 | Staunton city | Virginia | 51790 | 5082 | 91 |
2158728 | 2158728 | 2022-01-28 | Boone | Iowa | 19015 | 5082 | 46 |
2160975 | 2160975 | 2022-01-28 | Staunton city | Virginia | 51790 | 5082 | 91 |
2155474 | 2155474 | 2022-01-27 | Boone | Iowa | 19015 | 5082 | 46 |
2152221 | 2152221 | 2022-01-26 | Boone | Iowa | 19015 | 5082 | 46 |
2122758 | 2122758 | 2022-01-17 | Douglas | Illinois | 17041 | 5082 | 50 |
2122823 | 2122823 | 2022-01-17 | Shelby | Illinois | 17173 | 5082 | 63 |
2119506 | 2119506 | 2022-01-16 | Douglas | Illinois | 17041 | 5082 | 50 |
2119571 | 2119571 | 2022-01-16 | Shelby | Illinois | 17173 | 5082 | 63 |
2116254 | 2116254 | 2022-01-15 | Douglas | Illinois | 17041 | 5082 | 50 |
2116319 | 2116319 | 2022-01-15 | Shelby | Illinois | 17173 | 5082 | 63 |
2113003 | 2113003 | 2022-01-14 | Douglas | Illinois | 17041 | 5082 | 50 |
2113068 | 2113068 | 2022-01-14 | Shelby | Illinois | 17173 | 5082 | 63 |
2091123 | 2091123 | 2022-01-07 | Barry | Missouri | 29009 | 5082 | 97 |
2082736 | 2082736 | 2022-01-04 | Willacy | Texas | 48489 | 5082 | 114 |
2074078 | 2074078 | 2022-01-02 | Clay | Indiana | 18021 | 5082 | 68 |
2070827 | 2070827 | 2022-01-01 | Clay | Indiana | 18021 | 5082 | 68 |
2067576 | 2067576 | 2021-12-31 | Clay | Indiana | 18021 | 5082 | 68 |
2064325 | 2064325 | 2021-12-30 | Clay | Indiana | 18021 | 5082 | 68 |
2055950 | 2055950 | 2021-12-27 | Gallia | Ohio | 39053 | 5082 | 82 |
2052097 | 2052097 | 2021-12-26 | Tippah | Mississippi | 28139 | 5082 | 85 |
2048847 | 2048847 | 2021-12-25 | Tippah | Mississippi | 28139 | 5082 | 85 |
2045597 | 2045597 | 2021-12-24 | Tippah | Mississippi | 28139 | 5082 | 85 |
2042347 | 2042347 | 2021-12-23 | Tippah | Mississippi | 28139 | 5082 | 85 |
2039098 | 2039098 | 2021-12-22 | Tippah | Mississippi | 28139 | 5082 | 85 |
2033622 | 2033622 | 2021-12-20 | Meade | South Dakota | 46093 | 5082 | 56 |
1983826 | 1983826 | 2021-12-05 | Prentiss | Mississippi | 28117 | 5082 | 85 |
1980576 | 1980576 | 2021-12-04 | Prentiss | Mississippi | 28117 | 5082 | 85 |
1977326 | 1977326 | 2021-12-03 | Prentiss | Mississippi | 28117 | 5082 | 85 |
1895301 | 1895301 | 2021-11-08 | Adams | Indiana | 18001 | 5082 | 80 |
1889705 | 1889705 | 2021-11-06 | Warren | Missouri | 29219 | 5082 | 50 |
1814948 | 1814948 | 2021-10-14 | Polk | Missouri | 29167 | 5082 | 52 |
1770612 | 1770612 | 2021-09-30 | Hopkins | Texas | 48223 | 5082 | 136 |
1710155 | 1710155 | 2021-09-12 | Miami | Indiana | 18103 | 5082 | 82 |
1706908 | 1706908 | 2021-09-11 | Miami | Indiana | 18103 | 5082 | 82 |
1703660 | 1703660 | 2021-09-10 | Miami | Indiana | 18103 | 5082 | 82 |
1699834 | 1699834 | 2021-09-09 | Union | Arkansas | 5139 | 5082 | 121 |
1667583 | 1667583 | 2021-08-30 | Chattahoochee | Georgia | 13053 | 5082 | 17 |
1669022 | 1669022 | 2021-08-30 | Clinton | New York | 36019 | 5082 | 33 |
1654865 | 1654865 | 2021-08-26 | Stephenson | Illinois | 17177 | 5082 | 106 |
1650876 | 1650876 | 2021-08-24 | Monroe | Wisconsin | 55081 | 5082 | 52 |
1647092 | 1647092 | 2021-08-23 | Cherokee | Texas | 48073 | 5082 | 151 |
1643843 | 1643843 | 2021-08-22 | Cherokee | Texas | 48073 | 5082 | 151 |
1640593 | 1640593 | 2021-08-21 | Cherokee | Texas | 48073 | 5082 | 151 |
1622836 | 1622836 | 2021-08-16 | Iberville | Louisiana | 22047 | 5082 | 109 |
1607500 | 1607500 | 2021-08-11 | Stark | North Dakota | 38089 | 5082 | 52 |
1537734 | 1537734 | 2021-07-21 | Murray | Georgia | 13213 | 5082 | 92 |
1538290 | 1538290 | 2021-07-21 | Henderson | Kentucky | 21101 | 5082 | 79 |
1485926 | 1485926 | 2021-07-05 | Henry | Illinois | 17073 | 5082 | 99 |
1482680 | 1482680 | 2021-07-04 | Henry | Illinois | 17073 | 5082 | 99 |
1479433 | 1479433 | 2021-07-03 | Henry | Illinois | 17073 | 5082 | 99 |
1476187 | 1476187 | 2021-07-02 | Henry | Illinois | 17073 | 5082 | 99 |
1345645 | 1345645 | 2021-05-22 | Dunn | Wisconsin | 55033 | 5082 | 32 |
1342397 | 1342397 | 2021-05-21 | Dunn | Wisconsin | 55033 | 5082 | 32 |
1253145 | 1253145 | 2021-04-24 | Pettis | Missouri | 29159 | 5082 | 78 |
1246892 | 1246892 | 2021-04-22 | Curry | New Mexico | 35009 | 5082 | 74 |
1229726 | 1229726 | 2021-04-17 | Webster | Iowa | 19187 | 5082 | 91 |
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);