ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 4907 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 8
- Michigan 8
- Oklahoma 8
- Texas 8
- Indiana 6
- Alaska 5
- Minnesota 5
- Georgia 4
- Missouri 4
- Arkansas 3
- Idaho 3
- Iowa 3
- Montana 3
- North Carolina 3
- Alabama 2
- California 2
- Kentucky 2
- Ohio 2
- Oregon 2
- South Carolina 2
- Virginia 2
- Wisconsin 2
- Colorado 1
- Florida 1
- Hawaii 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Mississippi 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494411 | 2494411 | 2022-05-11 | Fillmore | Minnesota | 27045 | 4907 | 24 |
2380353 | 2380353 | 2022-04-06 | Charlevoix | Michigan | 26029 | 4907 | 60 |
2377098 | 2377098 | 2022-04-05 | Charlevoix | Michigan | 26029 | 4907 | 60 |
2353147 | 2353147 | 2022-03-29 | Kodiak Island Borough | Alaska | 2150 | 4907 | 12 |
2356101 | 2356101 | 2022-03-29 | Radford city | Virginia | 51750 | 4907 | 48 |
2349895 | 2349895 | 2022-03-28 | Kodiak Island Borough | Alaska | 2150 | 4907 | 12 |
2346642 | 2346642 | 2022-03-27 | Kodiak Island Borough | Alaska | 2150 | 4907 | 12 |
2343389 | 2343389 | 2022-03-26 | Kodiak Island Borough | Alaska | 2150 | 4907 | 12 |
2340136 | 2340136 | 2022-03-25 | Kodiak Island Borough | Alaska | 2150 | 4907 | 12 |
2330446 | 2330446 | 2022-03-22 | Lincoln | Arkansas | 5079 | 4907 | 66 |
2327194 | 2327194 | 2022-03-21 | Lincoln | Arkansas | 5079 | 4907 | 66 |
2327818 | 2327818 | 2022-03-21 | Rush | Indiana | 18139 | 4907 | 58 |
2308880 | 2308880 | 2022-03-15 | Hubbard | Minnesota | 27057 | 4907 | 58 |
2262395 | 2262395 | 2022-03-01 | Berrien | Georgia | 13019 | 4907 | 78 |
2259144 | 2259144 | 2022-02-28 | Berrien | Georgia | 13019 | 4907 | 78 |
2215493 | 2215493 | 2022-02-14 | Wasco | Oregon | 41065 | 4907 | 53 |
2187788 | 2187788 | 2022-02-06 | Jerome | Idaho | 16053 | 4907 | 60 |
2184535 | 2184535 | 2022-02-05 | Jerome | Idaho | 16053 | 4907 | 60 |
2167148 | 2167148 | 2022-01-30 | Gillespie | Texas | 48171 | 4907 | 96 |
2149512 | 2149512 | 2022-01-25 | Dodge | Minnesota | 27039 | 4907 | 14 |
2136338 | 2136338 | 2022-01-21 | Hancock | Maine | 23009 | 4907 | 68 |
2131770 | 2131770 | 2022-01-19 | Mason | West Virginia | 54053 | 4907 | 75 |
2126603 | 2126603 | 2022-01-18 | Garrett | Maryland | 24023 | 4907 | 103 |
2097763 | 2097763 | 2022-01-09 | Lake | Montana | 30047 | 4907 | 86 |
2094511 | 2094511 | 2022-01-08 | Lake | Montana | 30047 | 4907 | 86 |
2091259 | 2091259 | 2022-01-07 | Lake | Montana | 30047 | 4907 | 86 |
2034028 | 2034028 | 2021-12-20 | Franklin | Vermont | 50011 | 4907 | 55 |
1973120 | 1973120 | 2021-12-02 | Stephens | Georgia | 13257 | 4907 | 120 |
1967507 | 1967507 | 2021-11-30 | Todd | Minnesota | 27153 | 4907 | 43 |
1963084 | 1963084 | 2021-11-29 | Siskiyou | California | 6093 | 4907 | 70 |
1945037 | 1945037 | 2021-11-23 | Dakota | Nebraska | 31043 | 4907 | 82 |
1937563 | 1937563 | 2021-11-21 | Daviess | Indiana | 18027 | 4907 | 118 |
1934313 | 1934313 | 2021-11-20 | Daviess | Indiana | 18027 | 4907 | 118 |
1931062 | 1931062 | 2021-11-19 | Daviess | Indiana | 18027 | 4907 | 118 |
1904273 | 1904273 | 2021-11-10 | Green | Wisconsin | 55045 | 4907 | 34 |
1849812 | 1849812 | 2021-10-25 | Adams | Indiana | 18001 | 4907 | 78 |
1830279 | 1830279 | 2021-10-19 | Montgomery | Illinois | 17135 | 4907 | 87 |
1738124 | 1738124 | 2021-09-20 | Hopkins | Texas | 48223 | 4907 | 131 |
1734874 | 1734874 | 2021-09-19 | Hopkins | Texas | 48223 | 4907 | 131 |
1731624 | 1731624 | 2021-09-18 | Hopkins | Texas | 48223 | 4907 | 130 |
1720694 | 1720694 | 2021-09-15 | Lawrence | Missouri | 29109 | 4907 | 101 |
1647391 | 1647391 | 2021-08-23 | Danville city | Virginia | 51590 | 4907 | 149 |
1602827 | 1602827 | 2021-08-10 | Effingham | Illinois | 17049 | 4907 | 86 |
1593964 | 1593964 | 2021-08-07 | Butler | Missouri | 29023 | 4907 | 54 |
1578120 | 1578120 | 2021-08-02 | Beaufort | North Carolina | 37013 | 4907 | 103 |
1561075 | 1561075 | 2021-07-28 | Shelby | Kentucky | 21211 | 4907 | 79 |
1550931 | 1550931 | 2021-07-25 | Woodford | Illinois | 17203 | 4907 | 96 |
1547684 | 1547684 | 2021-07-24 | Woodford | Illinois | 17203 | 4907 | 96 |
1544437 | 1544437 | 2021-07-23 | Woodford | Illinois | 17203 | 4907 | 96 |
1541048 | 1541048 | 2021-07-22 | Bingham | Idaho | 16011 | 4907 | 77 |
1541905 | 1541905 | 2021-07-22 | Bolivar | Mississippi | 28011 | 4907 | 134 |
1509317 | 1509317 | 2021-07-12 | Newaygo | Michigan | 26123 | 4907 | 69 |
1506071 | 1506071 | 2021-07-11 | Newaygo | Michigan | 26123 | 4907 | 69 |
1502825 | 1502825 | 2021-07-10 | Newaygo | Michigan | 26123 | 4907 | 69 |
1499579 | 1499579 | 2021-07-09 | Newaygo | Michigan | 26123 | 4907 | 69 |
1482599 | 1482599 | 2021-07-04 | Maui | Hawaii | 15009 | 4907 | 57 |
1466466 | 1466466 | 2021-06-29 | Livingston | Illinois | 17105 | 4907 | 103 |
1463221 | 1463221 | 2021-06-28 | Livingston | Illinois | 17105 | 4907 | 103 |
1445313 | 1445313 | 2021-06-22 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1442068 | 1442068 | 2021-06-21 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1438823 | 1438823 | 2021-06-20 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1435576 | 1435576 | 2021-06-19 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1432329 | 1432329 | 2021-06-18 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1429083 | 1429083 | 2021-06-17 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1425838 | 1425838 | 2021-06-16 | Stephens | Oklahoma | 40137 | 4907 | 106 |
1416310 | 1416310 | 2021-06-13 | Chesterfield | South Carolina | 45025 | 4907 | 107 |
1299086 | 1299086 | 2021-05-08 | Auglaize | Ohio | 39011 | 4907 | 84 |
1294865 | 1294865 | 2021-05-07 | Nelson | Kentucky | 21179 | 4907 | 55 |
1282785 | 1282785 | 2021-05-03 | Vance | North Carolina | 37181 | 4907 | 86 |
1255052 | 1255052 | 2021-04-25 | Tehama | California | 6103 | 4907 | 53 |
1254762 | 1254762 | 2021-04-24 | Oconto | Wisconsin | 55083 | 4907 | 58 |
1171708 | 1171708 | 2021-03-30 | Benton | Minnesota | 27009 | 4907 | 95 |
1159518 | 1159518 | 2021-03-26 | Seneca | Ohio | 39147 | 4907 | 113 |
1149191 | 1149191 | 2021-03-23 | Johnson | Missouri | 29101 | 4907 | 48 |
1142697 | 1142697 | 2021-03-21 | Johnson | Missouri | 29101 | 4907 | 48 |
1119682 | 1119682 | 2021-03-14 | Chippewa | Michigan | 26033 | 4907 | 43 |
1116435 | 1116435 | 2021-03-13 | Chippewa | Michigan | 26033 | 4907 | 43 |
1100175 | 1100175 | 2021-03-08 | Berkshire | Massachusetts | 25003 | 4907 | 262 |
1073868 | 1073868 | 2021-02-28 | Webster | Iowa | 19187 | 4907 | 87 |
1070622 | 1070622 | 2021-02-27 | Webster | Iowa | 19187 | 4907 | 87 |
1067377 | 1067377 | 2021-02-26 | Webster | Iowa | 19187 | 4907 | 87 |
1053769 | 1053769 | 2021-02-22 | Eagle | Colorado | 8037 | 4907 | 20 |
1039309 | 1039309 | 2021-02-17 | Morton | North Dakota | 38059 | 4907 | 94 |
1031456 | 1031456 | 2021-02-15 | Ogle | Illinois | 17141 | 4907 | 79 |
1015016 | 1015016 | 2021-02-10 | Habersham | Georgia | 13137 | 4907 | 129 |
1006764 | 1006764 | 2021-02-07 | Granville | North Carolina | 37077 | 4907 | 74 |
948555 | 948555 | 2021-01-20 | Bryan | Oklahoma | 40013 | 4907 | 44 |
935652 | 935652 | 2021-01-16 | Deschutes | Oregon | 41017 | 4907 | 36 |
935996 | 935996 | 2021-01-16 | Loudon | Tennessee | 47105 | 4907 | 50 |
930549 | 930549 | 2021-01-15 | Putnam | Florida | 12107 | 4907 | 87 |
930925 | 930925 | 2021-01-15 | Marshall | Indiana | 18099 | 4907 | 84 |
862083 | 862083 | 2020-12-25 | Talladega | Alabama | 1121 | 4907 | 74 |
784267 | 784267 | 2020-12-01 | Faulkner | Arkansas | 5045 | 4907 | 56 |
760918 | 760918 | 2020-11-23 | Johnson | Texas | 48251 | 4907 | 94 |
757673 | 757673 | 2020-11-22 | Johnson | Texas | 48251 | 4907 | 93 |
754426 | 754426 | 2020-11-21 | Johnson | Texas | 48251 | 4907 | 93 |
751180 | 751180 | 2020-11-20 | Johnson | Texas | 48251 | 4907 | 91 |
745222 | 745222 | 2020-11-19 | Houston | Alabama | 1069 | 4907 | 38 |
663261 | 663261 | 2020-10-24 | Aiken | South Carolina | 45003 | 4907 | 86 |
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);