ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 6137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Kansas 17
- Mississippi 10
- Ohio 7
- Illinois 6
- New York 4
- Pennsylvania 4
- California 3
- Indiana 3
- Minnesota 3
- Georgia 2
- New Mexico 2
- North Carolina 2
- Tennessee 2
- Virginia 2
- Wisconsin 2
- Colorado 1
- Idaho 1
- Michigan 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- North Dakota 1
- Oregon 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488785 | 2488785 | 2022-05-09 | Crook | Oregon | 41013 | 6137 | 79 |
2383257 | 2383257 | 2022-04-07 | Cherokee | Kansas | 20021 | 6137 | 84 |
2380002 | 2380002 | 2022-04-06 | Cherokee | Kansas | 20021 | 6137 | 84 |
2376747 | 2376747 | 2022-04-05 | Cherokee | Kansas | 20021 | 6137 | 84 |
2373495 | 2373495 | 2022-04-04 | Cherokee | Kansas | 20021 | 6137 | 84 |
2370242 | 2370242 | 2022-04-03 | Cherokee | Kansas | 20021 | 6137 | 84 |
2366989 | 2366989 | 2022-04-02 | Cherokee | Kansas | 20021 | 6137 | 84 |
2363736 | 2363736 | 2022-04-01 | Cherokee | Kansas | 20021 | 6137 | 84 |
2364702 | 2364702 | 2022-04-01 | Lewis | New York | 36049 | 6137 | 49 |
2348049 | 2348049 | 2022-03-27 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2344796 | 2344796 | 2022-03-26 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2341543 | 2341543 | 2022-03-25 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2338290 | 2338290 | 2022-03-24 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2335036 | 2335036 | 2022-03-23 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2331782 | 2331782 | 2022-03-22 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2328530 | 2328530 | 2022-03-21 | Tishomingo | Mississippi | 28141 | 6137 | 122 |
2314937 | 2314937 | 2022-03-17 | Cherokee | Kansas | 20021 | 6137 | 83 |
2311684 | 2311684 | 2022-03-16 | Cherokee | Kansas | 20021 | 6137 | 83 |
2246039 | 2246039 | 2022-02-24 | Routt | Colorado | 8107 | 6137 | 24 |
2211433 | 2211433 | 2022-02-13 | Leake | Mississippi | 28079 | 6137 | 106 |
2208180 | 2208180 | 2022-02-12 | Leake | Mississippi | 28079 | 6137 | 106 |
2204927 | 2204927 | 2022-02-11 | Leake | Mississippi | 28079 | 6137 | 106 |
2177645 | 2177645 | 2022-02-03 | Glenn | California | 6021 | 6137 | 58 |
2165056 | 2165056 | 2022-01-30 | Douglas | Illinois | 17041 | 6137 | 55 |
2161801 | 2161801 | 2022-01-29 | Douglas | Illinois | 17041 | 6137 | 55 |
2158546 | 2158546 | 2022-01-28 | Douglas | Illinois | 17041 | 6137 | 55 |
2060162 | 2060162 | 2021-12-28 | Warren | Virginia | 51187 | 6137 | 107 |
2032976 | 2032976 | 2021-12-20 | Franklin | New York | 36033 | 6137 | 29 |
2030158 | 2030158 | 2021-12-19 | Greene | Pennsylvania | 42059 | 6137 | 77 |
2016714 | 2016714 | 2021-12-15 | Chenango | New York | 36017 | 6137 | 98 |
2016932 | 2016932 | 2021-12-15 | Champaign | Ohio | 39021 | 6137 | 93 |
1973019 | 1973019 | 2021-12-02 | Chattahoochee | Georgia | 13053 | 6137 | 21 |
1937549 | 1937549 | 2021-11-21 | Woodford | Illinois | 17203 | 6137 | 105 |
1934299 | 1934299 | 2021-11-20 | Woodford | Illinois | 17203 | 6137 | 105 |
1931048 | 1931048 | 2021-11-19 | Woodford | Illinois | 17203 | 6137 | 105 |
1801745 | 1801745 | 2021-10-10 | Mower | Minnesota | 27099 | 6137 | 39 |
1798496 | 1798496 | 2021-10-09 | Mower | Minnesota | 27099 | 6137 | 39 |
1799188 | 1799188 | 2021-10-09 | Brown | Ohio | 39015 | 6137 | 79 |
1795247 | 1795247 | 2021-10-08 | Mower | Minnesota | 27099 | 6137 | 39 |
1778364 | 1778364 | 2021-10-03 | Huntington | Indiana | 18069 | 6137 | 99 |
1775114 | 1775114 | 2021-10-02 | Huntington | Indiana | 18069 | 6137 | 99 |
1771864 | 1771864 | 2021-10-01 | Huntington | Indiana | 18069 | 6137 | 99 |
1750693 | 1750693 | 2021-09-24 | Mifflin | Pennsylvania | 42087 | 6137 | 184 |
1740687 | 1740687 | 2021-09-21 | Stark | North Dakota | 38089 | 6137 | 52 |
1656008 | 1656008 | 2021-08-26 | Otero | New Mexico | 35035 | 6137 | 91 |
1633573 | 1633573 | 2021-08-19 | Union | Ohio | 39159 | 6137 | 49 |
1554398 | 1554398 | 2021-07-26 | Finney | Kansas | 20055 | 6137 | 73 |
1551151 | 1551151 | 2021-07-25 | Finney | Kansas | 20055 | 6137 | 73 |
1547904 | 1547904 | 2021-07-24 | Finney | Kansas | 20055 | 6137 | 73 |
1544657 | 1544657 | 2021-07-23 | Finney | Kansas | 20055 | 6137 | 73 |
1541409 | 1541409 | 2021-07-22 | Finney | Kansas | 20055 | 6137 | 73 |
1538162 | 1538162 | 2021-07-21 | Finney | Kansas | 20055 | 6137 | 73 |
1534914 | 1534914 | 2021-07-20 | Finney | Kansas | 20055 | 6137 | 73 |
1531667 | 1531667 | 2021-07-19 | Finney | Kansas | 20055 | 6137 | 73 |
1533965 | 1533965 | 2021-07-19 | Waupaca | Wisconsin | 55135 | 6137 | 167 |
1516314 | 1516314 | 2021-07-14 | Salem | New Jersey | 34033 | 6137 | 188 |
1492003 | 1492003 | 2021-07-07 | San Benito | California | 6069 | 6137 | 63 |
1488756 | 1488756 | 2021-07-06 | San Benito | California | 6069 | 6137 | 63 |
1441807 | 1441807 | 2021-06-21 | Lee | North Carolina | 37105 | 6137 | 83 |
1396477 | 1396477 | 2021-06-07 | Belmont | Ohio | 39013 | 6137 | 174 |
1337300 | 1337300 | 2021-05-20 | St. Joseph | Michigan | 26149 | 6137 | 97 |
1220986 | 1220986 | 2021-04-14 | St. Lawrence | New York | 36089 | 6137 | 94 |
1215198 | 1215198 | 2021-04-12 | Roane | Tennessee | 47145 | 6137 | 100 |
1163616 | 1163616 | 2021-03-27 | Harrisonburg city | Virginia | 51660 | 6137 | 95 |
1149707 | 1149707 | 2021-03-23 | Ashtabula | Ohio | 39007 | 6137 | 158 |
1141062 | 1141062 | 2021-03-20 | Calumet | Wisconsin | 55015 | 6137 | 50 |
1094996 | 1094996 | 2021-03-06 | Cumberland | Tennessee | 47035 | 6137 | 123 |
1015095 | 1015095 | 2021-02-10 | Walker | Georgia | 13295 | 6137 | 72 |
1009889 | 1009889 | 2021-02-08 | Eddy | New Mexico | 35015 | 6137 | 102 |
886861 | 886861 | 2021-01-01 | Pickaway | Ohio | 39129 | 6137 | 50 |
883616 | 883616 | 2020-12-31 | Pickaway | Ohio | 39129 | 6137 | 50 |
835530 | 835530 | 2020-12-16 | Guadalupe | Texas | 48187 | 6137 | 93 |
802271 | 802271 | 2020-12-06 | Buncombe | North Carolina | 37021 | 6137 | 143 |
717769 | 717769 | 2020-11-10 | Hillsborough | New Hampshire | 33011 | 6137 | 325 |
659930 | 659930 | 2020-10-23 | York | Pennsylvania | 42133 | 6137 | 199 |
568520 | 568520 | 2020-09-25 | Lancaster | Nebraska | 31109 | 6137 | 24 |
428352 | 428352 | 2020-08-13 | Canyon | Idaho | 16027 | 6137 | 51 |
400345 | 400345 | 2020-08-04 | Kansas City | Missouri | 6137 | 69 | |
333672 | 333672 | 2020-07-14 | Bucks | Pennsylvania | 42017 | 6137 | 572 |
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);