ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 3394 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Tennessee 12
- Arkansas 11
- Georgia 11
- Mississippi 10
- Iowa 7
- Minnesota 6
- North Carolina 6
- Wisconsin 6
- Indiana 5
- Kansas 5
- Ohio 5
- South Carolina 5
- Illinois 4
- West Virginia 4
- California 3
- Kentucky 3
- Massachusetts 3
- Pennsylvania 3
- Puerto Rico 3
- Washington 3
- Alabama 2
- Colorado 2
- Louisiana 2
- Michigan 2
- New York 2
- Virginia 2
- Arizona 1
- Delaware 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502171 | 2502171 | 2022-05-13 | Meigs | Tennessee | 47121 | 3394 | 58 |
2498913 | 2498913 | 2022-05-12 | Meigs | Tennessee | 47121 | 3394 | 58 |
2495655 | 2495655 | 2022-05-11 | Meigs | Tennessee | 47121 | 3394 | 58 |
2457387 | 2457387 | 2022-04-30 | Marion | Arkansas | 5089 | 3394 | 88 |
2459929 | 2459929 | 2022-04-30 | Duval | Texas | 48131 | 3394 | 70 |
2454131 | 2454131 | 2022-04-29 | Marion | Arkansas | 5089 | 3394 | 88 |
2450875 | 2450875 | 2022-04-28 | Marion | Arkansas | 5089 | 3394 | 88 |
2444479 | 2444479 | 2022-04-26 | Gunnison | Colorado | 8051 | 3394 | 14 |
2396610 | 2396610 | 2022-04-11 | Nantucket | Massachusetts | 25019 | 3394 | 0 |
2378775 | 2378775 | 2022-04-05 | Alleghany | Virginia | 51005 | 3394 | 93 |
2289245 | 2289245 | 2022-03-09 | Dukes | Massachusetts | 25007 | 3394 | 0 |
2289905 | 2289905 | 2022-03-09 | Schuyler | New York | 36097 | 3394 | 25 |
2285994 | 2285994 | 2022-03-08 | Dukes | Massachusetts | 25007 | 3394 | 0 |
2286015 | 2286015 | 2022-03-08 | Benzie | Michigan | 26019 | 3394 | 64 |
2282763 | 2282763 | 2022-03-07 | Benzie | Michigan | 26019 | 3394 | 64 |
2280681 | 2280681 | 2022-03-06 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2277428 | 2277428 | 2022-03-05 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2274175 | 2274175 | 2022-03-04 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2248950 | 2248950 | 2022-02-24 | Rusk | Wisconsin | 55107 | 3394 | 53 |
2245699 | 2245699 | 2022-02-23 | Rusk | Wisconsin | 55107 | 3394 | 53 |
2240335 | 2240335 | 2022-02-22 | Pendleton | Kentucky | 21191 | 3394 | 33 |
2225380 | 2225380 | 2022-02-17 | San German | Puerto Rico | 72125 | 3394 | |
2217317 | 2217317 | 2022-02-15 | Hamilton | Iowa | 19079 | 3394 | 67 |
2214066 | 2214066 | 2022-02-14 | Hamilton | Iowa | 19079 | 3394 | 67 |
2210814 | 2210814 | 2022-02-13 | Hamilton | Iowa | 19079 | 3394 | 67 |
2207561 | 2207561 | 2022-02-12 | Hamilton | Iowa | 19079 | 3394 | 67 |
2204308 | 2204308 | 2022-02-11 | Hamilton | Iowa | 19079 | 3394 | 67 |
2201055 | 2201055 | 2022-02-10 | Hamilton | Iowa | 19079 | 3394 | 67 |
2202032 | 2202032 | 2022-02-10 | Unknown | New Jersey | 3394 | 0 | |
2197801 | 2197801 | 2022-02-09 | Hamilton | Iowa | 19079 | 3394 | 67 |
2196050 | 2196050 | 2022-02-08 | Aibonito | Puerto Rico | 72009 | 3394 | |
2166828 | 2166828 | 2022-01-30 | Quebradillas | Puerto Rico | 72115 | 3394 | |
2145384 | 2145384 | 2022-01-24 | Jefferson | Georgia | 13163 | 3394 | 100 |
2145575 | 2145575 | 2022-01-24 | Massac | Illinois | 17127 | 3394 | 65 |
2123544 | 2123544 | 2022-01-17 | Wadena | Minnesota | 27159 | 3394 | 45 |
2120292 | 2120292 | 2022-01-16 | Wadena | Minnesota | 27159 | 3394 | 45 |
2117040 | 2117040 | 2022-01-15 | Wadena | Minnesota | 27159 | 3394 | 45 |
2113789 | 2113789 | 2022-01-14 | Wadena | Minnesota | 27159 | 3394 | 45 |
2111938 | 2111938 | 2022-01-13 | Panola | Texas | 48365 | 3394 | 113 |
2073475 | 2073475 | 2022-01-02 | Ashley | Arkansas | 5003 | 3394 | 55 |
2076518 | 2076518 | 2022-01-02 | Adams | Wisconsin | 55001 | 3394 | 41 |
2073267 | 2073267 | 2022-01-01 | Adams | Wisconsin | 55001 | 3394 | 41 |
2070016 | 2070016 | 2021-12-31 | Adams | Wisconsin | 55001 | 3394 | 41 |
2055212 | 2055212 | 2021-12-27 | Fillmore | Minnesota | 27045 | 3394 | 16 |
2033550 | 2033550 | 2021-12-20 | Fairfield | South Carolina | 45039 | 3394 | 93 |
2024736 | 2024736 | 2021-12-18 | Conway | Arkansas | 5029 | 3394 | 48 |
2021409 | 2021409 | 2021-12-17 | Monroe | Alabama | 1099 | 3394 | 66 |
2021171 | 2021171 | 2021-12-16 | Adams | Washington | 53001 | 3394 | 34 |
1963293 | 1963293 | 2021-11-29 | Elbert | Georgia | 13105 | 3394 | 90 |
1953066 | 1953066 | 2021-11-25 | Vilas | Wisconsin | 55125 | 3394 | 60 |
1891007 | 1891007 | 2021-11-06 | Bennington | Vermont | 50003 | 3394 | 27 |
1882215 | 1882215 | 2021-11-04 | Crawford | Illinois | 17033 | 3394 | 46 |
1855040 | 1855040 | 2021-10-26 | Deaf Smith | Texas | 48117 | 3394 | 75 |
1846348 | 1846348 | 2021-10-24 | Mitchell | Georgia | 13205 | 3394 | 100 |
1842769 | 1842769 | 2021-10-23 | Ouachita | Arkansas | 5103 | 3394 | 83 |
1843098 | 1843098 | 2021-10-23 | Mitchell | Georgia | 13205 | 3394 | 100 |
1839519 | 1839519 | 2021-10-22 | Ouachita | Arkansas | 5103 | 3394 | 83 |
1839848 | 1839848 | 2021-10-22 | Mitchell | Georgia | 13205 | 3394 | 100 |
1793153 | 1793153 | 2021-10-07 | Bledsoe | Tennessee | 47007 | 3394 | 14 |
1793745 | 1793745 | 2021-10-07 | Mason | West Virginia | 54053 | 3394 | 49 |
1767154 | 1767154 | 2021-09-29 | Yankton | South Dakota | 46135 | 3394 | 36 |
1734071 | 1734071 | 2021-09-19 | Dare | North Carolina | 37055 | 3394 | 11 |
1730821 | 1730821 | 2021-09-18 | Dare | North Carolina | 37055 | 3394 | 11 |
1727571 | 1727571 | 2021-09-17 | Dare | North Carolina | 37055 | 3394 | 11 |
1702425 | 1702425 | 2021-09-09 | Limestone | Texas | 48293 | 3394 | 92 |
1698525 | 1698525 | 2021-09-08 | Morrow | Ohio | 39117 | 3394 | 47 |
1674747 | 1674747 | 2021-09-01 | Mercer | Kentucky | 21167 | 3394 | 57 |
1669446 | 1669446 | 2021-08-30 | Clarion | Pennsylvania | 42031 | 3394 | 98 |
1643283 | 1643283 | 2021-08-22 | Jackson | Ohio | 39079 | 3394 | 54 |
1634120 | 1634120 | 2021-08-19 | Dimmit | Texas | 48127 | 3394 | 38 |
1607748 | 1607748 | 2021-08-11 | Jefferson | Pennsylvania | 42065 | 3394 | 99 |
1573142 | 1573142 | 2021-08-01 | Unknown | Arkansas | 3394 | 0 | |
1554269 | 1554269 | 2021-07-26 | White | Indiana | 18181 | 3394 | 55 |
1513225 | 1513225 | 2021-07-13 | Montgomery | North Carolina | 37123 | 3394 | 97 |
1495594 | 1495594 | 2021-07-08 | Bonner | Idaho | 16017 | 3394 | 45 |
1451068 | 1451068 | 2021-06-24 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1447822 | 1447822 | 2021-06-23 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1444577 | 1444577 | 2021-06-22 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1441332 | 1441332 | 2021-06-21 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1438086 | 1438086 | 2021-06-20 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1434839 | 1434839 | 2021-06-19 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1431592 | 1431592 | 2021-06-18 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1428347 | 1428347 | 2021-06-17 | Sunflower | Mississippi | 28133 | 3394 | 91 |
1363819 | 1363819 | 2021-05-28 | Greene | New York | 36039 | 3394 | 78 |
1354287 | 1354287 | 2021-05-25 | Champaign | Ohio | 39021 | 3394 | 58 |
1302415 | 1302415 | 2021-05-09 | Williams | Ohio | 39171 | 3394 | 75 |
1281318 | 1281318 | 2021-05-03 | Toombs | Georgia | 13279 | 3394 | 113 |
1266984 | 1266984 | 2021-04-28 | Clarendon | South Carolina | 45027 | 3394 | 111 |
1261696 | 1261696 | 2021-04-27 | Wakulla | Florida | 12129 | 3394 | 54 |
1251855 | 1251855 | 2021-04-24 | Montrose | Colorado | 8085 | 3394 | 58 |
1178098 | 1178098 | 2021-04-01 | Worcester | Maryland | 24047 | 3394 | 94 |
1171080 | 1171080 | 2021-03-30 | Adams | Indiana | 18001 | 3394 | 52 |
1171334 | 1171334 | 2021-03-30 | Montgomery | Kansas | 20125 | 3394 | 6 |
1168086 | 1168086 | 2021-03-29 | Montgomery | Kansas | 20125 | 3394 | 6 |
1164838 | 1164838 | 2021-03-28 | Montgomery | Kansas | 20125 | 3394 | 6 |
1161590 | 1161590 | 2021-03-27 | Montgomery | Kansas | 20125 | 3394 | 6 |
1158342 | 1158342 | 2021-03-26 | Montgomery | Kansas | 20125 | 3394 | 6 |
1156700 | 1156700 | 2021-03-25 | Hardin | Tennessee | 47071 | 3394 | 65 |
1151496 | 1151496 | 2021-03-24 | Bureau | Illinois | 17011 | 3394 | 91 |
1144812 | 1144812 | 2021-03-22 | Chattahoochee | Georgia | 13053 | 3394 | 12 |
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);