ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
275 rows where cases = 1952 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 27
- Virginia 23
- Georgia 20
- Missouri 18
- Iowa 16
- Texas 15
- Wisconsin 15
- Illinois 14
- Arkansas 12
- Puerto Rico 10
- Tennessee 10
- Florida 9
- South Dakota 8
- Alabama 7
- Kansas 6
- Ohio 6
- Pennsylvania 6
- Louisiana 5
- Mississippi 5
- Idaho 4
- Maine 4
- North Carolina 4
- North Dakota 4
- West Virginia 4
- Minnesota 3
- Indiana 2
- Michigan 2
- Nebraska 2
- New York 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2379779 | 2379779 | 2022-04-06 | Schuyler | Illinois | 17169 | 1952 | 29 |
2376525 | 2376525 | 2022-04-05 | Schuyler | Illinois | 17169 | 1952 | 29 |
2373273 | 2373273 | 2022-04-04 | Schuyler | Illinois | 17169 | 1952 | 29 |
2333266 | 2333266 | 2022-03-22 | Falls Church city | Virginia | 51610 | 1952 | 16 |
2330013 | 2330013 | 2022-03-21 | Falls Church city | Virginia | 51610 | 1952 | 16 |
2291434 | 2291434 | 2022-03-10 | Prairie | Arkansas | 5117 | 1952 | 41 |
2288182 | 2288182 | 2022-03-09 | Prairie | Arkansas | 5117 | 1952 | 41 |
2290981 | 2290981 | 2022-03-09 | Fairfax city | Virginia | 51600 | 1952 | 43 |
2287729 | 2287729 | 2022-03-08 | Fairfax city | Virginia | 51600 | 1952 | 43 |
2251380 | 2251380 | 2022-02-25 | Patillas | Puerto Rico | 72109 | 1952 | |
2248129 | 2248129 | 2022-02-24 | Patillas | Puerto Rico | 72109 | 1952 | |
2248707 | 2248707 | 2022-02-24 | Fairfax city | Virginia | 51600 | 1952 | 42 |
2244878 | 2244878 | 2022-02-23 | Patillas | Puerto Rico | 72109 | 1952 | |
2245456 | 2245456 | 2022-02-23 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2240929 | 2240929 | 2022-02-22 | Custer | Nebraska | 31041 | 1952 | 28 |
2241627 | 2241627 | 2022-02-22 | Patillas | Puerto Rico | 72109 | 1952 | |
2242205 | 2242205 | 2022-02-22 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2238376 | 2238376 | 2022-02-21 | Patillas | Puerto Rico | 72109 | 1952 | |
2238954 | 2238954 | 2022-02-21 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2228957 | 2228957 | 2022-02-18 | Hamilton | Texas | 48193 | 1952 | 30 |
2225706 | 2225706 | 2022-02-17 | Hamilton | Texas | 48193 | 1952 | 30 |
2210501 | 2210501 | 2022-02-13 | Taylor | Georgia | 13269 | 1952 | 49 |
2207248 | 2207248 | 2022-02-12 | Taylor | Georgia | 13269 | 1952 | 49 |
2203995 | 2203995 | 2022-02-11 | Taylor | Georgia | 13269 | 1952 | 49 |
2204034 | 2204034 | 2022-02-11 | Benewah | Idaho | 16009 | 1952 | 35 |
2200766 | 2200766 | 2022-02-10 | Wilcox | Georgia | 13315 | 1952 | 63 |
2202584 | 2202584 | 2022-02-10 | Guayanilla | Puerto Rico | 72059 | 1952 | |
2194204 | 2194204 | 2022-02-08 | Montgomery | Georgia | 13209 | 1952 | 47 |
2173313 | 2173313 | 2022-02-01 | Jayuya | Puerto Rico | 72073 | 1952 | |
2169287 | 2169287 | 2022-01-31 | St. Clair | Missouri | 29185 | 1952 | 29 |
2170061 | 2170061 | 2022-01-31 | Jayuya | Puerto Rico | 72073 | 1952 | |
2155062 | 2155062 | 2022-01-27 | Atkinson | Georgia | 13003 | 1952 | 39 |
2146448 | 2146448 | 2022-01-24 | Gentry | Missouri | 29075 | 1952 | 28 |
2134847 | 2134847 | 2022-01-20 | Charlotte | Virginia | 51037 | 1952 | 32 |
2129191 | 2129191 | 2022-01-19 | Wilkinson | Georgia | 13319 | 1952 | 49 |
2086434 | 2086434 | 2022-01-06 | Wilcox | Alabama | 1131 | 1952 | 38 |
2074894 | 2074894 | 2022-01-02 | Douglas | Missouri | 29067 | 1952 | 66 |
2071643 | 2071643 | 2022-01-01 | Douglas | Missouri | 29067 | 1952 | 66 |
2068392 | 2068392 | 2021-12-31 | Douglas | Missouri | 29067 | 1952 | 66 |
2065141 | 2065141 | 2021-12-30 | Douglas | Missouri | 29067 | 1952 | 66 |
2057822 | 2057822 | 2021-12-28 | Brown | Indiana | 18013 | 1952 | 51 |
2035197 | 2035197 | 2021-12-21 | Grundy | Iowa | 19075 | 1952 | 37 |
2031947 | 2031947 | 2021-12-20 | Grundy | Iowa | 19075 | 1952 | 37 |
2028696 | 2028696 | 2021-12-19 | Grundy | Iowa | 19075 | 1952 | 37 |
2028765 | 2028765 | 2021-12-19 | Brown | Kansas | 20013 | 1952 | 41 |
2025445 | 2025445 | 2021-12-18 | Grundy | Iowa | 19075 | 1952 | 37 |
2025514 | 2025514 | 2021-12-18 | Brown | Kansas | 20013 | 1952 | 41 |
2022194 | 2022194 | 2021-12-17 | Grundy | Iowa | 19075 | 1952 | 37 |
2022263 | 2022263 | 2021-12-17 | Brown | Kansas | 20013 | 1952 | 41 |
2018943 | 2018943 | 2021-12-16 | Grundy | Iowa | 19075 | 1952 | 37 |
2015693 | 2015693 | 2021-12-15 | Grundy | Iowa | 19075 | 1952 | 37 |
2013165 | 2013165 | 2021-12-14 | Linn | Missouri | 29115 | 1952 | 58 |
2014694 | 2014694 | 2021-12-14 | Pacific | Washington | 53049 | 1952 | 38 |
2006623 | 2006623 | 2021-12-12 | Cedar | Missouri | 29039 | 1952 | 42 |
1998740 | 1998740 | 2021-12-10 | Fulton | Arkansas | 5049 | 1952 | 70 |
1986268 | 1986268 | 2021-12-06 | Menard | Illinois | 17129 | 1952 | 19 |
1929347 | 1929347 | 2021-11-18 | Morrow | Oregon | 41049 | 1952 | 24 |
1906352 | 1906352 | 2021-11-11 | Barnes | North Dakota | 38003 | 1952 | 35 |
1906817 | 1906817 | 2021-11-11 | Butte | South Dakota | 46019 | 1952 | 33 |
1903568 | 1903568 | 2021-11-10 | Butte | South Dakota | 46019 | 1952 | 33 |
1903959 | 1903959 | 2021-11-10 | Ward | Texas | 48475 | 1952 | 32 |
1898738 | 1898738 | 2021-11-09 | Winnebago | Iowa | 19189 | 1952 | 34 |
1900709 | 1900709 | 2021-11-09 | Ward | Texas | 48475 | 1952 | 32 |
1895488 | 1895488 | 2021-11-08 | Winnebago | Iowa | 19189 | 1952 | 34 |
1897459 | 1897459 | 2021-11-08 | Ward | Texas | 48475 | 1952 | 31 |
1892238 | 1892238 | 2021-11-07 | Winnebago | Iowa | 19189 | 1952 | 34 |
1888988 | 1888988 | 2021-11-06 | Winnebago | Iowa | 19189 | 1952 | 34 |
1885738 | 1885738 | 2021-11-05 | Winnebago | Iowa | 19189 | 1952 | 34 |
1882489 | 1882489 | 2021-11-04 | Winnebago | Iowa | 19189 | 1952 | 34 |
1882675 | 1882675 | 2021-11-04 | Martin | Kentucky | 21159 | 1952 | 35 |
1879240 | 1879240 | 2021-11-03 | Winnebago | Iowa | 19189 | 1952 | 34 |
1876301 | 1876301 | 2021-11-02 | Washington | Maine | 23029 | 1952 | 20 |
1864222 | 1864222 | 2021-10-29 | Morgan | Ohio | 39115 | 1952 | 34 |
1860973 | 1860973 | 2021-10-28 | Morgan | Ohio | 39115 | 1952 | 34 |
1846454 | 1846454 | 2021-10-24 | Shoshone | Idaho | 16079 | 1952 | 59 |
1849016 | 1849016 | 2021-10-24 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1843204 | 1843204 | 2021-10-23 | Shoshone | Idaho | 16079 | 1952 | 59 |
1845766 | 1845766 | 2021-10-23 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1842516 | 1842516 | 2021-10-22 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1830954 | 1830954 | 2021-10-19 | Cottonwood | Minnesota | 27033 | 1952 | 28 |
1803499 | 1803499 | 2021-10-10 | Morgan | West Virginia | 54065 | 1952 | 39 |
1763954 | 1763954 | 2021-09-28 | Lake | Tennessee | 47095 | 1952 | 31 |
1756017 | 1756017 | 2021-09-26 | Claiborne | Louisiana | 22027 | 1952 | 61 |
1752769 | 1752769 | 2021-09-25 | Claiborne | Louisiana | 22027 | 1952 | 61 |
1749520 | 1749520 | 2021-09-24 | Claiborne | Louisiana | 22027 | 1952 | 61 |
1740669 | 1740669 | 2021-09-21 | McKenzie | North Dakota | 38053 | 1952 | 17 |
1729443 | 1729443 | 2021-09-18 | Kauai | Hawaii | 15007 | 1952 | 8 |
1690057 | 1690057 | 2021-09-06 | Lee | Arkansas | 5077 | 1952 | 40 |
1690973 | 1690973 | 2021-09-06 | Lawrence | Kentucky | 21127 | 1952 | 31 |
1687723 | 1687723 | 2021-09-05 | Lawrence | Kentucky | 21127 | 1952 | 31 |
1684473 | 1684473 | 2021-09-04 | Lawrence | Kentucky | 21127 | 1952 | 31 |
1681222 | 1681222 | 2021-09-03 | Lawrence | Kentucky | 21127 | 1952 | 31 |
1674718 | 1674718 | 2021-09-01 | Jackson | Kentucky | 21109 | 1952 | 39 |
1673405 | 1673405 | 2021-08-31 | King George | Virginia | 51099 | 1952 | 20 |
1659479 | 1659479 | 2021-08-27 | Walsh | North Dakota | 38099 | 1952 | 27 |
1654530 | 1654530 | 2021-08-26 | Jefferson | Florida | 12065 | 1952 | 28 |
1651283 | 1651283 | 2021-08-25 | Jefferson | Florida | 12065 | 1952 | 28 |
1648034 | 1648034 | 2021-08-24 | Jefferson | Florida | 12065 | 1952 | 28 |
1650891 | 1650891 | 2021-08-24 | Sawyer | Wisconsin | 55113 | 1952 | 29 |
1644786 | 1644786 | 2021-08-23 | Jefferson | Florida | 12065 | 1952 | 28 |
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);