ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 3273 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 21
- Texas 17
- Louisiana 11
- Ohio 10
- Tennessee 9
- Virginia 9
- Iowa 8
- Kentucky 8
- Michigan 8
- Illinois 7
- Indiana 5
- North Dakota 5
- Wisconsin 5
- Wyoming 5
- Alabama 4
- Florida 4
- Georgia 4
- Minnesota 4
- Oklahoma 4
- South Carolina 4
- Alaska 3
- Kansas 3
- Missouri 3
- Montana 3
- Nevada 3
- New York 3
- North Carolina 3
- Puerto Rico 3
- Maine 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495438 | 2495438 | 2022-05-11 | Lajas | Puerto Rico | 72079 | 3273 | |
2447249 | 2447249 | 2022-04-26 | Rockbridge | Virginia | 51163 | 3273 | 80 |
2424823 | 2424823 | 2022-04-20 | Little River | Arkansas | 5081 | 3273 | 104 |
2421567 | 2421567 | 2022-04-19 | Little River | Arkansas | 5081 | 3273 | 104 |
2418311 | 2418311 | 2022-04-18 | Little River | Arkansas | 5081 | 3273 | 104 |
2415055 | 2415055 | 2022-04-17 | Little River | Arkansas | 5081 | 3273 | 104 |
2411799 | 2411799 | 2022-04-16 | Little River | Arkansas | 5081 | 3273 | 104 |
2408543 | 2408543 | 2022-04-15 | Little River | Arkansas | 5081 | 3273 | 104 |
2405287 | 2405287 | 2022-04-14 | Little River | Arkansas | 5081 | 3273 | 104 |
2402032 | 2402032 | 2022-04-13 | Little River | Arkansas | 5081 | 3273 | 104 |
2404227 | 2404227 | 2022-04-13 | Barceloneta | Puerto Rico | 72017 | 3273 | |
2398777 | 2398777 | 2022-04-12 | Little River | Arkansas | 5081 | 3273 | 103 |
2395522 | 2395522 | 2022-04-11 | Little River | Arkansas | 5081 | 3273 | 102 |
2392266 | 2392266 | 2022-04-10 | Little River | Arkansas | 5081 | 3273 | 102 |
2389010 | 2389010 | 2022-04-09 | Little River | Arkansas | 5081 | 3273 | 102 |
2385755 | 2385755 | 2022-04-08 | Little River | Arkansas | 5081 | 3273 | 102 |
2375748 | 2375748 | 2022-04-04 | Bayfield | Wisconsin | 55007 | 3273 | 40 |
2349722 | 2349722 | 2022-03-27 | Ashland | Wisconsin | 55003 | 3273 | 36 |
2346469 | 2346469 | 2022-03-26 | Ashland | Wisconsin | 55003 | 3273 | 36 |
2343216 | 2343216 | 2022-03-25 | Ashland | Wisconsin | 55003 | 3273 | 36 |
2308659 | 2308659 | 2022-03-15 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2305408 | 2305408 | 2022-03-14 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2302156 | 2302156 | 2022-03-13 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2298904 | 2298904 | 2022-03-12 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2295652 | 2295652 | 2022-03-11 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2292400 | 2292400 | 2022-03-10 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2289148 | 2289148 | 2022-03-09 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2285897 | 2285897 | 2022-03-08 | Claiborne | Louisiana | 22027 | 3273 | 73 |
2250804 | 2250804 | 2022-02-25 | Unknown | New Jersey | 3273 | 0 | |
2234641 | 2234641 | 2022-02-20 | Yates | New York | 36123 | 3273 | 39 |
2215286 | 2215286 | 2022-02-14 | Walsh | North Dakota | 38099 | 3273 | 34 |
2212035 | 2212035 | 2022-02-13 | Walsh | North Dakota | 38099 | 3273 | 34 |
2191569 | 2191569 | 2022-02-07 | Trigg | Kentucky | 21221 | 3273 | 37 |
2171964 | 2171964 | 2022-02-01 | Carroll | Kentucky | 21041 | 3273 | 39 |
2164512 | 2164512 | 2022-01-30 | Ketchikan Gateway Borough | Alaska | 2130 | 3273 | 15 |
2161257 | 2161257 | 2022-01-29 | Ketchikan Gateway Borough | Alaska | 2130 | 3273 | 15 |
2158001 | 2158001 | 2022-01-28 | Ketchikan Gateway Borough | Alaska | 2130 | 3273 | 15 |
2157607 | 2157607 | 2022-01-27 | Appomattox | Virginia | 51011 | 3273 | 42 |
2149724 | 2149724 | 2022-01-25 | Macon | Missouri | 29121 | 3273 | 40 |
2140005 | 2140005 | 2022-01-22 | Ste. Genevieve | Missouri | 29186 | 3273 | 35 |
2128087 | 2128087 | 2022-01-18 | Falls | Texas | 48145 | 3273 | 54 |
2120929 | 2120929 | 2022-01-16 | Richland | North Dakota | 38077 | 3273 | 21 |
2102003 | 2102003 | 2022-01-10 | Andrews | Texas | 48003 | 3273 | 67 |
2098891 | 2098891 | 2022-01-09 | Lamb | Texas | 48279 | 3273 | 99 |
2087951 | 2087951 | 2022-01-06 | Pike | Missouri | 29163 | 3273 | 54 |
2079995 | 2079995 | 2022-01-04 | Cross | Arkansas | 5037 | 3273 | 72 |
2077655 | 2077655 | 2022-01-03 | Garrard | Kentucky | 21079 | 3273 | 60 |
2062475 | 2062475 | 2021-12-29 | Meigs | Ohio | 39105 | 3273 | 67 |
2037790 | 2037790 | 2021-12-22 | Sharp | Arkansas | 5135 | 3273 | 76 |
2028486 | 2028486 | 2021-12-19 | Edgar | Illinois | 17045 | 3273 | 71 |
2025235 | 2025235 | 2021-12-18 | Edgar | Illinois | 17045 | 3273 | 71 |
2021984 | 2021984 | 2021-12-17 | Edgar | Illinois | 17045 | 3273 | 71 |
2020724 | 2020724 | 2021-12-16 | Trousdale | Tennessee | 47169 | 3273 | 28 |
2012717 | 2012717 | 2021-12-14 | Spencer | Kentucky | 21215 | 3273 | 41 |
2012866 | 2012866 | 2021-12-14 | Charlevoix | Michigan | 26029 | 3273 | 47 |
2008521 | 2008521 | 2021-12-13 | Phillips | Arkansas | 5107 | 3273 | 78 |
1988723 | 1988723 | 2021-12-06 | Lincoln | West Virginia | 54043 | 3273 | 53 |
1973739 | 1973739 | 2021-12-02 | Concordia | Louisiana | 22029 | 3273 | 79 |
1969478 | 1969478 | 2021-12-01 | Conway | Arkansas | 5029 | 3273 | 46 |
1940602 | 1940602 | 2021-11-22 | Putnam | Georgia | 13237 | 3273 | 84 |
1928196 | 1928196 | 2021-11-18 | Rockcastle | Kentucky | 21203 | 3273 | 34 |
1888149 | 1888149 | 2021-11-06 | Pickens | Alabama | 1107 | 3273 | 85 |
1882376 | 1882376 | 2021-11-04 | Starke | Indiana | 18149 | 3273 | 74 |
1884595 | 1884595 | 2021-11-04 | Louisa | Virginia | 51109 | 3273 | 48 |
1877358 | 1877358 | 2021-11-02 | Union | Oregon | 41061 | 3273 | 50 |
1847266 | 1847266 | 2021-10-24 | Waseca | Minnesota | 27161 | 3273 | 31 |
1844016 | 1844016 | 2021-10-23 | Waseca | Minnesota | 27161 | 3273 | 31 |
1840766 | 1840766 | 2021-10-22 | Waseca | Minnesota | 27161 | 3273 | 31 |
1837406 | 1837406 | 2021-10-21 | Menominee | Michigan | 26109 | 3273 | 50 |
1833481 | 1833481 | 2021-10-20 | Douglas | Illinois | 17041 | 3273 | 43 |
1834157 | 1834157 | 2021-10-20 | Menominee | Michigan | 26109 | 3273 | 50 |
1827142 | 1827142 | 2021-10-18 | Sullivan | Indiana | 18153 | 3273 | 54 |
1793666 | 1793666 | 2021-10-07 | Staunton city | Virginia | 51790 | 3273 | 79 |
1782294 | 1782294 | 2021-10-04 | Attala | Mississippi | 28007 | 3273 | 88 |
1782734 | 1782734 | 2021-10-04 | Delaware | New York | 36025 | 3273 | 41 |
1760870 | 1760870 | 2021-09-27 | Hutchinson | Texas | 48233 | 3273 | 81 |
1757622 | 1757622 | 2021-09-26 | Hutchinson | Texas | 48233 | 3273 | 81 |
1754374 | 1754374 | 2021-09-25 | Hutchinson | Texas | 48233 | 3273 | 81 |
1748509 | 1748509 | 2021-09-24 | Columbia | Arkansas | 5027 | 3273 | 65 |
1749584 | 1749584 | 2021-09-24 | Somerset | Maine | 23025 | 3273 | 40 |
1747231 | 1747231 | 2021-09-23 | Henry | Ohio | 39069 | 3273 | 68 |
1747234 | 1747234 | 2021-09-23 | Holmes | Ohio | 39075 | 3273 | 108 |
1748131 | 1748131 | 2021-09-23 | Lee | Virginia | 51105 | 3273 | 51 |
1740041 | 1740041 | 2021-09-21 | Todd | Minnesota | 27153 | 3273 | 34 |
1738183 | 1738183 | 2021-09-20 | Moore | Texas | 48341 | 3273 | 79 |
1733403 | 1733403 | 2021-09-19 | Dickinson | Michigan | 26043 | 3273 | 75 |
1734848 | 1734848 | 2021-09-19 | Gillespie | Texas | 48171 | 3273 | 68 |
1734933 | 1734933 | 2021-09-19 | Moore | Texas | 48341 | 3273 | 79 |
1730153 | 1730153 | 2021-09-18 | Dickinson | Michigan | 26043 | 3273 | 75 |
1731598 | 1731598 | 2021-09-18 | Gillespie | Texas | 48171 | 3273 | 68 |
1731683 | 1731683 | 2021-09-18 | Moore | Texas | 48341 | 3273 | 79 |
1726903 | 1726903 | 2021-09-17 | Dickinson | Michigan | 26043 | 3273 | 75 |
1728348 | 1728348 | 2021-09-17 | Gillespie | Texas | 48171 | 3273 | 68 |
1725099 | 1725099 | 2021-09-16 | Gillespie | Texas | 48171 | 3273 | 66 |
1716003 | 1716003 | 2021-09-14 | Arkansas | Arkansas | 5001 | 3273 | 55 |
1718180 | 1718180 | 2021-09-14 | Elk | Pennsylvania | 42047 | 3273 | 44 |
1704998 | 1704998 | 2021-09-10 | Hardin | Ohio | 39065 | 3273 | 66 |
1696989 | 1696989 | 2021-09-08 | Jerome | Idaho | 16053 | 3273 | 31 |
1693997 | 1693997 | 2021-09-07 | Henry | Iowa | 19087 | 3273 | 39 |
1690748 | 1690748 | 2021-09-06 | Henry | Iowa | 19087 | 3273 | 39 |
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);