ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
204 rows where cases = 2679 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 24
- Kansas 23
- Missouri 16
- Ohio 13
- Mississippi 12
- Illinois 11
- Kentucky 10
- Virginia 10
- Tennessee 8
- Wisconsin 6
- Arkansas 5
- Florida 5
- Michigan 5
- Minnesota 5
- North Carolina 5
- Alabama 4
- Georgia 4
- Indiana 4
- Puerto Rico 4
- Colorado 3
- Louisiana 3
- South Carolina 3
- Texas 3
- West Virginia 3
- Arizona 2
- Idaho 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502536 | 2502536 | 2022-05-13 | Clarke | Virginia | 51043 | 2679 | 42 |
2495998 | 2495998 | 2022-05-11 | Amelia | Virginia | 51007 | 2679 | 60 |
2456360 | 2456360 | 2022-04-29 | Luquillo | Puerto Rico | 72089 | 2679 | |
2446586 | 2446586 | 2022-04-26 | Lajas | Puerto Rico | 72079 | 2679 | |
2443331 | 2443331 | 2022-04-25 | Lajas | Puerto Rico | 72079 | 2679 | |
2438337 | 2438337 | 2022-04-24 | Jasper | Illinois | 17079 | 2679 | 32 |
2440877 | 2440877 | 2022-04-24 | Forest | Wisconsin | 55041 | 2679 | 52 |
2435081 | 2435081 | 2022-04-23 | Jasper | Illinois | 17079 | 2679 | 32 |
2437621 | 2437621 | 2022-04-23 | Forest | Wisconsin | 55041 | 2679 | 52 |
2431825 | 2431825 | 2022-04-22 | Jasper | Illinois | 17079 | 2679 | 32 |
2434365 | 2434365 | 2022-04-22 | Forest | Wisconsin | 55041 | 2679 | 52 |
2422232 | 2422232 | 2022-04-19 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2418976 | 2418976 | 2022-04-18 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2415720 | 2415720 | 2022-04-17 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2412464 | 2412464 | 2022-04-16 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2409208 | 2409208 | 2022-04-15 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2405952 | 2405952 | 2022-04-14 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2402696 | 2402696 | 2022-04-13 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2383253 | 2383253 | 2022-04-07 | Brown | Kansas | 20013 | 2679 | 46 |
2379998 | 2379998 | 2022-04-06 | Brown | Kansas | 20013 | 2679 | 46 |
2376743 | 2376743 | 2022-04-05 | Brown | Kansas | 20013 | 2679 | 46 |
2373491 | 2373491 | 2022-04-04 | Brown | Kansas | 20013 | 2679 | 46 |
2370238 | 2370238 | 2022-04-03 | Brown | Kansas | 20013 | 2679 | 46 |
2366985 | 2366985 | 2022-04-02 | Brown | Kansas | 20013 | 2679 | 46 |
2363732 | 2363732 | 2022-04-01 | Brown | Kansas | 20013 | 2679 | 46 |
2360478 | 2360478 | 2022-03-31 | Brown | Kansas | 20013 | 2679 | 46 |
2357224 | 2357224 | 2022-03-30 | Brown | Kansas | 20013 | 2679 | 46 |
2353971 | 2353971 | 2022-03-29 | Brown | Kansas | 20013 | 2679 | 46 |
2350719 | 2350719 | 2022-03-28 | Brown | Kansas | 20013 | 2679 | 46 |
2347466 | 2347466 | 2022-03-27 | Brown | Kansas | 20013 | 2679 | 46 |
2344213 | 2344213 | 2022-03-26 | Brown | Kansas | 20013 | 2679 | 46 |
2340960 | 2340960 | 2022-03-25 | Brown | Kansas | 20013 | 2679 | 46 |
2337707 | 2337707 | 2022-03-24 | Brown | Kansas | 20013 | 2679 | 46 |
2334453 | 2334453 | 2022-03-23 | Brown | Kansas | 20013 | 2679 | 46 |
2328634 | 2328634 | 2022-03-21 | Ripley | Missouri | 29181 | 2679 | 61 |
2324694 | 2324694 | 2022-03-20 | Brown | Kansas | 20013 | 2679 | 47 |
2325382 | 2325382 | 2022-03-20 | Ripley | Missouri | 29181 | 2679 | 61 |
2321440 | 2321440 | 2022-03-19 | Brown | Kansas | 20013 | 2679 | 47 |
2322128 | 2322128 | 2022-03-19 | Ripley | Missouri | 29181 | 2679 | 61 |
2318186 | 2318186 | 2022-03-18 | Brown | Kansas | 20013 | 2679 | 47 |
2318874 | 2318874 | 2022-03-18 | Ripley | Missouri | 29181 | 2679 | 61 |
2315621 | 2315621 | 2022-03-17 | Ripley | Missouri | 29181 | 2679 | 61 |
2285665 | 2285665 | 2022-03-08 | Brown | Kansas | 20013 | 2679 | 47 |
2282413 | 2282413 | 2022-03-07 | Brown | Kansas | 20013 | 2679 | 47 |
2271510 | 2271510 | 2022-03-03 | Nelson | Virginia | 51125 | 2679 | 32 |
2262593 | 2262593 | 2022-03-01 | Teton | Idaho | 16081 | 2679 | 8 |
2259342 | 2259342 | 2022-02-28 | Teton | Idaho | 16081 | 2679 | 8 |
2257048 | 2257048 | 2022-02-27 | Lewis | Missouri | 29111 | 2679 | 34 |
2253797 | 2253797 | 2022-02-26 | Lewis | Missouri | 29111 | 2679 | 34 |
2250546 | 2250546 | 2022-02-25 | Lewis | Missouri | 29111 | 2679 | 34 |
2240372 | 2240372 | 2022-02-22 | Catahoula | Louisiana | 22025 | 2679 | 55 |
2233034 | 2233034 | 2022-02-20 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2229783 | 2229783 | 2022-02-19 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2226532 | 2226532 | 2022-02-18 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2130274 | 2130274 | 2022-01-19 | Glacier | Montana | 30035 | 2679 | 64 |
2130873 | 2130873 | 2022-01-19 | Baker | Oregon | 41001 | 2679 | 40 |
2113947 | 2113947 | 2022-01-14 | Mississippi | Missouri | 29133 | 2679 | 51 |
2079879 | 2079879 | 2022-01-04 | Cleburne | Alabama | 1029 | 2679 | 60 |
2080705 | 2080705 | 2022-01-04 | Harrison | Iowa | 19085 | 2679 | 83 |
2077453 | 2077453 | 2022-01-03 | Harrison | Iowa | 19085 | 2679 | 83 |
2074202 | 2074202 | 2022-01-02 | Harrison | Iowa | 19085 | 2679 | 83 |
2074424 | 2074424 | 2022-01-02 | Knott | Kentucky | 21119 | 2679 | 47 |
2070951 | 2070951 | 2022-01-01 | Harrison | Iowa | 19085 | 2679 | 83 |
2071173 | 2071173 | 2022-01-01 | Knott | Kentucky | 21119 | 2679 | 47 |
2067700 | 2067700 | 2021-12-31 | Harrison | Iowa | 19085 | 2679 | 83 |
2067922 | 2067922 | 2021-12-31 | Knott | Kentucky | 21119 | 2679 | 47 |
2064449 | 2064449 | 2021-12-30 | Harrison | Iowa | 19085 | 2679 | 83 |
2064671 | 2064671 | 2021-12-30 | Knott | Kentucky | 21119 | 2679 | 47 |
2061199 | 2061199 | 2021-12-29 | Harrison | Iowa | 19085 | 2679 | 83 |
2061421 | 2061421 | 2021-12-29 | Knott | Kentucky | 21119 | 2679 | 47 |
2040283 | 2040283 | 2021-12-22 | Colorado | Texas | 48089 | 2679 | 55 |
2035965 | 2035965 | 2021-12-21 | Ste. Genevieve | Missouri | 29186 | 2679 | 34 |
2015479 | 2015479 | 2021-12-15 | De Witt | Illinois | 17039 | 2679 | 39 |
1926786 | 1926786 | 2021-11-17 | Buchanan | Virginia | 51027 | 2679 | 71 |
1892696 | 1892696 | 2021-11-07 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1892826 | 1892826 | 2021-11-07 | Smith | Mississippi | 28129 | 2679 | 52 |
1889446 | 1889446 | 2021-11-06 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1889576 | 1889576 | 2021-11-06 | Smith | Mississippi | 28129 | 2679 | 52 |
1886196 | 1886196 | 2021-11-05 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1886326 | 1886326 | 2021-11-05 | Smith | Mississippi | 28129 | 2679 | 52 |
1878042 | 1878042 | 2021-11-02 | Buckingham | Virginia | 51029 | 2679 | 38 |
1859464 | 1859464 | 2021-10-28 | Cass | Illinois | 17017 | 2679 | 40 |
1850548 | 1850548 | 2021-10-25 | Holmes | Mississippi | 28051 | 2679 | 87 |
1847298 | 1847298 | 2021-10-24 | Holmes | Mississippi | 28051 | 2679 | 87 |
1844048 | 1844048 | 2021-10-23 | Holmes | Mississippi | 28051 | 2679 | 87 |
1840798 | 1840798 | 2021-10-22 | Holmes | Mississippi | 28051 | 2679 | 87 |
1816735 | 1816735 | 2021-10-15 | Clay | Arkansas | 5021 | 2679 | 66 |
1791771 | 1791771 | 2021-10-07 | LaSalle | Louisiana | 22059 | 2679 | 45 |
1787249 | 1787249 | 2021-10-05 | McDowell | West Virginia | 54047 | 2679 | 39 |
1780745 | 1780745 | 2021-10-03 | Lewis | West Virginia | 54041 | 2679 | 36 |
1740009 | 1740009 | 2021-09-21 | Martin | Minnesota | 27091 | 2679 | 33 |
1732836 | 1732836 | 2021-09-19 | Wayne | Illinois | 17191 | 2679 | 58 |
1729586 | 1729586 | 2021-09-18 | Wayne | Illinois | 17191 | 2679 | 58 |
1726336 | 1726336 | 2021-09-17 | Wayne | Illinois | 17191 | 2679 | 58 |
1703071 | 1703071 | 2021-09-10 | Polk | Arkansas | 5113 | 2679 | 91 |
1672021 | 1672021 | 2021-08-31 | Vernon | Missouri | 29217 | 2679 | 54 |
1667269 | 1667269 | 2021-08-30 | La Paz | Arizona | 4012 | 2679 | 81 |
1646574 | 1646574 | 2021-08-23 | Van Wert | Ohio | 39161 | 2679 | 65 |
1647005 | 1647005 | 2021-08-23 | Johnson | Tennessee | 47091 | 2679 | 40 |
1633985 | 1633985 | 2021-08-19 | Fentress | Tennessee | 47049 | 2679 | 50 |
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);