ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 4431 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Oklahoma 11
- Tennessee 8
- Illinois 7
- Louisiana 7
- Virginia 7
- Ohio 6
- Kentucky 5
- Texas 5
- Indiana 4
- Puerto Rico 4
- Arkansas 3
- North Carolina 3
- Pennsylvania 3
- South Carolina 3
- Colorado 2
- Georgia 2
- Michigan 2
- Mississippi 2
- New York 2
- Delaware 1
- Florida 1
- Idaho 1
- Maine 1
- Minnesota 1
- Missouri 1
- North Dakota 1
- Oregon 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2425300 | 2425300 | 2022-04-20 | Ford | Illinois | 17053 | 4431 | 73 |
2416092 | 2416092 | 2022-04-17 | Winn | Louisiana | 22127 | 4431 | 63 |
2412836 | 2412836 | 2022-04-16 | Winn | Louisiana | 22127 | 4431 | 63 |
2409580 | 2409580 | 2022-04-15 | Winn | Louisiana | 22127 | 4431 | 63 |
2406324 | 2406324 | 2022-04-14 | Winn | Louisiana | 22127 | 4431 | 63 |
2312690 | 2312690 | 2022-03-16 | Avery | North Carolina | 37011 | 4431 | 43 |
2286056 | 2286056 | 2022-03-08 | Manistee | Michigan | 26101 | 4431 | 84 |
2282804 | 2282804 | 2022-03-07 | Manistee | Michigan | 26101 | 4431 | 84 |
2246247 | 2246247 | 2022-02-24 | Putnam | Georgia | 13237 | 4431 | 100 |
2191498 | 2191498 | 2022-02-07 | Garrard | Kentucky | 21079 | 4431 | 64 |
2177580 | 2177580 | 2022-02-03 | Drew | Arkansas | 5043 | 4431 | 58 |
2178565 | 2178565 | 2022-02-03 | Wayne | Kentucky | 21231 | 4431 | 80 |
2165047 | 2165047 | 2022-01-30 | Clark | Illinois | 17023 | 4431 | 55 |
2161792 | 2161792 | 2022-01-29 | Clark | Illinois | 17023 | 4431 | 55 |
2158537 | 2158537 | 2022-01-28 | Clark | Illinois | 17023 | 4431 | 55 |
2075972 | 2075972 | 2022-01-02 | Smith | Tennessee | 47159 | 4431 | 64 |
2072470 | 2072470 | 2022-01-01 | Dorado | Puerto Rico | 72051 | 4431 | |
2072721 | 2072721 | 2022-01-01 | Smith | Tennessee | 47159 | 4431 | 64 |
2069219 | 2069219 | 2021-12-31 | Dorado | Puerto Rico | 72051 | 4431 | |
2069470 | 2069470 | 2021-12-31 | Smith | Tennessee | 47159 | 4431 | 64 |
2066219 | 2066219 | 2021-12-30 | Smith | Tennessee | 47159 | 4431 | 64 |
2057046 | 2057046 | 2021-12-27 | Kewaunee | Wisconsin | 55061 | 4431 | 49 |
2036584 | 2036584 | 2021-12-21 | Texas | Oklahoma | 40139 | 4431 | 41 |
2033334 | 2033334 | 2021-12-20 | Texas | Oklahoma | 40139 | 4431 | 41 |
2030084 | 2030084 | 2021-12-19 | Texas | Oklahoma | 40139 | 4431 | 41 |
2030901 | 2030901 | 2021-12-19 | Russell | Virginia | 51167 | 4431 | 71 |
2026833 | 2026833 | 2021-12-18 | Texas | Oklahoma | 40139 | 4431 | 41 |
2027650 | 2027650 | 2021-12-18 | Russell | Virginia | 51167 | 4431 | 71 |
2023582 | 2023582 | 2021-12-17 | Texas | Oklahoma | 40139 | 4431 | 41 |
2024399 | 2024399 | 2021-12-17 | Russell | Virginia | 51167 | 4431 | 71 |
2020331 | 2020331 | 2021-12-16 | Texas | Oklahoma | 40139 | 4431 | 41 |
2017080 | 2017080 | 2021-12-15 | Texas | Oklahoma | 40139 | 4431 | 41 |
2012185 | 2012185 | 2021-12-14 | Elmore | Idaho | 16039 | 4431 | 52 |
1994338 | 1994338 | 2021-12-08 | Columbia | Oregon | 41009 | 4431 | 56 |
1967595 | 1967595 | 2021-11-30 | Wayne | Mississippi | 28153 | 4431 | 72 |
1905078 | 1905078 | 2021-11-11 | Greene | Indiana | 18055 | 4431 | 102 |
1836715 | 1836715 | 2021-10-21 | Bureau | Illinois | 17011 | 4431 | 104 |
1825335 | 1825335 | 2021-10-17 | Unknown | Oklahoma | 4431 | 0 | |
1822086 | 1822086 | 2021-10-16 | Unknown | Oklahoma | 4431 | 0 | |
1818837 | 1818837 | 2021-10-15 | Unknown | Oklahoma | 4431 | 0 | |
1747096 | 1747096 | 2021-09-23 | Macon | North Carolina | 37113 | 4431 | 49 |
1723094 | 1723094 | 2021-09-16 | Adams | Indiana | 18001 | 4431 | 66 |
1712934 | 1712934 | 2021-09-13 | Montrose | Colorado | 8085 | 4431 | 75 |
1711800 | 1711800 | 2021-09-12 | Trujillo Alto | Puerto Rico | 72139 | 4431 | |
1695830 | 1695830 | 2021-09-07 | Cooke | Texas | 48097 | 4431 | 76 |
1692582 | 1692582 | 2021-09-06 | Cooke | Texas | 48097 | 4431 | 76 |
1689333 | 1689333 | 2021-09-05 | Cooke | Texas | 48097 | 4431 | 76 |
1685726 | 1685726 | 2021-09-04 | Pike | Pennsylvania | 42103 | 4431 | 55 |
1686083 | 1686083 | 2021-09-04 | Cooke | Texas | 48097 | 4431 | 76 |
1677928 | 1677928 | 2021-09-02 | Calloway | Kentucky | 21035 | 4431 | 56 |
1669273 | 1669273 | 2021-08-30 | Logan | Ohio | 39091 | 4431 | 79 |
1629222 | 1629222 | 2021-08-18 | Floyd | Kentucky | 21071 | 4431 | 75 |
1623148 | 1623148 | 2021-08-16 | Lincoln | Mississippi | 28085 | 4431 | 119 |
1613531 | 1613531 | 2021-08-13 | Pulaski | Missouri | 29169 | 4431 | 60 |
1605729 | 1605729 | 2021-08-11 | La Plata | Colorado | 8067 | 4431 | 45 |
1603574 | 1603574 | 2021-08-10 | McLeod | Minnesota | 27085 | 4431 | 61 |
1580576 | 1580576 | 2021-08-03 | Whitley | Kentucky | 21235 | 4431 | 62 |
1555538 | 1555538 | 2021-07-26 | Ashland | Ohio | 39005 | 4431 | 98 |
1552827 | 1552827 | 2021-07-25 | Rhea | Tennessee | 47143 | 4431 | 82 |
1549580 | 1549580 | 2021-07-24 | Rhea | Tennessee | 47143 | 4431 | 82 |
1546333 | 1546333 | 2021-07-23 | Rhea | Tennessee | 47143 | 4431 | 82 |
1538420 | 1538420 | 2021-07-21 | Webster | Louisiana | 22119 | 4431 | 116 |
1515174 | 1515174 | 2021-07-14 | Monroe | Illinois | 17133 | 4431 | 94 |
1477411 | 1477411 | 2021-07-02 | Fulton | New York | 36035 | 4431 | 93 |
1471488 | 1471488 | 2021-06-30 | Dillon | South Carolina | 45033 | 4431 | 85 |
1420530 | 1420530 | 2021-06-15 | Miller | Arkansas | 5091 | 4431 | 38 |
1402082 | 1402082 | 2021-06-09 | Washington | Louisiana | 22117 | 4431 | 134 |
1399764 | 1399764 | 2021-06-08 | Madison | Ohio | 39097 | 4431 | 65 |
1396519 | 1396519 | 2021-06-07 | Madison | Ohio | 39097 | 4431 | 65 |
1393272 | 1393272 | 2021-06-06 | Madison | Ohio | 39097 | 4431 | 65 |
1290226 | 1290226 | 2021-05-05 | Campbell | Virginia | 51031 | 4431 | 84 |
1271799 | 1271799 | 2021-04-30 | Lawrence | Indiana | 18093 | 4431 | 123 |
1242977 | 1242977 | 2021-04-21 | Lincoln | Louisiana | 22061 | 4431 | 92 |
1225330 | 1225330 | 2021-04-15 | James City | Virginia | 51095 | 4431 | 70 |
1209068 | 1209068 | 2021-04-10 | Fauquier | Virginia | 51061 | 4431 | 63 |
1190299 | 1190299 | 2021-04-05 | Effingham | Georgia | 13103 | 4431 | 65 |
1152086 | 1152086 | 2021-03-24 | Penobscot | Maine | 23019 | 4431 | 87 |
1140806 | 1140806 | 2021-03-20 | Wasatch | Utah | 49051 | 4431 | 21 |
1125572 | 1125572 | 2021-03-16 | Macoupin | Illinois | 17117 | 4431 | 109 |
1120785 | 1120785 | 2021-03-14 | Guaynabo | Puerto Rico | 72061 | 4431 | |
1094902 | 1094902 | 2021-03-06 | Newberry | South Carolina | 45071 | 4431 | 92 |
1058956 | 1058956 | 2021-02-23 | Osage | Oklahoma | 40113 | 4431 | 44 |
1052317 | 1052317 | 2021-02-21 | Williams | North Dakota | 38105 | 4431 | 36 |
945218 | 945218 | 2021-01-19 | Ashtabula | Ohio | 39007 | 4431 | 72 |
929221 | 929221 | 2021-01-14 | Indiana | Pennsylvania | 42063 | 4431 | 137 |
896774 | 896774 | 2021-01-04 | Lawrence | Pennsylvania | 42073 | 4431 | 130 |
881630 | 881630 | 2020-12-31 | Greene | Arkansas | 5055 | 4431 | 51 |
858622 | 858622 | 2020-12-23 | Thurston | Washington | 53067 | 4431 | 52 |
817288 | 817288 | 2020-12-11 | Bartholomew | Indiana | 18005 | 4431 | 75 |
737296 | 737296 | 2020-11-16 | Broome | New York | 36007 | 4431 | 124 |
727666 | 727666 | 2020-11-13 | Iredell | North Carolina | 37097 | 4431 | 35 |
699386 | 699386 | 2020-11-04 | Wichita | Texas | 48485 | 4431 | 53 |
650489 | 650489 | 2020-10-20 | Wilson | Tennessee | 47189 | 4431 | 53 |
624338 | 624338 | 2020-10-12 | Dorchester | South Carolina | 45035 | 4431 | 91 |
331194 | 331194 | 2020-07-13 | Loudoun | Virginia | 51107 | 4431 | 99 |
249781 | 249781 | 2020-06-18 | Sussex | Delaware | 10005 | 4431 | 152 |
81546 | 81546 | 2020-04-23 | Broward | Florida | 12011 | 4431 | 157 |
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);