ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where cases = 3594 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Texas 16
- Indiana 8
- Iowa 8
- Arkansas 7
- Ohio 7
- Illinois 6
- Minnesota 6
- Mississippi 5
- Missouri 5
- Florida 4
- Kentucky 4
- New York 4
- Puerto Rico 4
- Wisconsin 4
- Maryland 3
- Michigan 3
- Oregon 3
- Virginia 3
- West Virginia 3
- California 2
- Maine 2
- Nebraska 2
- North Carolina 2
- Pennsylvania 2
- Tennessee 2
- Wyoming 2
- Alabama 1
- Alaska 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459142 | 2459142 | 2022-04-30 | Yates | New York | 36123 | 3594 | 40 |
2442338 | 2442338 | 2022-04-25 | Pennington | Minnesota | 27113 | 3594 | 41 |
2438461 | 2438461 | 2022-04-24 | Parke | Indiana | 18121 | 3594 | 46 |
2435205 | 2435205 | 2022-04-23 | Parke | Indiana | 18121 | 3594 | 46 |
2431949 | 2431949 | 2022-04-22 | Parke | Indiana | 18121 | 3594 | 46 |
2428693 | 2428693 | 2022-04-21 | Parke | Indiana | 18121 | 3594 | 46 |
2425437 | 2425437 | 2022-04-20 | Parke | Indiana | 18121 | 3594 | 46 |
2396003 | 2396003 | 2022-04-11 | Greene | Illinois | 17061 | 3594 | 58 |
2392747 | 2392747 | 2022-04-10 | Greene | Illinois | 17061 | 3594 | 58 |
2389491 | 2389491 | 2022-04-09 | Greene | Illinois | 17061 | 3594 | 58 |
2386236 | 2386236 | 2022-04-08 | Greene | Illinois | 17061 | 3594 | 58 |
2353943 | 2353943 | 2022-03-29 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2350691 | 2350691 | 2022-03-28 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2347438 | 2347438 | 2022-03-27 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2344185 | 2344185 | 2022-03-26 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2340932 | 2340932 | 2022-03-25 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2337679 | 2337679 | 2022-03-24 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2334425 | 2334425 | 2022-03-23 | Poweshiek | Iowa | 19157 | 3594 | 61 |
2270758 | 2270758 | 2022-03-03 | Tillamook | Oregon | 41057 | 3594 | 57 |
2267506 | 2267506 | 2022-03-02 | Tillamook | Oregon | 41057 | 3594 | 57 |
2247781 | 2247781 | 2022-02-24 | Ramsey | North Dakota | 38071 | 3594 | 55 |
2238362 | 2238362 | 2022-02-21 | Lares | Puerto Rico | 72081 | 3594 | |
2235111 | 2235111 | 2022-02-20 | Lares | Puerto Rico | 72081 | 3594 | |
2213739 | 2213739 | 2022-02-14 | Rabun | Georgia | 13241 | 3594 | 89 |
2214862 | 2214862 | 2022-02-14 | Glacier | Montana | 30035 | 3594 | 65 |
2200690 | 2200690 | 2022-02-10 | Jefferson | Georgia | 13163 | 3594 | 100 |
2201983 | 2201983 | 2022-02-10 | York | Nebraska | 31185 | 3594 | 19 |
2164568 | 2164568 | 2022-01-30 | Franklin | Arkansas | 5047 | 3594 | 62 |
2161313 | 2161313 | 2022-01-29 | Franklin | Arkansas | 5047 | 3594 | 62 |
2164315 | 2164315 | 2022-01-29 | Monroe | West Virginia | 54063 | 3594 | 34 |
2158057 | 2158057 | 2022-01-28 | Franklin | Arkansas | 5047 | 3594 | 62 |
2101136 | 2101136 | 2022-01-10 | Washington | Nebraska | 31177 | 3594 | 30 |
2096567 | 2096567 | 2022-01-09 | Elbert | Georgia | 13105 | 3594 | 93 |
2093315 | 2093315 | 2022-01-08 | Elbert | Georgia | 13105 | 3594 | 93 |
2090063 | 2090063 | 2022-01-07 | Elbert | Georgia | 13105 | 3594 | 93 |
2086812 | 2086812 | 2022-01-06 | Elbert | Georgia | 13105 | 3594 | 93 |
2083560 | 2083560 | 2022-01-05 | Elbert | Georgia | 13105 | 3594 | 93 |
2086330 | 2086330 | 2022-01-05 | Sawyer | Wisconsin | 55113 | 3594 | 50 |
2072237 | 2072237 | 2022-01-01 | Paulding | Ohio | 39125 | 3594 | 61 |
2068986 | 2068986 | 2021-12-31 | Paulding | Ohio | 39125 | 3594 | 61 |
2054337 | 2054337 | 2021-12-27 | Lamar | Georgia | 13171 | 3594 | 101 |
2055052 | 2055052 | 2021-12-27 | Franklin | Maine | 23007 | 3594 | 41 |
2017544 | 2017544 | 2021-12-15 | Deaf Smith | Texas | 48117 | 3594 | 88 |
1989339 | 1989339 | 2021-12-07 | McDuffie | Georgia | 13189 | 3594 | 78 |
1943808 | 1943808 | 2021-11-23 | Hart | Georgia | 13147 | 3594 | 73 |
1898897 | 1898897 | 2021-11-09 | Hart | Kentucky | 21099 | 3594 | 65 |
1882369 | 1882369 | 2021-11-04 | Randolph | Indiana | 18135 | 3594 | 103 |
1864802 | 1864802 | 2021-10-29 | Fayette | Texas | 48149 | 3594 | 93 |
1839161 | 1839161 | 2021-10-21 | Waynesboro city | Virginia | 51820 | 3594 | 44 |
1834345 | 1834345 | 2021-10-20 | Tishomingo | Mississippi | 28141 | 3594 | 92 |
1835386 | 1835386 | 2021-10-20 | Yankton | South Dakota | 46135 | 3594 | 38 |
1831573 | 1831573 | 2021-10-19 | Martin | North Carolina | 37117 | 3594 | 68 |
1787495 | 1787495 | 2021-10-06 | Cleburne | Arkansas | 5023 | 3594 | 89 |
1772346 | 1772346 | 2021-10-01 | Queen Anne's | Maryland | 24035 | 3594 | 64 |
1762041 | 1762041 | 2021-09-28 | McDonough | Illinois | 17109 | 3594 | 69 |
1735892 | 1735892 | 2021-09-20 | Pike | Georgia | 13231 | 3594 | 54 |
1730965 | 1730965 | 2021-09-18 | Coshocton | Ohio | 39031 | 3594 | 66 |
1662275 | 1662275 | 2021-08-28 | Stone | Missouri | 29209 | 3594 | 62 |
1650802 | 1650802 | 2021-08-24 | Logan | West Virginia | 54045 | 3594 | 101 |
1610195 | 1610195 | 2021-08-12 | Yazoo | Mississippi | 28163 | 3594 | 78 |
1557848 | 1557848 | 2021-07-27 | Beauregard | Louisiana | 22011 | 3594 | 80 |
1541522 | 1541522 | 2021-07-22 | Floyd | Kentucky | 21071 | 3594 | 74 |
1531246 | 1531246 | 2021-07-19 | Pickens | Georgia | 13227 | 3594 | 80 |
1492801 | 1492801 | 2021-07-07 | Calloway | Kentucky | 21035 | 3594 | 50 |
1483944 | 1483944 | 2021-07-04 | Wyoming | New York | 36121 | 3594 | 53 |
1469261 | 1469261 | 2021-06-30 | Lake | California | 6033 | 3594 | 56 |
1419223 | 1419223 | 2021-06-14 | Highland | Ohio | 39071 | 3594 | 65 |
1409641 | 1409641 | 2021-06-11 | Malheur | Oregon | 41045 | 3594 | 63 |
1375726 | 1375726 | 2021-06-01 | Wabash | Indiana | 18169 | 3594 | 82 |
1371981 | 1371981 | 2021-05-31 | Montrose | Colorado | 8085 | 3594 | 60 |
1368055 | 1368055 | 2021-05-29 | Uvalde | Texas | 48463 | 3594 | 72 |
1364809 | 1364809 | 2021-05-28 | Uvalde | Texas | 48463 | 3594 | 72 |
1361563 | 1361563 | 2021-05-27 | Uvalde | Texas | 48463 | 3594 | 72 |
1358317 | 1358317 | 2021-05-26 | Uvalde | Texas | 48463 | 3594 | 72 |
1355071 | 1355071 | 2021-05-25 | Uvalde | Texas | 48463 | 3594 | 72 |
1351825 | 1351825 | 2021-05-24 | Uvalde | Texas | 48463 | 3594 | 72 |
1331385 | 1331385 | 2021-05-18 | Warren | New York | 36113 | 3594 | 57 |
1313432 | 1313432 | 2021-05-13 | St. Francis | Arkansas | 5123 | 3594 | 43 |
1311618 | 1311618 | 2021-05-12 | Webster | Missouri | 29225 | 3594 | 54 |
1298631 | 1298631 | 2021-05-08 | Webster | Missouri | 29225 | 3594 | 54 |
1299302 | 1299302 | 2021-05-08 | Clinton | Pennsylvania | 42035 | 3594 | 62 |
1295001 | 1295001 | 2021-05-07 | Worcester | Maryland | 24047 | 3594 | 98 |
1296079 | 1296079 | 2021-05-07 | McKean | Pennsylvania | 42083 | 3594 | 68 |
1291299 | 1291299 | 2021-05-06 | Putnam | Indiana | 18133 | 3594 | 60 |
1282686 | 1282686 | 2021-05-03 | Tioga | New York | 36107 | 3594 | 61 |
1278401 | 1278401 | 2021-05-02 | Marion | Iowa | 19125 | 3594 | 75 |
1260642 | 1260642 | 2021-04-26 | Macon | Tennessee | 47111 | 3594 | 77 |
1243155 | 1243155 | 2021-04-21 | Becker | Minnesota | 27005 | 3594 | 48 |
1228751 | 1228751 | 2021-04-16 | Clark | Wisconsin | 55019 | 3594 | 62 |
1225555 | 1225555 | 2021-04-15 | Trempealeau | Wisconsin | 55121 | 3594 | 42 |
1217232 | 1217232 | 2021-04-13 | Polk | Minnesota | 27119 | 3594 | 66 |
1213956 | 1213956 | 2021-04-12 | Itasca | Minnesota | 27061 | 3594 | 51 |
1213985 | 1213985 | 2021-04-12 | Polk | Minnesota | 27119 | 3594 | 66 |
1203042 | 1203042 | 2021-04-09 | Amador | California | 6005 | 3594 | 46 |
1164548 | 1164548 | 2021-03-28 | Montgomery | Illinois | 17135 | 3594 | 77 |
1158657 | 1158657 | 2021-03-26 | Hillsdale | Michigan | 26059 | 3594 | 79 |
1146524 | 1146524 | 2021-03-22 | Preble | Ohio | 39135 | 3594 | 93 |
1147068 | 1147068 | 2021-03-22 | Cooke | Texas | 48097 | 3594 | 65 |
1143821 | 1143821 | 2021-03-21 | Cooke | Texas | 48097 | 3594 | 65 |
1140574 | 1140574 | 2021-03-20 | Cooke | Texas | 48097 | 3594 | 65 |
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);