ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 4862 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Iowa 8
- Georgia 7
- Oklahoma 7
- South Carolina 7
- Louisiana 6
- Indiana 5
- Texas 5
- Colorado 4
- Illinois 4
- North Carolina 4
- West Virginia 4
- Minnesota 3
- Missouri 3
- Ohio 3
- Utah 3
- Vermont 3
- Arkansas 2
- Idaho 2
- Maryland 2
- New York 2
- Tennessee 2
- Virginia 2
- Wisconsin 2
- Alabama 1
- Florida 1
- Kentucky 1
- Michigan 1
- Mississippi 1
- Oregon 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497059 | 2497059 | 2022-05-12 | Jay | Indiana | 18075 | 4862 | 78 |
2493801 | 2493801 | 2022-05-11 | Jay | Indiana | 18075 | 4862 | 78 |
2495265 | 2495265 | 2022-05-11 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2492007 | 2492007 | 2022-05-10 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2488749 | 2488749 | 2022-05-09 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2485492 | 2485492 | 2022-05-08 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2482234 | 2482234 | 2022-05-07 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2478976 | 2478976 | 2022-05-06 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2475718 | 2475718 | 2022-05-05 | McIntosh | Oklahoma | 40091 | 4862 | 124 |
2470560 | 2470560 | 2022-05-04 | Teller | Colorado | 8119 | 4862 | 57 |
2467304 | 2467304 | 2022-05-03 | Teller | Colorado | 8119 | 4862 | 57 |
2326712 | 2326712 | 2022-03-20 | Orange | Vermont | 50017 | 4862 | 14 |
2323459 | 2323459 | 2022-03-19 | Orange | Vermont | 50017 | 4862 | 14 |
2320205 | 2320205 | 2022-03-18 | Orange | Vermont | 50017 | 4862 | 14 |
2309458 | 2309458 | 2022-03-15 | Currituck | North Carolina | 37053 | 4862 | 32 |
2239665 | 2239665 | 2022-02-22 | Cook | Georgia | 13075 | 4862 | 69 |
2199618 | 2199618 | 2022-02-09 | Burleson | Texas | 48051 | 4862 | 63 |
2189647 | 2189647 | 2022-02-06 | Hampton | South Carolina | 45049 | 4862 | 78 |
2186394 | 2186394 | 2022-02-05 | Hampton | South Carolina | 45049 | 4862 | 78 |
2183142 | 2183142 | 2022-02-04 | Hampton | South Carolina | 45049 | 4862 | 78 |
2180281 | 2180281 | 2022-02-03 | Scurry | Texas | 48415 | 4862 | 95 |
2177318 | 2177318 | 2022-02-02 | Lincoln | West Virginia | 54043 | 4862 | 62 |
2170575 | 2170575 | 2022-01-31 | Carbon | Utah | 49007 | 4862 | 42 |
2165656 | 2165656 | 2022-01-30 | Somerset | Maryland | 24039 | 4862 | 66 |
2145038 | 2145038 | 2022-01-24 | Conway | Arkansas | 5029 | 4862 | 50 |
2142826 | 2142826 | 2022-01-23 | St. James | Louisiana | 22093 | 4862 | 73 |
2139571 | 2139571 | 2022-01-22 | St. James | Louisiana | 22093 | 4862 | 73 |
2136315 | 2136315 | 2022-01-21 | St. James | Louisiana | 22093 | 4862 | 73 |
2129145 | 2129145 | 2022-01-19 | Pierce | Georgia | 13229 | 4862 | 108 |
2110694 | 2110694 | 2022-01-13 | Miller | Missouri | 29131 | 4862 | 105 |
2107087 | 2107087 | 2022-01-12 | Caroline | Maryland | 24011 | 4862 | 59 |
2108782 | 2108782 | 2022-01-12 | Unknown | Utah | 4862 | 60 | |
2077797 | 2077797 | 2022-01-03 | West Baton Rouge | Louisiana | 22121 | 4862 | 79 |
2060506 | 2060506 | 2021-12-29 | Johnson | Arkansas | 5071 | 4862 | 62 |
2057697 | 2057697 | 2021-12-28 | Latah | Idaho | 16057 | 4862 | 41 |
2058253 | 2058253 | 2021-12-28 | Franklin | Louisiana | 22041 | 4862 | 144 |
2027726 | 2027726 | 2021-12-18 | Hancock | West Virginia | 54029 | 4862 | 123 |
2012042 | 2012042 | 2021-12-14 | Decatur | Georgia | 13087 | 4862 | 110 |
2014179 | 2014179 | 2021-12-14 | Hickman | Tennessee | 47081 | 4862 | 81 |
1992115 | 1992115 | 2021-12-08 | Clarke | Alabama | 1025 | 4862 | 86 |
1986397 | 1986397 | 2021-12-06 | White | Indiana | 18181 | 4862 | 71 |
1925328 | 1925328 | 2021-11-17 | Tippah | Mississippi | 28139 | 4862 | 81 |
1914577 | 1914577 | 2021-11-14 | Lumpkin | Georgia | 13187 | 4862 | 108 |
1911327 | 1911327 | 2021-11-13 | Lumpkin | Georgia | 13187 | 4862 | 108 |
1908078 | 1908078 | 2021-11-12 | Lumpkin | Georgia | 13187 | 4862 | 108 |
1875403 | 1875403 | 2021-11-02 | Summit | Colorado | 8117 | 4862 | 11 |
1872503 | 1872503 | 2021-11-01 | Lee | Illinois | 17103 | 4862 | 101 |
1875013 | 1875013 | 2021-11-01 | Clark | Wisconsin | 55019 | 4862 | 79 |
1860234 | 1860234 | 2021-10-28 | Nobles | Minnesota | 27105 | 4862 | 52 |
1841480 | 1841480 | 2021-10-22 | Ottawa | Ohio | 39123 | 4862 | 86 |
1750243 | 1750243 | 2021-09-24 | Cortland | New York | 36023 | 4862 | 71 |
1736000 | 1736000 | 2021-09-20 | Christian | Illinois | 17021 | 4862 | 98 |
1727966 | 1727966 | 2021-09-17 | Wayne | Pennsylvania | 42127 | 4862 | 89 |
1679370 | 1679370 | 2021-09-02 | Williamsburg | South Carolina | 45089 | 4862 | 109 |
1632151 | 1632151 | 2021-08-19 | DeKalb | Indiana | 18033 | 4862 | 90 |
1603783 | 1603783 | 2021-08-10 | Platte | Missouri | 29165 | 4862 | 53 |
1605325 | 1605325 | 2021-08-10 | Marion | West Virginia | 54049 | 4862 | 55 |
1577820 | 1577820 | 2021-08-02 | Webster | Missouri | 29225 | 4862 | 66 |
1561880 | 1561880 | 2021-07-28 | Beaufort | North Carolina | 37013 | 4862 | 103 |
1520000 | 1520000 | 2021-07-15 | Klamath | Oregon | 41035 | 4862 | 79 |
1448990 | 1448990 | 2021-06-23 | Burnet | Texas | 48053 | 4862 | 67 |
1411497 | 1411497 | 2021-06-12 | Marshall | Iowa | 19127 | 4862 | 76 |
1408252 | 1408252 | 2021-06-11 | Marshall | Iowa | 19127 | 4862 | 76 |
1401605 | 1401605 | 2021-06-09 | Woodford | Illinois | 17203 | 4862 | 97 |
1395269 | 1395269 | 2021-06-07 | Marshall | Iowa | 19127 | 4862 | 76 |
1392024 | 1392024 | 2021-06-06 | Marshall | Iowa | 19127 | 4862 | 76 |
1385534 | 1385534 | 2021-06-04 | Marshall | Iowa | 19127 | 4862 | 76 |
1385978 | 1385978 | 2021-06-04 | Newaygo | Michigan | 26123 | 4862 | 68 |
1379049 | 1379049 | 2021-06-02 | Muscatine | Iowa | 19139 | 4862 | 104 |
1375803 | 1375803 | 2021-06-01 | Muscatine | Iowa | 19139 | 4862 | 104 |
1356116 | 1356116 | 2021-05-26 | Livingston | Illinois | 17105 | 4862 | 99 |
1290333 | 1290333 | 2021-05-05 | Washington | Virginia | 51191 | 4862 | 107 |
1284576 | 1284576 | 2021-05-04 | Ware | Georgia | 13299 | 4862 | 177 |
1267006 | 1267006 | 2021-04-28 | Newberry | South Carolina | 45071 | 4862 | 101 |
1222289 | 1222289 | 2021-04-14 | Oconto | Wisconsin | 55083 | 4862 | 57 |
1178771 | 1178771 | 2021-04-01 | Wayne | New York | 36117 | 4862 | 66 |
1127468 | 1127468 | 2021-03-16 | Franklin | Tennessee | 47051 | 4862 | 85 |
1097798 | 1097798 | 2021-03-07 | Huron | Ohio | 39077 | 4862 | 108 |
1087132 | 1087132 | 2021-03-04 | St. Martin | Louisiana | 22099 | 4862 | 112 |
1088838 | 1088838 | 2021-03-04 | Box Elder | Utah | 49003 | 4862 | 45 |
1089073 | 1089073 | 2021-03-04 | Harrison | West Virginia | 54033 | 4862 | 70 |
1031675 | 1031675 | 2021-02-15 | Webster | Iowa | 19187 | 4862 | 83 |
1029485 | 1029485 | 2021-02-14 | Halifax | North Carolina | 37083 | 4862 | 93 |
1018902 | 1018902 | 2021-02-11 | Pike | Kentucky | 21195 | 4862 | 51 |
1010207 | 1010207 | 2021-02-08 | Union | Ohio | 39159 | 4862 | 33 |
991241 | 991241 | 2021-02-02 | Caldwell | Texas | 48055 | 4862 | 67 |
948844 | 948844 | 2021-01-20 | Laurens | South Carolina | 45059 | 4862 | 107 |
935853 | 935853 | 2021-01-16 | Georgetown | South Carolina | 45043 | 4862 | 103 |
920189 | 920189 | 2021-01-11 | Lynchburg city | Virginia | 51680 | 4862 | 58 |
817172 | 817172 | 2020-12-11 | Madison | Idaho | 16065 | 4862 | 10 |
782224 | 782224 | 2020-11-30 | Carver | Minnesota | 27019 | 4862 | 15 |
717380 | 717380 | 2020-11-10 | Scott | Minnesota | 27139 | 4862 | 45 |
707019 | 707019 | 2020-11-07 | Porter | Indiana | 18127 | 4862 | 63 |
679908 | 679908 | 2020-10-29 | Tom Green | Texas | 48451 | 4862 | 80 |
557415 | 557415 | 2020-09-22 | Clay | Florida | 12019 | 4862 | 91 |
492648 | 492648 | 2020-09-02 | Jefferson | Colorado | 8059 | 4862 | 238 |
378209 | 378209 | 2020-07-28 | Guilford | North Carolina | 37081 | 4862 | 139 |
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);