ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 4848 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 12
- Oklahoma 9
- Indiana 8
- Minnesota 8
- Virginia 7
- Alabama 6
- Kentucky 6
- Michigan 6
- Mississippi 6
- Missouri 6
- Louisiana 5
- Arkansas 4
- Illinois 4
- North Dakota 3
- Texas 3
- New York 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- Wisconsin 2
- Arizona 1
- Florida 1
- Iowa 1
- Maryland 1
- Montana 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Ohio 1
- Tennessee 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467474 | 2467474 | 2022-05-03 | Lamar | Georgia | 13171 | 4848 | 112 |
2464219 | 2464219 | 2022-05-02 | Lamar | Georgia | 13171 | 4848 | 112 |
2460963 | 2460963 | 2022-05-01 | Lamar | Georgia | 13171 | 4848 | 112 |
2457707 | 2457707 | 2022-04-30 | Lamar | Georgia | 13171 | 4848 | 112 |
2454451 | 2454451 | 2022-04-29 | Lamar | Georgia | 13171 | 4848 | 112 |
2451195 | 2451195 | 2022-04-28 | Lamar | Georgia | 13171 | 4848 | 112 |
2447939 | 2447939 | 2022-04-27 | Lamar | Georgia | 13171 | 4848 | 112 |
2417865 | 2417865 | 2022-04-17 | Colonial Heights city | Virginia | 51570 | 4848 | 96 |
2414609 | 2414609 | 2022-04-16 | Colonial Heights city | Virginia | 51570 | 4848 | 96 |
2411353 | 2411353 | 2022-04-15 | Colonial Heights city | Virginia | 51570 | 4848 | 96 |
2314772 | 2314772 | 2022-03-17 | Jay | Indiana | 18075 | 4848 | 78 |
2311519 | 2311519 | 2022-03-16 | Jay | Indiana | 18075 | 4848 | 78 |
2308266 | 2308266 | 2022-03-15 | Jay | Indiana | 18075 | 4848 | 78 |
2236716 | 2236716 | 2022-02-21 | Fulton | Indiana | 18049 | 4848 | 101 |
2212973 | 2212973 | 2022-02-13 | King George | Virginia | 51099 | 4848 | 31 |
2209720 | 2209720 | 2022-02-12 | King George | Virginia | 51099 | 4848 | 31 |
2206467 | 2206467 | 2022-02-11 | King George | Virginia | 51099 | 4848 | 31 |
2198536 | 2198536 | 2022-02-09 | New Madrid | Missouri | 29143 | 4848 | 75 |
2199229 | 2199229 | 2022-02-09 | Wasco | Oregon | 41065 | 4848 | 53 |
2184103 | 2184103 | 2022-02-05 | Logan | Arkansas | 5083 | 4848 | 59 |
2178211 | 2178211 | 2022-02-03 | Orange | Indiana | 18117 | 4848 | 91 |
2164487 | 2164487 | 2022-01-30 | Pickens | Alabama | 1107 | 4848 | 93 |
2160638 | 2160638 | 2022-01-28 | Gillespie | Texas | 48171 | 4848 | 96 |
2118736 | 2118736 | 2022-01-15 | Boone | West Virginia | 54005 | 4848 | 62 |
2101200 | 2101200 | 2022-01-10 | Grant | New Mexico | 35017 | 4848 | 65 |
2058643 | 2058643 | 2021-12-28 | Dunklin | Missouri | 29069 | 4848 | 93 |
2054985 | 2054985 | 2021-12-27 | Allen | Louisiana | 22003 | 4848 | 119 |
2006243 | 2006243 | 2021-12-12 | De Soto | Louisiana | 22031 | 4848 | 113 |
2002992 | 2002992 | 2021-12-11 | De Soto | Louisiana | 22031 | 4848 | 113 |
1999742 | 1999742 | 2021-12-10 | De Soto | Louisiana | 22031 | 4848 | 113 |
1972160 | 1972160 | 2021-12-01 | Palo Pinto | Texas | 48363 | 4848 | 122 |
1966115 | 1966115 | 2021-11-30 | Clarke | Alabama | 1025 | 4848 | 86 |
1963874 | 1963874 | 2021-11-29 | Carter | Kentucky | 21043 | 4848 | 68 |
1891829 | 1891829 | 2021-11-07 | Lumpkin | Georgia | 13187 | 4848 | 107 |
1888579 | 1888579 | 2021-11-06 | Lumpkin | Georgia | 13187 | 4848 | 107 |
1885329 | 1885329 | 2021-11-05 | Lumpkin | Georgia | 13187 | 4848 | 107 |
1887166 | 1887166 | 2021-11-05 | Snyder | Pennsylvania | 42109 | 4848 | 106 |
1863952 | 1863952 | 2021-10-29 | Allegany | New York | 36003 | 4848 | 101 |
1813389 | 1813389 | 2021-10-14 | Dallas | Alabama | 1047 | 4848 | 199 |
1815326 | 1815326 | 2021-10-14 | Macon | North Carolina | 37113 | 4848 | 54 |
1807034 | 1807034 | 2021-10-12 | Poinsett | Arkansas | 5111 | 4848 | 98 |
1785201 | 1785201 | 2021-10-05 | Marshall | Kentucky | 21157 | 4848 | 75 |
1768619 | 1768619 | 2021-09-30 | Jefferson | Indiana | 18077 | 4848 | 93 |
1746719 | 1746719 | 2021-09-23 | Pulaski | Missouri | 29169 | 4848 | 69 |
1683589 | 1683589 | 2021-09-04 | Unknown | Arkansas | 4848 | 0 | |
1681711 | 1681711 | 2021-09-03 | Lawrence | Missouri | 29109 | 4848 | 97 |
1672845 | 1672845 | 2021-08-31 | Colleton | South Carolina | 45029 | 4848 | 148 |
1665277 | 1665277 | 2021-08-29 | Itasca | Minnesota | 27061 | 4848 | 69 |
1662029 | 1662029 | 2021-08-28 | Itasca | Minnesota | 27061 | 4848 | 69 |
1658781 | 1658781 | 2021-08-27 | Itasca | Minnesota | 27061 | 4848 | 69 |
1620713 | 1620713 | 2021-08-15 | Bedford | Pennsylvania | 42009 | 4848 | 142 |
1615226 | 1615226 | 2021-08-14 | Franklin | Alabama | 1059 | 4848 | 83 |
1611977 | 1611977 | 2021-08-13 | Franklin | Alabama | 1059 | 4848 | 83 |
1608762 | 1608762 | 2021-08-12 | Tallapoosa | Alabama | 1123 | 4848 | 157 |
1606180 | 1606180 | 2021-08-11 | Gibson | Indiana | 18051 | 4848 | 100 |
1555067 | 1555067 | 2021-07-26 | Scott | Missouri | 29201 | 4848 | 88 |
1536198 | 1536198 | 2021-07-20 | Osage | Oklahoma | 40113 | 4848 | 81 |
1532094 | 1532094 | 2021-07-19 | Goodhue | Minnesota | 27049 | 4848 | 74 |
1532950 | 1532950 | 2021-07-19 | Osage | Oklahoma | 40113 | 4848 | 81 |
1532966 | 1532966 | 2021-07-19 | Unknown | Oklahoma | 4848 | 0 | |
1528847 | 1528847 | 2021-07-18 | Goodhue | Minnesota | 27049 | 4848 | 74 |
1529703 | 1529703 | 2021-07-18 | Osage | Oklahoma | 40113 | 4848 | 81 |
1525600 | 1525600 | 2021-07-17 | Goodhue | Minnesota | 27049 | 4848 | 74 |
1526456 | 1526456 | 2021-07-17 | Osage | Oklahoma | 40113 | 4848 | 81 |
1522353 | 1522353 | 2021-07-16 | Goodhue | Minnesota | 27049 | 4848 | 74 |
1523209 | 1523209 | 2021-07-16 | Osage | Oklahoma | 40113 | 4848 | 81 |
1519961 | 1519961 | 2021-07-15 | Osage | Oklahoma | 40113 | 4848 | 81 |
1516713 | 1516713 | 2021-07-14 | Osage | Oklahoma | 40113 | 4848 | 81 |
1486708 | 1486708 | 2021-07-05 | Bolivar | Mississippi | 28011 | 4848 | 134 |
1483462 | 1483462 | 2021-07-04 | Bolivar | Mississippi | 28011 | 4848 | 134 |
1480216 | 1480216 | 2021-07-03 | Bolivar | Mississippi | 28011 | 4848 | 134 |
1476969 | 1476969 | 2021-07-02 | Bolivar | Mississippi | 28011 | 4848 | 134 |
1470477 | 1470477 | 2021-06-30 | Bolivar | Mississippi | 28011 | 4848 | 134 |
1463987 | 1463987 | 2021-06-28 | Bolivar | Mississippi | 28011 | 4848 | 133 |
1450290 | 1450290 | 2021-06-24 | Woodford | Illinois | 17203 | 4848 | 96 |
1433783 | 1433783 | 2021-06-19 | Colquitt | Georgia | 13071 | 4848 | 128 |
1429515 | 1429515 | 2021-06-17 | Burnet | Texas | 48053 | 4848 | 66 |
1361787 | 1361787 | 2021-05-27 | Lewis | Washington | 53041 | 4848 | 69 |
1356328 | 1356328 | 2021-05-26 | Muscatine | Iowa | 19139 | 4848 | 103 |
1334782 | 1334782 | 2021-05-19 | Stark | North Dakota | 38089 | 4848 | 51 |
1318559 | 1318559 | 2021-05-14 | Williams | North Dakota | 38105 | 4848 | 39 |
1287087 | 1287087 | 2021-05-04 | Washington | Virginia | 51191 | 4848 | 106 |
1267755 | 1267755 | 2021-04-28 | Pierce | Wisconsin | 55093 | 4848 | 42 |
1242353 | 1242353 | 2021-04-21 | Tift | Georgia | 13277 | 4848 | 125 |
1233095 | 1233095 | 2021-04-18 | Boyd | Kentucky | 21019 | 4848 | 72 |
1229475 | 1229475 | 2021-04-17 | Jackson | Illinois | 17077 | 4848 | 74 |
1211218 | 1211218 | 2021-04-11 | Herkimer | New York | 36043 | 4848 | 107 |
1209297 | 1209297 | 2021-04-10 | Oconto | Wisconsin | 55083 | 4848 | 57 |
1165151 | 1165151 | 2021-03-28 | Grand Traverse | Michigan | 26055 | 4848 | 77 |
1161903 | 1161903 | 2021-03-27 | Grand Traverse | Michigan | 26055 | 4848 | 77 |
1126463 | 1126463 | 2021-03-16 | Johnson | Missouri | 29101 | 4848 | 48 |
1091304 | 1091304 | 2021-03-05 | Huron | Ohio | 39077 | 4848 | 108 |
1091429 | 1091429 | 2021-03-05 | Washington | Oklahoma | 40147 | 4848 | 89 |
1073118 | 1073118 | 2021-02-28 | Hot Spring | Arkansas | 5059 | 4848 | 66 |
1072642 | 1072642 | 2021-02-27 | Chittenden | Vermont | 50007 | 4848 | 88 |
1015657 | 1015657 | 2021-02-10 | Pike | Kentucky | 21195 | 4848 | 51 |
987379 | 987379 | 2021-02-01 | Morton | North Dakota | 38059 | 4848 | 93 |
969216 | 969216 | 2021-01-27 | Graham | Arizona | 4009 | 4848 | 65 |
947744 | 947744 | 2021-01-20 | Crow Wing | Minnesota | 27035 | 4848 | 77 |
934497 | 934497 | 2021-01-16 | McCracken | Kentucky | 21145 | 4848 | 47 |
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);