ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where cases = 4868 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 11
- New York 8
- Virginia 8
- Oklahoma 7
- Georgia 5
- Kentucky 4
- Missouri 4
- Ohio 4
- Oregon 4
- Texas 4
- West Virginia 4
- Alaska 3
- Arkansas 3
- Minnesota 3
- Wisconsin 3
- Alabama 2
- Colorado 2
- Florida 2
- Idaho 2
- Pennsylvania 2
- Puerto Rico 2
- Illinois 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Michigan 1
- New Jersey 1
- North Dakota 1
- Tennessee 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473817 | 2473817 | 2022-05-05 | Teller | Colorado | 8119 | 4868 | 57 |
2470868 | 2470868 | 2022-05-04 | Clark | Illinois | 17023 | 4868 | 60 |
2433532 | 2433532 | 2022-04-22 | Barranquitas | Puerto Rico | 72019 | 4868 | |
2430889 | 2430889 | 2022-04-21 | Colonial Heights city | Virginia | 51570 | 4868 | 97 |
2426878 | 2426878 | 2022-04-20 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2423622 | 2423622 | 2022-04-19 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2420365 | 2420365 | 2022-04-18 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2417110 | 2417110 | 2022-04-17 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2413854 | 2413854 | 2022-04-16 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2410598 | 2410598 | 2022-04-15 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2407342 | 2407342 | 2022-04-14 | McIntosh | Oklahoma | 40091 | 4868 | 124 |
2378762 | 2378762 | 2022-04-05 | Orange | Vermont | 50017 | 4868 | 14 |
2356097 | 2356097 | 2022-03-29 | Prince Edward | Virginia | 51147 | 4868 | 68 |
2352844 | 2352844 | 2022-03-28 | Prince Edward | Virginia | 51147 | 4868 | 68 |
2336496 | 2336496 | 2022-03-23 | Buchanan | Virginia | 51027 | 4868 | 109 |
2301100 | 2301100 | 2022-03-13 | Kodiak Island Borough | Alaska | 2150 | 4868 | 11 |
2297848 | 2297848 | 2022-03-12 | Kodiak Island Borough | Alaska | 2150 | 4868 | 11 |
2294596 | 2294596 | 2022-03-11 | Kodiak Island Borough | Alaska | 2150 | 4868 | 11 |
2281289 | 2281289 | 2022-03-06 | Radford city | Virginia | 51750 | 4868 | 46 |
2278036 | 2278036 | 2022-03-05 | Radford city | Virginia | 51750 | 4868 | 46 |
2274783 | 2274783 | 2022-03-04 | Radford city | Virginia | 51750 | 4868 | 46 |
2269855 | 2269855 | 2022-03-03 | Hubbard | Minnesota | 27057 | 4868 | 56 |
2270077 | 2270077 | 2022-03-03 | Perry | Missouri | 29157 | 4868 | 44 |
2262166 | 2262166 | 2022-03-01 | Randolph | Arkansas | 5121 | 4868 | 80 |
2259473 | 2259473 | 2022-02-28 | Fulton | Indiana | 18049 | 4868 | 101 |
2202872 | 2202872 | 2022-02-10 | Burleson | Texas | 48051 | 4868 | 63 |
2193858 | 2193858 | 2022-02-08 | Lawrence | Arkansas | 5075 | 4868 | 67 |
2147911 | 2147911 | 2022-01-24 | Lee | Virginia | 51105 | 4868 | 72 |
2126889 | 2126889 | 2022-01-18 | Audrain | Missouri | 29007 | 4868 | 89 |
2126992 | 2126992 | 2022-01-18 | Stone | Missouri | 29209 | 4868 | 101 |
2082525 | 2082525 | 2022-01-04 | Cass | Texas | 48067 | 4868 | 163 |
2063493 | 2063493 | 2021-12-29 | Nicholas | West Virginia | 54067 | 4868 | 74 |
2039676 | 2039676 | 2021-12-22 | Adams | Ohio | 39001 | 4868 | 115 |
2035448 | 2035448 | 2021-12-21 | Mercer | Kentucky | 21167 | 4868 | 93 |
2019246 | 2019246 | 2021-12-16 | De Soto | Louisiana | 22031 | 4868 | 113 |
2008835 | 2008835 | 2021-12-13 | Lee | Georgia | 13177 | 4868 | 82 |
1995393 | 1995393 | 2021-12-09 | Lawrence | Alabama | 1079 | 4868 | 130 |
1991660 | 1991660 | 2021-12-07 | Palo Pinto | Texas | 48363 | 4868 | 123 |
1930521 | 1930521 | 2021-11-19 | St. Francis | Arkansas | 5123 | 4868 | 69 |
1917827 | 1917827 | 2021-11-15 | Lumpkin | Georgia | 13187 | 4868 | 108 |
1894879 | 1894879 | 2021-11-08 | Logan | Colorado | 8075 | 4868 | 87 |
1893666 | 1893666 | 2021-11-07 | Snyder | Pennsylvania | 42109 | 4868 | 106 |
1880203 | 1880203 | 2021-11-03 | Chenango | New York | 36017 | 4868 | 92 |
1878262 | 1878262 | 2021-11-02 | Clark | Wisconsin | 55019 | 4868 | 79 |
1815599 | 1815599 | 2021-10-14 | Coos | Oregon | 41011 | 4868 | 91 |
1807675 | 1807675 | 2021-10-12 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1804424 | 1804424 | 2021-10-11 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1801175 | 1801175 | 2021-10-10 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1797926 | 1797926 | 2021-10-09 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1794677 | 1794677 | 2021-10-08 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1791429 | 1791429 | 2021-10-07 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1788180 | 1788180 | 2021-10-06 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1774421 | 1774421 | 2021-10-02 | Marion | Alabama | 1093 | 4868 | 125 |
1724966 | 1724966 | 2021-09-16 | Lauderdale | Tennessee | 47097 | 4868 | 55 |
1680006 | 1680006 | 2021-09-02 | Whitman | Washington | 53075 | 4868 | 54 |
1632470 | 1632470 | 2021-08-19 | Franklin | Kentucky | 21073 | 4868 | 61 |
1628129 | 1628129 | 2021-08-17 | Marinette | Wisconsin | 55075 | 4868 | 75 |
1622810 | 1622810 | 2021-08-16 | Whitley | Kentucky | 21235 | 4868 | 63 |
1576078 | 1576078 | 2021-08-01 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1572830 | 1572830 | 2021-07-31 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1569582 | 1569582 | 2021-07-30 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1552082 | 1552082 | 2021-07-25 | Clinton | New York | 36019 | 4868 | 33 |
1548835 | 1548835 | 2021-07-24 | Clinton | New York | 36019 | 4868 | 33 |
1545588 | 1545588 | 2021-07-23 | Clinton | New York | 36019 | 4868 | 33 |
1542341 | 1542341 | 2021-07-22 | Clinton | New York | 36019 | 4868 | 33 |
1529742 | 1529742 | 2021-07-18 | Klamath | Oregon | 41035 | 4868 | 79 |
1526495 | 1526495 | 2021-07-17 | Klamath | Oregon | 41035 | 4868 | 79 |
1523248 | 1523248 | 2021-07-16 | Klamath | Oregon | 41035 | 4868 | 79 |
1440711 | 1440711 | 2021-06-21 | Marshall | Iowa | 19127 | 4868 | 76 |
1426020 | 1426020 | 2021-06-16 | Toa Baja | Puerto Rico | 72137 | 4868 | |
1399769 | 1399769 | 2021-06-08 | Mercer | Ohio | 39107 | 4868 | 85 |
1396524 | 1396524 | 2021-06-07 | Mercer | Ohio | 39107 | 4868 | 85 |
1393277 | 1393277 | 2021-06-06 | Mercer | Ohio | 39107 | 4868 | 85 |
1385540 | 1385540 | 2021-06-04 | Muscatine | Iowa | 19139 | 4868 | 105 |
1375285 | 1375285 | 2021-06-01 | Hendry | Florida | 12051 | 4868 | 86 |
1359271 | 1359271 | 2021-05-27 | Bingham | Idaho | 16011 | 4868 | 76 |
1356025 | 1356025 | 2021-05-26 | Bingham | Idaho | 16011 | 4868 | 76 |
1341277 | 1341277 | 2021-05-21 | Stark | North Dakota | 38089 | 4868 | 51 |
1271002 | 1271002 | 2021-04-29 | Pierce | Wisconsin | 55093 | 4868 | 42 |
1261835 | 1261835 | 2021-04-27 | Tift | Georgia | 13277 | 4868 | 125 |
1249330 | 1249330 | 2021-04-23 | Boyd | Kentucky | 21019 | 4868 | 72 |
1217713 | 1217713 | 2021-04-13 | Herkimer | New York | 36043 | 4868 | 107 |
1218632 | 1218632 | 2021-04-13 | Medina | Texas | 48325 | 4868 | 103 |
1149154 | 1149154 | 2021-03-23 | Callaway | Missouri | 29027 | 4868 | 46 |
1076208 | 1076208 | 2021-02-28 | Fremont | Wyoming | 56013 | 4868 | 82 |
1059016 | 1059016 | 2021-02-23 | Armstrong | Pennsylvania | 42005 | 4868 | 116 |
1038166 | 1038166 | 2021-02-17 | Webster | Iowa | 19187 | 4868 | 84 |
1009278 | 1009278 | 2021-02-08 | Cecil | Maryland | 24015 | 4868 | 113 |
1005279 | 1005279 | 2021-02-07 | Habersham | Georgia | 13137 | 4868 | 127 |
988974 | 988974 | 2021-02-02 | Suwannee | Florida | 12121 | 4868 | 118 |
950990 | 950990 | 2021-01-21 | Crow Wing | Minnesota | 27035 | 4868 | 77 |
867153 | 867153 | 2020-12-26 | Saratoga | New York | 36091 | 4868 | 34 |
753074 | 753074 | 2020-11-21 | Sherburne | Minnesota | 27141 | 4868 | 38 |
615969 | 615969 | 2020-10-10 | Whitfield | Georgia | 13313 | 4868 | 62 |
490989 | 490989 | 2020-09-01 | Dutchess | New York | 36027 | 4868 | 153 |
285188 | 285188 | 2020-06-29 | Kent | Michigan | 26081 | 4868 | 132 |
222365 | 222365 | 2020-06-09 | Polk | Iowa | 19153 | 4868 | 151 |
74475 | 74475 | 2020-04-20 | Ocean | New Jersey | 34029 | 4868 | 222 |
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);