ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 4696 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Virginia 10
- Missouri 8
- North Carolina 8
- Oklahoma 8
- Georgia 5
- Kansas 5
- Kentucky 5
- Pennsylvania 5
- Wisconsin 5
- Ohio 4
- West Virginia 4
- Alabama 3
- Michigan 3
- Arkansas 2
- California 2
- Indiana 2
- Minnesota 2
- Mississippi 2
- Montana 2
- New Mexico 2
- Washington 2
- Wyoming 2
- Arizona 1
- Florida 1
- Idaho 1
- Illinois 1
- Louisiana 1
- New Hampshire 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2312730 | 2312730 | 2022-03-16 | Hertford | North Carolina | 37091 | 4696 | 81 |
2309166 | 2309166 | 2022-03-15 | Lincoln | Montana | 30053 | 4696 | 86 |
2309477 | 2309477 | 2022-03-15 | Hertford | North Carolina | 37091 | 4696 | 81 |
2228534 | 2228534 | 2022-02-18 | Juniata | Pennsylvania | 42067 | 4696 | 172 |
2224988 | 2224988 | 2022-02-17 | Yancey | North Carolina | 37199 | 4696 | 50 |
2210895 | 2210895 | 2022-02-13 | Dickinson | Kansas | 20041 | 4696 | 70 |
2207642 | 2207642 | 2022-02-12 | Dickinson | Kansas | 20041 | 4696 | 70 |
2204389 | 2204389 | 2022-02-11 | Dickinson | Kansas | 20041 | 4696 | 70 |
2201136 | 2201136 | 2022-02-10 | Dickinson | Kansas | 20041 | 4696 | 70 |
2197882 | 2197882 | 2022-02-09 | Dickinson | Kansas | 20041 | 4696 | 70 |
2177317 | 2177317 | 2022-02-02 | Lewis | West Virginia | 54041 | 4696 | 75 |
2097193 | 2097193 | 2022-01-09 | Letcher | Kentucky | 21133 | 4696 | 86 |
2093941 | 2093941 | 2022-01-08 | Letcher | Kentucky | 21133 | 4696 | 86 |
2090689 | 2090689 | 2022-01-07 | Letcher | Kentucky | 21133 | 4696 | 86 |
2086488 | 2086488 | 2022-01-06 | Carroll | Arkansas | 5015 | 4696 | 81 |
2074954 | 2074954 | 2022-01-02 | Saline | Missouri | 29195 | 4696 | 86 |
2071703 | 2071703 | 2022-01-01 | Saline | Missouri | 29195 | 4696 | 86 |
2068452 | 2068452 | 2021-12-31 | Saline | Missouri | 29195 | 4696 | 86 |
2065201 | 2065201 | 2021-12-30 | Saline | Missouri | 29195 | 4696 | 86 |
2058981 | 2058981 | 2021-12-28 | Lewis | New York | 36049 | 4696 | 41 |
2027745 | 2027745 | 2021-12-18 | Nicholas | West Virginia | 54067 | 4696 | 71 |
2014889 | 2014889 | 2021-12-15 | Geneva | Alabama | 1061 | 4696 | 137 |
1993605 | 1993605 | 2021-12-08 | Barry | Missouri | 29009 | 4696 | 92 |
1985466 | 1985466 | 2021-12-05 | Hancock | West Virginia | 54029 | 4696 | 120 |
1974691 | 1974691 | 2021-12-02 | Gallia | Ohio | 39053 | 4696 | 78 |
1945634 | 1945634 | 2021-11-23 | Elk | Pennsylvania | 42047 | 4696 | 65 |
1930152 | 1930152 | 2021-11-18 | Wythe | Virginia | 51197 | 4696 | 105 |
1922519 | 1922519 | 2021-11-16 | Cherokee | North Carolina | 37039 | 4696 | 77 |
1901135 | 1901135 | 2021-11-10 | Lawrence | Alabama | 1079 | 4696 | 125 |
1896040 | 1896040 | 2021-11-08 | Itawamba | Mississippi | 28057 | 4696 | 106 |
1896053 | 1896053 | 2021-11-08 | Leflore | Mississippi | 28083 | 4696 | 144 |
1859305 | 1859305 | 2021-10-28 | Gilmer | Georgia | 13123 | 4696 | 134 |
1839172 | 1839172 | 2021-10-21 | Clallam | Washington | 53009 | 4696 | 55 |
1828197 | 1828197 | 2021-10-18 | Rio Arriba | New Mexico | 35039 | 4696 | 83 |
1822145 | 1822145 | 2021-10-16 | Clinton | Pennsylvania | 42035 | 4696 | 71 |
1807385 | 1807385 | 2021-10-12 | Stephens | Georgia | 13257 | 4696 | 99 |
1763548 | 1763548 | 2021-09-28 | Custer | Oklahoma | 40039 | 4696 | 110 |
1760299 | 1760299 | 2021-09-27 | Custer | Oklahoma | 40039 | 4696 | 110 |
1757051 | 1757051 | 2021-09-26 | Custer | Oklahoma | 40039 | 4696 | 110 |
1753803 | 1753803 | 2021-09-25 | Custer | Oklahoma | 40039 | 4696 | 110 |
1750555 | 1750555 | 2021-09-24 | Custer | Oklahoma | 40039 | 4696 | 110 |
1745620 | 1745620 | 2021-09-23 | Madison | Georgia | 13195 | 4696 | 65 |
1747305 | 1747305 | 2021-09-23 | Custer | Oklahoma | 40039 | 4696 | 110 |
1744056 | 1744056 | 2021-09-22 | Custer | Oklahoma | 40039 | 4696 | 110 |
1723130 | 1723130 | 2021-09-16 | Jasper | Indiana | 18073 | 4696 | 64 |
1712457 | 1712457 | 2021-09-12 | York | Virginia | 51199 | 4696 | 62 |
1709210 | 1709210 | 2021-09-11 | York | Virginia | 51199 | 4696 | 62 |
1705963 | 1705963 | 2021-09-10 | York | Virginia | 51199 | 4696 | 62 |
1665481 | 1665481 | 2021-08-29 | Marion | Missouri | 29127 | 4696 | 58 |
1581039 | 1581039 | 2021-08-03 | Platte | Missouri | 29165 | 4696 | 53 |
1557727 | 1557727 | 2021-07-27 | Barren | Kentucky | 21009 | 4696 | 104 |
1539995 | 1539995 | 2021-07-21 | Kerr | Texas | 48265 | 4696 | 93 |
1536977 | 1536977 | 2021-07-20 | Henry | Virginia | 51089 | 4696 | 124 |
1442587 | 1442587 | 2021-06-21 | Howard | Texas | 48227 | 4696 | 101 |
1443093 | 1443093 | 2021-06-21 | Sweetwater | Wyoming | 56037 | 4696 | 40 |
1439342 | 1439342 | 2021-06-20 | Howard | Texas | 48227 | 4696 | 101 |
1420083 | 1420083 | 2021-06-14 | Culpeper | Virginia | 51047 | 4696 | 67 |
1416150 | 1416150 | 2021-06-13 | Bedford | Pennsylvania | 42009 | 4696 | 140 |
1416838 | 1416838 | 2021-06-13 | Culpeper | Virginia | 51047 | 4696 | 67 |
1407102 | 1407102 | 2021-06-10 | Culpeper | Virginia | 51047 | 4696 | 66 |
1371636 | 1371636 | 2021-05-30 | Marinette | Wisconsin | 55075 | 4696 | 70 |
1368390 | 1368390 | 2021-05-29 | Marinette | Wisconsin | 55075 | 4696 | 70 |
1365144 | 1365144 | 2021-05-28 | Marinette | Wisconsin | 55075 | 4696 | 70 |
1356838 | 1356838 | 2021-05-26 | Mower | Minnesota | 27099 | 4696 | 33 |
1352164 | 1352164 | 2021-05-24 | Monroe | Wisconsin | 55081 | 4696 | 39 |
1345442 | 1345442 | 2021-05-22 | Fauquier | Virginia | 51061 | 4696 | 70 |
1333791 | 1333791 | 2021-05-19 | Jessamine | Kentucky | 21113 | 4696 | 64 |
1334714 | 1334714 | 2021-05-19 | Richmond | North Carolina | 37153 | 4696 | 94 |
1322146 | 1322146 | 2021-05-15 | Toa Alta | Puerto Rico | 72135 | 4696 | |
1257982 | 1257982 | 2021-04-25 | Douglas | Wisconsin | 55031 | 4696 | 50 |
1201672 | 1201672 | 2021-04-08 | Auglaize | Ohio | 39011 | 4696 | 84 |
1192585 | 1192585 | 2021-04-05 | Harrison | Texas | 48203 | 4696 | 105 |
1189336 | 1189336 | 2021-04-04 | Harrison | Texas | 48203 | 4696 | 105 |
1180679 | 1180679 | 2021-04-02 | Bingham | Idaho | 16011 | 4696 | 69 |
1172296 | 1172296 | 2021-03-30 | Carteret | North Carolina | 37031 | 4696 | 45 |
1157203 | 1157203 | 2021-03-25 | Cowlitz | Washington | 53015 | 4696 | 75 |
1145667 | 1145667 | 2021-03-22 | Grand Traverse | Michigan | 26055 | 4696 | 75 |
1141387 | 1141387 | 2021-03-21 | Tehama | California | 6103 | 4696 | 33 |
1132149 | 1132149 | 2021-03-18 | Jackson | Indiana | 18071 | 4696 | 68 |
1125455 | 1125455 | 2021-03-16 | Ware | Georgia | 13299 | 4696 | 156 |
1111910 | 1111910 | 2021-03-11 | Campbell | Wyoming | 56005 | 4696 | 59 |
1091423 | 1091423 | 2021-03-05 | Stephens | Oklahoma | 40137 | 4696 | 68 |
1076751 | 1076751 | 2021-03-01 | Tift | Georgia | 13277 | 4696 | 120 |
1076115 | 1076115 | 2021-02-28 | Raleigh | West Virginia | 54081 | 4696 | 58 |
1063015 | 1063015 | 2021-02-24 | Pittsylvania | Virginia | 51143 | 4696 | 60 |
1045897 | 1045897 | 2021-02-19 | Sandusky | Ohio | 39143 | 4696 | 92 |
1030925 | 1030925 | 2021-02-15 | Hot Spring | Arkansas | 5059 | 4696 | 68 |
1033060 | 1033060 | 2021-02-15 | Carbon | Pennsylvania | 42025 | 4696 | 139 |
1012861 | 1012861 | 2021-02-09 | Joplin | Missouri | 4696 | 99 | |
970934 | 970934 | 2021-01-27 | Curry | New Mexico | 35009 | 4696 | 60 |
960676 | 960676 | 2021-01-24 | Marquette | Michigan | 26103 | 4696 | 54 |
957430 | 957430 | 2021-01-23 | Marquette | Michigan | 26103 | 4696 | 54 |
935206 | 935206 | 2021-01-16 | Strafford | New Hampshire | 33017 | 4696 | 46 |
914313 | 914313 | 2021-01-10 | Monroe | Florida | 12087 | 4696 | 36 |
906245 | 906245 | 2021-01-07 | Morton | North Dakota | 38059 | 4696 | 91 |
902953 | 902953 | 2021-01-06 | Stanly | North Carolina | 37167 | 4696 | 78 |
894574 | 894574 | 2021-01-04 | Gila | Arizona | 4007 | 4696 | 136 |
897330 | 897330 | 2021-01-04 | Val Verde | Texas | 48465 | 4696 | 153 |
894084 | 894084 | 2021-01-03 | Val Verde | Texas | 48465 | 4696 | 153 |
890838 | 890838 | 2021-01-02 | Val Verde | Texas | 48465 | 4696 | 153 |
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);