ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 3215 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 15
- Georgia 14
- Arkansas 11
- Mississippi 10
- Iowa 8
- Missouri 8
- Texas 8
- Kentucky 7
- North Carolina 7
- Kansas 6
- Oregon 6
- Puerto Rico 6
- Alabama 5
- Illinois 5
- Louisiana 5
- South Carolina 5
- Wisconsin 5
- Idaho 4
- Minnesota 4
- Ohio 4
- Florida 3
- Indiana 3
- Michigan 3
- Nebraska 2
- New Mexico 2
- North Dakota 2
- Pennsylvania 2
- Tennessee 2
- West Virginia 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462724 | 2462724 | 2022-05-01 | Baker | Oregon | 41001 | 3215 | 48 |
2459468 | 2459468 | 2022-04-30 | Baker | Oregon | 41001 | 3215 | 48 |
2456212 | 2456212 | 2022-04-29 | Baker | Oregon | 41001 | 3215 | 48 |
2381440 | 2381440 | 2022-04-06 | Barceloneta | Puerto Rico | 72017 | 3215 | |
2376648 | 2376648 | 2022-04-05 | Butler | Iowa | 19023 | 3215 | 53 |
2373087 | 2373087 | 2022-04-04 | Oglethorpe | Georgia | 13221 | 3215 | 55 |
2373396 | 2373396 | 2022-04-04 | Butler | Iowa | 19023 | 3215 | 53 |
2370143 | 2370143 | 2022-04-03 | Butler | Iowa | 19023 | 3215 | 53 |
2370679 | 2370679 | 2022-04-03 | Cottonwood | Minnesota | 27033 | 3215 | 41 |
2366890 | 2366890 | 2022-04-02 | Butler | Iowa | 19023 | 3215 | 53 |
2367426 | 2367426 | 2022-04-02 | Cottonwood | Minnesota | 27033 | 3215 | 41 |
2363637 | 2363637 | 2022-04-01 | Butler | Iowa | 19023 | 3215 | 53 |
2364173 | 2364173 | 2022-04-01 | Cottonwood | Minnesota | 27033 | 3215 | 41 |
2360383 | 2360383 | 2022-03-31 | Butler | Iowa | 19023 | 3215 | 53 |
2357129 | 2357129 | 2022-03-30 | Butler | Iowa | 19023 | 3215 | 53 |
2308105 | 2308105 | 2022-03-15 | Gooding | Idaho | 16047 | 3215 | 54 |
2294303 | 2294303 | 2022-03-10 | Rockbridge | Virginia | 51163 | 3215 | 75 |
2290420 | 2290420 | 2022-03-09 | Utuado | Puerto Rico | 72141 | 3215 | |
2291051 | 2291051 | 2022-03-09 | Rockbridge | Virginia | 51163 | 3215 | 75 |
2287168 | 2287168 | 2022-03-08 | Utuado | Puerto Rico | 72141 | 3215 | |
2283916 | 2283916 | 2022-03-07 | Utuado | Puerto Rico | 72141 | 3215 | |
2281417 | 2281417 | 2022-03-06 | Bayfield | Wisconsin | 55007 | 3215 | 38 |
2278164 | 2278164 | 2022-03-05 | Bayfield | Wisconsin | 55007 | 3215 | 38 |
2274911 | 2274911 | 2022-03-04 | Bayfield | Wisconsin | 55007 | 3215 | 38 |
2266324 | 2266324 | 2022-03-02 | Martin | Kentucky | 21159 | 3215 | 45 |
2258239 | 2258239 | 2022-02-27 | Jackson | Texas | 48239 | 3215 | 58 |
2248897 | 2248897 | 2022-02-24 | Ashland | Wisconsin | 55003 | 3215 | 35 |
2244055 | 2244055 | 2022-02-23 | Mississippi | Missouri | 29133 | 3215 | 55 |
2244225 | 2244225 | 2022-02-23 | Otoe | Nebraska | 31131 | 3215 | 17 |
2245646 | 2245646 | 2022-02-23 | Ashland | Wisconsin | 55003 | 3215 | 34 |
2231606 | 2231606 | 2022-02-19 | Morgan | Ohio | 39115 | 3215 | 52 |
2231871 | 2231871 | 2022-02-19 | Naguabo | Puerto Rico | 72103 | 3215 | |
2211113 | 2211113 | 2022-02-13 | Claiborne | Louisiana | 22027 | 3215 | 71 |
2207860 | 2207860 | 2022-02-12 | Claiborne | Louisiana | 22027 | 3215 | 71 |
2204607 | 2204607 | 2022-02-11 | Claiborne | Louisiana | 22027 | 3215 | 71 |
2177217 | 2177217 | 2022-02-02 | Patrick | Virginia | 51141 | 3215 | 76 |
2172195 | 2172195 | 2022-02-01 | Benzie | Michigan | 26019 | 3215 | 60 |
2168942 | 2168942 | 2022-01-31 | Benzie | Michigan | 26019 | 3215 | 60 |
2099543 | 2099543 | 2022-01-10 | Polk | Arkansas | 5113 | 3215 | 129 |
2089192 | 2089192 | 2022-01-06 | Robertson | Texas | 48395 | 3215 | 68 |
2080269 | 2080269 | 2022-01-04 | Brantley | Georgia | 13025 | 3215 | 91 |
2053642 | 2053642 | 2021-12-26 | Radford city | Virginia | 51750 | 3215 | 38 |
2050392 | 2050392 | 2021-12-25 | Radford city | Virginia | 51750 | 3215 | 38 |
2047142 | 2047142 | 2021-12-24 | Radford city | Virginia | 51750 | 3215 | 38 |
2019604 | 2019604 | 2021-12-16 | Winston | Mississippi | 28159 | 3215 | 92 |
2005536 | 2005536 | 2021-12-12 | Crisp | Georgia | 13081 | 3215 | 117 |
2002285 | 2002285 | 2021-12-11 | Crisp | Georgia | 13081 | 3215 | 117 |
1999035 | 1999035 | 2021-12-10 | Crisp | Georgia | 13081 | 3215 | 117 |
1988885 | 1988885 | 2021-12-07 | Henry | Alabama | 1067 | 3215 | 66 |
1965974 | 1965974 | 2021-11-29 | Lincoln | West Virginia | 54043 | 3215 | 51 |
1936957 | 1936957 | 2021-11-21 | Ashley | Arkansas | 5003 | 3215 | 50 |
1937537 | 1937537 | 2021-11-21 | Union | Illinois | 17181 | 3215 | 53 |
1933707 | 1933707 | 2021-11-20 | Ashley | Arkansas | 5003 | 3215 | 50 |
1934287 | 1934287 | 2021-11-20 | Union | Illinois | 17181 | 3215 | 53 |
1931036 | 1931036 | 2021-11-19 | Union | Illinois | 17181 | 3215 | 53 |
1929707 | 1929707 | 2021-11-18 | Trousdale | Tennessee | 47169 | 3215 | 26 |
1917935 | 1917935 | 2021-11-15 | Minidoka | Idaho | 16067 | 3215 | 49 |
1919389 | 1919389 | 2021-11-15 | Rolette | North Dakota | 38079 | 3215 | 35 |
1910872 | 1910872 | 2021-11-13 | Fayette | Alabama | 1057 | 3215 | 85 |
1906417 | 1906417 | 2021-11-11 | Carroll | Ohio | 39019 | 3215 | 70 |
1859395 | 1859395 | 2021-10-28 | Washington | Georgia | 13303 | 3215 | 118 |
1852897 | 1852897 | 2021-10-26 | Washington | Georgia | 13303 | 3215 | 118 |
1854615 | 1854615 | 2021-10-26 | Union | Oregon | 41061 | 3215 | 50 |
1837100 | 1837100 | 2021-10-21 | Sumner | Kansas | 20191 | 3215 | 60 |
1833851 | 1833851 | 2021-10-20 | Sumner | Kansas | 20191 | 3215 | 60 |
1807016 | 1807016 | 2021-10-12 | Lawrence | Arkansas | 5075 | 3215 | 55 |
1794041 | 1794041 | 2021-10-08 | Randolph | Arkansas | 5121 | 3215 | 52 |
1793057 | 1793057 | 2021-10-07 | Fairfield | South Carolina | 45039 | 3215 | 94 |
1787428 | 1787428 | 2021-10-06 | Randolph | Alabama | 1111 | 3215 | 59 |
1781877 | 1781877 | 2021-10-04 | Adair | Kentucky | 21001 | 3215 | 73 |
1778627 | 1778627 | 2021-10-03 | Adair | Kentucky | 21001 | 3215 | 73 |
1779196 | 1779196 | 2021-10-03 | New Madrid | Missouri | 29143 | 3215 | 53 |
1775377 | 1775377 | 2021-10-02 | Adair | Kentucky | 21001 | 3215 | 73 |
1775946 | 1775946 | 2021-10-02 | New Madrid | Missouri | 29143 | 3215 | 53 |
1769786 | 1769786 | 2021-09-30 | Ashe | North Carolina | 37009 | 3215 | 46 |
1767680 | 1767680 | 2021-09-29 | Waynesboro city | Virginia | 51820 | 3215 | 41 |
1735078 | 1735078 | 2021-09-19 | Botetourt | Virginia | 51023 | 3215 | 39 |
1731828 | 1731828 | 2021-09-18 | Botetourt | Virginia | 51023 | 3215 | 39 |
1728578 | 1728578 | 2021-09-17 | Botetourt | Virginia | 51023 | 3215 | 39 |
1722513 | 1722513 | 2021-09-16 | Columbia | Arkansas | 5027 | 3215 | 65 |
1716355 | 1716355 | 2021-09-14 | Hart | Georgia | 13147 | 3215 | 61 |
1715328 | 1715328 | 2021-09-13 | Deaf Smith | Texas | 48117 | 3215 | 69 |
1712082 | 1712082 | 2021-09-12 | Deaf Smith | Texas | 48117 | 3215 | 69 |
1712345 | 1712345 | 2021-09-12 | Carroll | Virginia | 51035 | 3215 | 81 |
1708835 | 1708835 | 2021-09-11 | Deaf Smith | Texas | 48117 | 3215 | 68 |
1709098 | 1709098 | 2021-09-11 | Carroll | Virginia | 51035 | 3215 | 81 |
1705851 | 1705851 | 2021-09-10 | Carroll | Virginia | 51035 | 3215 | 81 |
1678077 | 1678077 | 2021-09-02 | St. James | Louisiana | 22093 | 3215 | 61 |
1676188 | 1676188 | 2021-09-01 | Yankton | South Dakota | 46135 | 3215 | 33 |
1676789 | 1676789 | 2021-09-01 | Mingo | West Virginia | 54059 | 3215 | 46 |
1631850 | 1631850 | 2021-08-19 | Chattooga | Georgia | 13055 | 3215 | 76 |
1621759 | 1621759 | 2021-08-16 | Winston | Alabama | 1133 | 3215 | 74 |
1614754 | 1614754 | 2021-08-13 | Palo Pinto | Texas | 48363 | 3215 | 79 |
1578109 | 1578109 | 2021-08-02 | Washington | New York | 36115 | 3215 | 55 |
1561398 | 1561398 | 2021-07-28 | Copiah | Mississippi | 28029 | 3215 | 68 |
1542946 | 1542946 | 2021-07-22 | Union | South Carolina | 45087 | 3215 | 82 |
1515921 | 1515921 | 2021-07-14 | Adams | Mississippi | 28001 | 3215 | 87 |
1486764 | 1486764 | 2021-07-05 | Scott | Mississippi | 28123 | 3215 | 74 |
1483518 | 1483518 | 2021-07-04 | Scott | Mississippi | 28123 | 3215 | 74 |
1480272 | 1480272 | 2021-07-03 | Scott | Mississippi | 28123 | 3215 | 74 |
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);