ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4602 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 14
- Florida 11
- Iowa 11
- Ohio 10
- Alaska 7
- Louisiana 6
- Nebraska 6
- Virginia 6
- Pennsylvania 5
- Texas 5
- Illinois 4
- Mississippi 4
- Georgia 3
- Idaho 3
- Kentucky 3
- Missouri 3
- North Carolina 3
- Michigan 2
- Wisconsin 2
- Wyoming 2
- Hawaii 1
- Indiana 1
- Minnesota 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489762 | 2489762 | 2022-05-09 | Sawyer | Wisconsin | 55113 | 4602 | 62 |
2472457 | 2472457 | 2022-05-04 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2469201 | 2469201 | 2022-05-03 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2465945 | 2465945 | 2022-05-02 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2462690 | 2462690 | 2022-05-01 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2459434 | 2459434 | 2022-04-30 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2456178 | 2456178 | 2022-04-29 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2452922 | 2452922 | 2022-04-28 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2426874 | 2426874 | 2022-04-20 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2422262 | 2422262 | 2022-04-19 | Jackson | Iowa | 19097 | 4602 | 68 |
2423618 | 2423618 | 2022-04-19 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2419006 | 2419006 | 2022-04-18 | Jackson | Iowa | 19097 | 4602 | 68 |
2420361 | 2420361 | 2022-04-18 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2415750 | 2415750 | 2022-04-17 | Jackson | Iowa | 19097 | 4602 | 68 |
2417106 | 2417106 | 2022-04-17 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2412494 | 2412494 | 2022-04-16 | Jackson | Iowa | 19097 | 4602 | 68 |
2413850 | 2413850 | 2022-04-16 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2409238 | 2409238 | 2022-04-15 | Jackson | Iowa | 19097 | 4602 | 68 |
2410594 | 2410594 | 2022-04-15 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2405982 | 2405982 | 2022-04-14 | Jackson | Iowa | 19097 | 4602 | 68 |
2407338 | 2407338 | 2022-04-14 | Marshall | Oklahoma | 40095 | 4602 | 43 |
2402726 | 2402726 | 2022-04-13 | Jackson | Iowa | 19097 | 4602 | 68 |
2398710 | 2398710 | 2022-04-12 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2395455 | 2395455 | 2022-04-11 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2392199 | 2392199 | 2022-04-10 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2388943 | 2388943 | 2022-04-09 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2385688 | 2385688 | 2022-04-08 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2382433 | 2382433 | 2022-04-07 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2379178 | 2379178 | 2022-04-06 | Northwest Arctic Borough | Alaska | 2188 | 4602 | 13 |
2358450 | 2358450 | 2022-03-30 | Paulding | Ohio | 39125 | 4602 | 74 |
2355196 | 2355196 | 2022-03-29 | Paulding | Ohio | 39125 | 4602 | 74 |
2351943 | 2351943 | 2022-03-28 | Paulding | Ohio | 39125 | 4602 | 74 |
2348691 | 2348691 | 2022-03-27 | Paulding | Ohio | 39125 | 4602 | 74 |
2345438 | 2345438 | 2022-03-26 | Paulding | Ohio | 39125 | 4602 | 74 |
2342185 | 2342185 | 2022-03-25 | Paulding | Ohio | 39125 | 4602 | 74 |
2337414 | 2337414 | 2022-03-24 | Cass | Illinois | 17017 | 4602 | 44 |
2338932 | 2338932 | 2022-03-24 | Paulding | Ohio | 39125 | 4602 | 74 |
2331611 | 2331611 | 2022-03-22 | Roscommon | Michigan | 26143 | 4602 | 113 |
2328359 | 2328359 | 2022-03-21 | Roscommon | Michigan | 26143 | 4602 | 113 |
2284666 | 2284666 | 2022-03-07 | Adams | Wisconsin | 55001 | 4602 | 53 |
2263084 | 2263084 | 2022-03-01 | Morgan | Kentucky | 21175 | 4602 | 17 |
2245284 | 2245284 | 2022-02-23 | Montague | Texas | 48337 | 4602 | 120 |
2236560 | 2236560 | 2022-02-21 | Cassia | Idaho | 16031 | 4602 | 53 |
2233309 | 2233309 | 2022-02-20 | Cassia | Idaho | 16031 | 4602 | 53 |
2230058 | 2230058 | 2022-02-19 | Cassia | Idaho | 16031 | 4602 | 53 |
2202171 | 2202171 | 2022-02-10 | Hertford | North Carolina | 37091 | 4602 | 80 |
2202225 | 2202225 | 2022-02-10 | Yancey | North Carolina | 37199 | 4602 | 49 |
2186251 | 2186251 | 2022-02-05 | Juniata | Pennsylvania | 42067 | 4602 | 168 |
2151086 | 2151086 | 2022-01-25 | Orleans | Vermont | 50019 | 4602 | 31 |
2112149 | 2112149 | 2022-01-13 | Page | Virginia | 51139 | 4602 | 93 |
2037098 | 2037098 | 2021-12-21 | Hockley | Texas | 48219 | 4602 | 139 |
1993533 | 1993533 | 2021-12-08 | Copiah | Mississippi | 28029 | 4602 | 95 |
1978255 | 1978255 | 2021-12-03 | Trujillo Alto | Puerto Rico | 72139 | 4602 | |
1971497 | 1971497 | 2021-12-01 | Van Wert | Ohio | 39161 | 4602 | 93 |
1963235 | 1963235 | 2021-11-29 | Taylor | Florida | 12123 | 4602 | 82 |
1959984 | 1959984 | 2021-11-28 | Taylor | Florida | 12123 | 4602 | 82 |
1956733 | 1956733 | 2021-11-27 | Taylor | Florida | 12123 | 4602 | 82 |
1958438 | 1958438 | 2021-11-27 | Gallia | Ohio | 39053 | 4602 | 78 |
1953482 | 1953482 | 2021-11-26 | Taylor | Florida | 12123 | 4602 | 82 |
1950231 | 1950231 | 2021-11-25 | Taylor | Florida | 12123 | 4602 | 82 |
1952838 | 1952838 | 2021-11-25 | Isle of Wight | Virginia | 51093 | 4602 | 91 |
1946980 | 1946980 | 2021-11-24 | Taylor | Florida | 12123 | 4602 | 82 |
1943729 | 1943729 | 2021-11-23 | Taylor | Florida | 12123 | 4602 | 82 |
1940479 | 1940479 | 2021-11-22 | Taylor | Florida | 12123 | 4602 | 82 |
1937229 | 1937229 | 2021-11-21 | Taylor | Florida | 12123 | 4602 | 82 |
1933979 | 1933979 | 2021-11-20 | Taylor | Florida | 12123 | 4602 | 82 |
1930727 | 1930727 | 2021-11-19 | Taylor | Florida | 12123 | 4602 | 81 |
1882014 | 1882014 | 2021-11-04 | Chattooga | Georgia | 13055 | 4602 | 104 |
1837661 | 1837661 | 2021-10-21 | Lafayette | Missouri | 29107 | 4602 | 73 |
1813901 | 1813901 | 2021-10-14 | Unknown | Georgia | 4602 | 8 | |
1815290 | 1815290 | 2021-10-14 | Cherokee | North Carolina | 37039 | 4602 | 74 |
1786247 | 1786247 | 2021-10-05 | Ottawa | Ohio | 39123 | 4602 | 85 |
1747450 | 1747450 | 2021-09-23 | Perry | Pennsylvania | 42099 | 4602 | 105 |
1727538 | 1727538 | 2021-09-17 | Warren | New York | 36113 | 4602 | 76 |
1705229 | 1705229 | 2021-09-10 | Venango | Pennsylvania | 42121 | 4602 | 108 |
1702121 | 1702121 | 2021-09-09 | Brookings | South Dakota | 46011 | 4602 | 37 |
1699425 | 1699425 | 2021-09-08 | Petersburg city | Virginia | 51730 | 4602 | 93 |
1665503 | 1665503 | 2021-08-29 | Pulaski | Missouri | 29169 | 4602 | 62 |
1636243 | 1636243 | 2021-08-20 | Marion | Missouri | 29127 | 4602 | 56 |
1588391 | 1588391 | 2021-08-05 | Dillon | South Carolina | 45033 | 4602 | 85 |
1493243 | 1493243 | 2021-07-07 | Marshall | Mississippi | 28093 | 4602 | 105 |
1471812 | 1471812 | 2021-06-30 | Kerr | Texas | 48265 | 4602 | 92 |
1447698 | 1447698 | 2021-06-23 | Itasca | Minnesota | 27061 | 4602 | 63 |
1449565 | 1449565 | 2021-06-23 | Albany | Wyoming | 56001 | 4602 | 17 |
1400898 | 1400898 | 2021-06-08 | Sweetwater | Wyoming | 56037 | 4602 | 39 |
1387470 | 1387470 | 2021-06-04 | Nacogdoches | Texas | 48347 | 4602 | 172 |
1379335 | 1379335 | 2021-06-02 | Lincoln | Louisiana | 22061 | 4602 | 93 |
1356019 | 1356019 | 2021-05-26 | Maui | Hawaii | 15009 | 4602 | 54 |
1344721 | 1344721 | 2021-05-22 | Klamath | Oregon | 41035 | 4602 | 70 |
1319490 | 1319490 | 2021-05-14 | James City | Virginia | 51095 | 4602 | 72 |
1316242 | 1316242 | 2021-05-13 | James City | Virginia | 51095 | 4602 | 72 |
1287724 | 1287724 | 2021-05-05 | Effingham | Georgia | 13103 | 4602 | 68 |
1239235 | 1239235 | 2021-04-20 | Macoupin | Illinois | 17117 | 4602 | 110 |
1233256 | 1233256 | 2021-04-18 | St. Mary | Louisiana | 22101 | 4602 | 134 |
1230008 | 1230008 | 2021-04-17 | St. Mary | Louisiana | 22101 | 4602 | 134 |
1226760 | 1226760 | 2021-04-16 | St. Mary | Louisiana | 22101 | 4602 | 134 |
1223513 | 1223513 | 2021-04-15 | St. Mary | Louisiana | 22101 | 4602 | 134 |
1191607 | 1191607 | 2021-04-05 | Scotts Bluff | Nebraska | 31157 | 4602 | 95 |
1169187 | 1169187 | 2021-03-29 | Williams | North Dakota | 38105 | 4602 | 37 |
1126748 | 1126748 | 2021-03-16 | Otero | New Mexico | 35035 | 4602 | 68 |
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);