ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 4265 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 19
- Mississippi 9
- West Virginia 8
- Florida 7
- Oklahoma 7
- North Carolina 6
- Ohio 5
- South Carolina 5
- Alabama 4
- Illinois 4
- Indiana 4
- Missouri 4
- New York 4
- Texas 4
- Utah 4
- Virginia 4
- Georgia 3
- Kansas 3
- Kentucky 3
- Arkansas 2
- Iowa 2
- Minnesota 2
- Puerto Rico 2
- Tennessee 2
- California 1
- Louisiana 1
- Maryland 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497029 | 2497029 | 2022-05-12 | Carroll | Indiana | 18015 | 4265 | 68 |
2498660 | 2498660 | 2022-05-12 | Aibonito | Puerto Rico | 72009 | 4265 | |
2493771 | 2493771 | 2022-05-11 | Carroll | Indiana | 18015 | 4265 | 68 |
2486060 | 2486060 | 2022-05-08 | Lavaca | Texas | 48285 | 4265 | 120 |
2471406 | 2471406 | 2022-05-04 | LaSalle | Louisiana | 22059 | 4265 | 60 |
2395025 | 2395025 | 2022-04-10 | Unknown | Utah | 4265 | 93 | |
2391769 | 2391769 | 2022-04-09 | Unknown | Utah | 4265 | 93 | |
2388513 | 2388513 | 2022-04-08 | Unknown | Utah | 4265 | 93 | |
2385258 | 2385258 | 2022-04-07 | Unknown | Utah | 4265 | 93 | |
2365242 | 2365242 | 2022-04-01 | Yabucoa | Puerto Rico | 72151 | 4265 | |
2291609 | 2291609 | 2022-03-10 | Gulf | Florida | 12045 | 4265 | 74 |
2288357 | 2288357 | 2022-03-09 | Gulf | Florida | 12045 | 4265 | 74 |
2285106 | 2285106 | 2022-03-08 | Gulf | Florida | 12045 | 4265 | 70 |
2281854 | 2281854 | 2022-03-07 | Gulf | Florida | 12045 | 4265 | 70 |
2278601 | 2278601 | 2022-03-06 | Gulf | Florida | 12045 | 4265 | 70 |
2275348 | 2275348 | 2022-03-05 | Gulf | Florida | 12045 | 4265 | 70 |
2272095 | 2272095 | 2022-03-04 | Gulf | Florida | 12045 | 4265 | 70 |
2241209 | 2241209 | 2022-02-22 | Northampton | North Carolina | 37131 | 4265 | 78 |
2210613 | 2210613 | 2022-02-13 | Hancock | Illinois | 17067 | 4265 | 53 |
2207360 | 2207360 | 2022-02-12 | Hancock | Illinois | 17067 | 4265 | 53 |
2204107 | 2204107 | 2022-02-11 | Hancock | Illinois | 17067 | 4265 | 53 |
2200854 | 2200854 | 2022-02-10 | Hancock | Illinois | 17067 | 4265 | 53 |
2177223 | 2177223 | 2022-02-02 | Prince Edward | Virginia | 51147 | 4265 | 56 |
2142598 | 2142598 | 2022-01-23 | Jefferson | Kansas | 20087 | 4265 | 54 |
2139343 | 2139343 | 2022-01-22 | Jefferson | Kansas | 20087 | 4265 | 54 |
2136087 | 2136087 | 2022-01-21 | Jefferson | Kansas | 20087 | 4265 | 54 |
2109249 | 2109249 | 2022-01-13 | Clark | Arkansas | 5019 | 4265 | 66 |
2082017 | 2082017 | 2022-01-04 | Wyandot | Ohio | 39175 | 4265 | 83 |
2076517 | 2076517 | 2022-01-02 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2073266 | 2073266 | 2022-01-01 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2070015 | 2070015 | 2021-12-31 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2066764 | 2066764 | 2021-12-30 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2051924 | 2051924 | 2021-12-26 | Otsego | Michigan | 26137 | 4265 | 78 |
2048674 | 2048674 | 2021-12-25 | Otsego | Michigan | 26137 | 4265 | 78 |
2045424 | 2045424 | 2021-12-24 | Otsego | Michigan | 26137 | 4265 | 78 |
2042174 | 2042174 | 2021-12-23 | Otsego | Michigan | 26137 | 4265 | 78 |
2038925 | 2038925 | 2021-12-22 | Otsego | Michigan | 26137 | 4265 | 78 |
2035861 | 2035861 | 2021-12-21 | Adair | Missouri | 29001 | 4265 | 48 |
2006716 | 2006716 | 2021-12-12 | Washington | Missouri | 29221 | 4265 | 98 |
1987387 | 1987387 | 2021-12-06 | Coos | New Hampshire | 33007 | 4265 | 75 |
1973351 | 1973351 | 2021-12-02 | LaGrange | Indiana | 18087 | 4265 | 92 |
1972470 | 1972470 | 2021-12-01 | Jackson | West Virginia | 54035 | 4265 | 93 |
1968324 | 1968324 | 2021-11-30 | Texas | Oklahoma | 40139 | 4265 | 39 |
1965073 | 1965073 | 2021-11-29 | Texas | Oklahoma | 40139 | 4265 | 39 |
1961061 | 1961061 | 2021-11-28 | Marion | Mississippi | 28091 | 4265 | 112 |
1961821 | 1961821 | 2021-11-28 | Texas | Oklahoma | 40139 | 4265 | 39 |
1957810 | 1957810 | 2021-11-27 | Marion | Mississippi | 28091 | 4265 | 112 |
1958570 | 1958570 | 2021-11-27 | Texas | Oklahoma | 40139 | 4265 | 39 |
1954559 | 1954559 | 2021-11-26 | Marion | Mississippi | 28091 | 4265 | 112 |
1955319 | 1955319 | 2021-11-26 | Texas | Oklahoma | 40139 | 4265 | 39 |
1951308 | 1951308 | 2021-11-25 | Marion | Mississippi | 28091 | 4265 | 112 |
1952068 | 1952068 | 2021-11-25 | Texas | Oklahoma | 40139 | 4265 | 39 |
1948057 | 1948057 | 2021-11-24 | Marion | Mississippi | 28091 | 4265 | 112 |
1948817 | 1948817 | 2021-11-24 | Texas | Oklahoma | 40139 | 4265 | 39 |
1938171 | 1938171 | 2021-11-21 | Wexford | Michigan | 26165 | 4265 | 62 |
1934921 | 1934921 | 2021-11-20 | Wexford | Michigan | 26165 | 4265 | 62 |
1931671 | 1931671 | 2021-11-19 | Wexford | Michigan | 26165 | 4265 | 62 |
1924335 | 1924335 | 2021-11-17 | Monroe | Georgia | 13207 | 4265 | 150 |
1883659 | 1883659 | 2021-11-04 | Adams | Ohio | 39001 | 4265 | 99 |
1834677 | 1834677 | 2021-10-20 | Cibola | New Mexico | 35006 | 4265 | 139 |
1821745 | 1821745 | 2021-10-16 | Orleans | New York | 36073 | 4265 | 87 |
1779122 | 1779122 | 2021-10-03 | Yazoo | Mississippi | 28163 | 4265 | 86 |
1775872 | 1775872 | 2021-10-02 | Yazoo | Mississippi | 28163 | 4265 | 86 |
1772622 | 1772622 | 2021-10-01 | Yazoo | Mississippi | 28163 | 4265 | 86 |
1724984 | 1724984 | 2021-09-16 | Overton | Tennessee | 47133 | 4265 | 66 |
1721115 | 1721115 | 2021-09-15 | Pasquotank | North Carolina | 37139 | 4265 | 93 |
1711848 | 1711848 | 2021-09-12 | Marlboro | South Carolina | 45069 | 4265 | 68 |
1708601 | 1708601 | 2021-09-11 | Marlboro | South Carolina | 45069 | 4265 | 68 |
1705354 | 1705354 | 2021-09-10 | Marlboro | South Carolina | 45069 | 4265 | 68 |
1702777 | 1702777 | 2021-09-09 | Marshall | West Virginia | 54051 | 4265 | 91 |
1665194 | 1665194 | 2021-08-29 | Huron | Michigan | 26063 | 4265 | 85 |
1661946 | 1661946 | 2021-08-28 | Huron | Michigan | 26063 | 4265 | 85 |
1658698 | 1658698 | 2021-08-27 | Huron | Michigan | 26063 | 4265 | 85 |
1650926 | 1650926 | 2021-08-24 | Teton | Wyoming | 56039 | 4265 | 11 |
1631614 | 1631614 | 2021-08-19 | Unknown | Arkansas | 4265 | 0 | |
1614026 | 1614026 | 2021-08-13 | Crawford | Ohio | 39033 | 4265 | 112 |
1602607 | 1602607 | 2021-08-10 | Bryan | Georgia | 13029 | 4265 | 42 |
1565220 | 1565220 | 2021-07-29 | Yadkin | North Carolina | 37197 | 4265 | 55 |
1541692 | 1541692 | 2021-07-22 | Calvert | Maryland | 24009 | 4265 | 86 |
1541801 | 1541801 | 2021-07-22 | Sanilac | Michigan | 26151 | 4265 | 125 |
1538554 | 1538554 | 2021-07-21 | Sanilac | Michigan | 26151 | 4265 | 125 |
1535307 | 1535307 | 2021-07-20 | Sanilac | Michigan | 26151 | 4265 | 125 |
1532616 | 1532616 | 2021-07-19 | Montgomery | New York | 36057 | 4265 | 128 |
1529369 | 1529369 | 2021-07-18 | Montgomery | New York | 36057 | 4265 | 128 |
1526122 | 1526122 | 2021-07-17 | Montgomery | New York | 36057 | 4265 | 128 |
1458940 | 1458940 | 2021-06-26 | Wharton | Texas | 48481 | 4265 | 117 |
1454413 | 1454413 | 2021-06-25 | Platte | Missouri | 29165 | 4265 | 48 |
1451059 | 1451059 | 2021-06-24 | Pontotoc | Mississippi | 28115 | 4265 | 73 |
1452013 | 1452013 | 2021-06-24 | Chester | South Carolina | 45023 | 4265 | 76 |
1390345 | 1390345 | 2021-06-05 | Chester | South Carolina | 45023 | 4265 | 76 |
1380842 | 1380842 | 2021-06-02 | Cherokee | Texas | 48073 | 4265 | 142 |
1358594 | 1358594 | 2021-05-26 | Ohio | West Virginia | 54069 | 4265 | 86 |
1339257 | 1339257 | 2021-05-21 | Franklin | Alabama | 1059 | 4265 | 82 |
1334105 | 1334105 | 2021-05-19 | McLeod | Minnesota | 27085 | 4265 | 59 |
1328302 | 1328302 | 2021-05-17 | Ashland | Ohio | 39005 | 4265 | 90 |
1281505 | 1281505 | 2021-05-03 | Clinton | Indiana | 18023 | 4265 | 58 |
1243935 | 1243935 | 2021-04-21 | Madison | Ohio | 39097 | 4265 | 59 |
1233991 | 1233991 | 2021-04-18 | Alexander | North Carolina | 37003 | 4265 | 83 |
1230743 | 1230743 | 2021-04-17 | Alexander | North Carolina | 37003 | 4265 | 83 |
1227495 | 1227495 | 2021-04-16 | Alexander | North Carolina | 37003 | 4265 | 83 |
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);