ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 2865 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 15
- Texas 15
- Iowa 14
- Mississippi 12
- Missouri 9
- Virginia 8
- Minnesota 7
- North Carolina 7
- Utah 7
- New Mexico 6
- Pennsylvania 6
- Tennessee 6
- Georgia 5
- Kansas 5
- Puerto Rico 5
- South Carolina 5
- Alabama 4
- Kentucky 4
- New Hampshire 4
- Ohio 4
- West Virginia 4
- Arkansas 3
- Louisiana 3
- Nebraska 3
- New York 3
- Colorado 2
- Florida 2
- Illinois 2
- Indiana 2
- Michigan 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501025 | 2501025 | 2022-05-13 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2497767 | 2497767 | 2022-05-12 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2494509 | 2494509 | 2022-05-11 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2491251 | 2491251 | 2022-05-10 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2492201 | 2492201 | 2022-05-10 | Sabana Grande | Puerto Rico | 72121 | 2865 | |
2487994 | 2487994 | 2022-05-09 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2488377 | 2488377 | 2022-05-09 | Los Alamos | New Mexico | 35028 | 2865 | 16 |
2488943 | 2488943 | 2022-05-09 | Sabana Grande | Puerto Rico | 72121 | 2865 | |
2456639 | 2456639 | 2022-04-29 | Camp | Texas | 48063 | 2865 | 74 |
2453383 | 2453383 | 2022-04-28 | Camp | Texas | 48063 | 2865 | 74 |
2424077 | 2424077 | 2022-04-19 | Callahan | Texas | 48059 | 2865 | 72 |
2420821 | 2420821 | 2022-04-18 | Callahan | Texas | 48059 | 2865 | 72 |
2353384 | 2353384 | 2022-03-29 | Unknown | Connecticut | 2865 | 10 | |
2290909 | 2290909 | 2022-03-09 | Morgan | Utah | 49029 | 2865 | 13 |
2284826 | 2284826 | 2022-03-08 | Wilcox | Alabama | 1131 | 2865 | 43 |
2287657 | 2287657 | 2022-03-08 | Morgan | Utah | 49029 | 2865 | 13 |
2266312 | 2266312 | 2022-03-02 | Lee | Kentucky | 21129 | 2865 | 46 |
2238879 | 2238879 | 2022-02-21 | Juab | Utah | 49023 | 2865 | 22 |
2235628 | 2235628 | 2022-02-20 | Juab | Utah | 49023 | 2865 | 22 |
2232377 | 2232377 | 2022-02-19 | Juab | Utah | 49023 | 2865 | 22 |
2229126 | 2229126 | 2022-02-18 | Juab | Utah | 49023 | 2865 | 22 |
2221249 | 2221249 | 2022-02-16 | Cedar | Missouri | 29039 | 2865 | 44 |
2182276 | 2182276 | 2022-02-04 | Pemiscot | Missouri | 29155 | 2865 | 63 |
2151848 | 2151848 | 2022-01-26 | Dade | Georgia | 13083 | 2865 | 28 |
2123979 | 2123979 | 2022-01-17 | Socorro | New Mexico | 35053 | 2865 | 71 |
2120727 | 2120727 | 2022-01-16 | Socorro | New Mexico | 35053 | 2865 | 71 |
2117475 | 2117475 | 2022-01-15 | Socorro | New Mexico | 35053 | 2865 | 71 |
2114224 | 2114224 | 2022-01-14 | Socorro | New Mexico | 35053 | 2865 | 71 |
2058503 | 2058503 | 2021-12-28 | Renville | Minnesota | 27129 | 2865 | 52 |
2051514 | 2051514 | 2021-12-26 | Bourbon | Kansas | 20011 | 2865 | 44 |
2052226 | 2052226 | 2021-12-26 | Wright | Missouri | 29229 | 2865 | 66 |
2052404 | 2052404 | 2021-12-26 | Unknown | New Hampshire | 2865 | 18 | |
2053567 | 2053567 | 2021-12-26 | Colonial Heights city | Virginia | 51570 | 2865 | 71 |
2048264 | 2048264 | 2021-12-25 | Bourbon | Kansas | 20011 | 2865 | 44 |
2048976 | 2048976 | 2021-12-25 | Wright | Missouri | 29229 | 2865 | 66 |
2049154 | 2049154 | 2021-12-25 | Unknown | New Hampshire | 2865 | 18 | |
2050317 | 2050317 | 2021-12-25 | Colonial Heights city | Virginia | 51570 | 2865 | 71 |
2045014 | 2045014 | 2021-12-24 | Bourbon | Kansas | 20011 | 2865 | 44 |
2045726 | 2045726 | 2021-12-24 | Wright | Missouri | 29229 | 2865 | 66 |
2045904 | 2045904 | 2021-12-24 | Unknown | New Hampshire | 2865 | 18 | |
2047067 | 2047067 | 2021-12-24 | Colonial Heights city | Virginia | 51570 | 2865 | 71 |
2041765 | 2041765 | 2021-12-23 | Bourbon | Kansas | 20011 | 2865 | 44 |
2042476 | 2042476 | 2021-12-23 | Wright | Missouri | 29229 | 2865 | 66 |
2042654 | 2042654 | 2021-12-23 | Unknown | New Hampshire | 2865 | 18 | |
2038515 | 2038515 | 2021-12-22 | Bourbon | Kansas | 20011 | 2865 | 44 |
1998726 | 1998726 | 2021-12-10 | Clay | Arkansas | 5021 | 2865 | 77 |
1995750 | 1995750 | 2021-12-09 | Banks | Georgia | 13011 | 2865 | 68 |
1906350 | 1906350 | 2021-11-11 | Yancey | North Carolina | 37199 | 2865 | 32 |
1903101 | 1903101 | 2021-11-10 | Yancey | North Carolina | 37199 | 2865 | 32 |
1898481 | 1898481 | 2021-11-09 | Hancock | Illinois | 17067 | 2865 | 45 |
1898663 | 1898663 | 2021-11-09 | Clay | Iowa | 19041 | 2865 | 35 |
1899606 | 1899606 | 2021-11-09 | Washington | Nebraska | 31177 | 2865 | 29 |
1895413 | 1895413 | 2021-11-08 | Clay | Iowa | 19041 | 2865 | 35 |
1892163 | 1892163 | 2021-11-07 | Clay | Iowa | 19041 | 2865 | 35 |
1893297 | 1893297 | 2021-11-07 | Hertford | North Carolina | 37091 | 2865 | 72 |
1888913 | 1888913 | 2021-11-06 | Clay | Iowa | 19041 | 2865 | 35 |
1890047 | 1890047 | 2021-11-06 | Hertford | North Carolina | 37091 | 2865 | 72 |
1885663 | 1885663 | 2021-11-05 | Clay | Iowa | 19041 | 2865 | 35 |
1886797 | 1886797 | 2021-11-05 | Hertford | North Carolina | 37091 | 2865 | 72 |
1882414 | 1882414 | 2021-11-04 | Clay | Iowa | 19041 | 2865 | 35 |
1879029 | 1879029 | 2021-11-03 | Richland | Illinois | 17159 | 2865 | 66 |
1879165 | 1879165 | 2021-11-03 | Clay | Iowa | 19041 | 2865 | 35 |
1881266 | 1881266 | 2021-11-03 | Orleans | Vermont | 50019 | 2865 | 16 |
1874678 | 1874678 | 2021-11-01 | San Jacinto | Texas | 48407 | 2865 | 79 |
1871429 | 1871429 | 2021-10-31 | San Jacinto | Texas | 48407 | 2865 | 79 |
1867476 | 1867476 | 2021-10-30 | Paulding | Ohio | 39125 | 2865 | 47 |
1868180 | 1868180 | 2021-10-30 | San Jacinto | Texas | 48407 | 2865 | 79 |
1856694 | 1856694 | 2021-10-27 | Morgan | Kentucky | 21175 | 2865 | 9 |
1839233 | 1839233 | 2021-10-21 | McDowell | West Virginia | 54047 | 2865 | 47 |
1835120 | 1835120 | 2021-10-20 | Wasco | Oregon | 41065 | 2865 | 40 |
1827768 | 1827768 | 2021-10-18 | Wabasha | Minnesota | 27157 | 2865 | 5 |
1809782 | 1809782 | 2021-10-12 | Franklin | Vermont | 50011 | 2865 | 46 |
1786292 | 1786292 | 2021-10-05 | Craig | Oklahoma | 40035 | 2865 | 29 |
1783043 | 1783043 | 2021-10-04 | Craig | Oklahoma | 40035 | 2865 | 29 |
1779794 | 1779794 | 2021-10-03 | Craig | Oklahoma | 40035 | 2865 | 29 |
1776544 | 1776544 | 2021-10-02 | Craig | Oklahoma | 40035 | 2865 | 29 |
1773294 | 1773294 | 2021-10-01 | Craig | Oklahoma | 40035 | 2865 | 29 |
1770044 | 1770044 | 2021-09-30 | Craig | Oklahoma | 40035 | 2865 | 29 |
1766795 | 1766795 | 2021-09-29 | Craig | Oklahoma | 40035 | 2865 | 29 |
1715049 | 1715049 | 2021-09-13 | Vega Alta | Puerto Rico | 72143 | 2865 | |
1696304 | 1696304 | 2021-09-07 | Upshur | West Virginia | 54097 | 2865 | 42 |
1690033 | 1690033 | 2021-09-06 | Conway | Arkansas | 5029 | 2865 | 41 |
1676201 | 1676201 | 2021-09-01 | Chester | Tennessee | 47023 | 2865 | 55 |
1654111 | 1654111 | 2021-08-25 | Kewaunee | Wisconsin | 55061 | 2865 | 37 |
1605331 | 1605331 | 2021-08-10 | Mingo | West Virginia | 54059 | 2865 | 45 |
1585421 | 1585421 | 2021-08-04 | Gonzales | Texas | 48177 | 2865 | 59 |
1559420 | 1559420 | 2021-07-27 | Fayette | Texas | 48149 | 2865 | 69 |
1559702 | 1559702 | 2021-07-27 | Halifax | Virginia | 51083 | 2865 | 78 |
1554904 | 1554904 | 2021-07-26 | Covington | Mississippi | 28031 | 2865 | 83 |
1556587 | 1556587 | 2021-07-26 | Hancock | West Virginia | 54029 | 2865 | 90 |
1519253 | 1519253 | 2021-07-15 | Audrain | Missouri | 29007 | 2865 | 58 |
1513482 | 1513482 | 2021-07-13 | Unknown | Oklahoma | 2865 | 0 | |
1497113 | 1497113 | 2021-07-08 | Fayette | Ohio | 39047 | 2865 | 50 |
1470460 | 1470460 | 2021-06-30 | Todd | Minnesota | 27153 | 2865 | 33 |
1467215 | 1467215 | 2021-06-29 | Todd | Minnesota | 27153 | 2865 | 33 |
1447678 | 1447678 | 2021-06-23 | Cass | Minnesota | 27021 | 2865 | 32 |
1422920 | 1422920 | 2021-06-15 | DeKalb | Tennessee | 47041 | 2865 | 56 |
1418283 | 1418283 | 2021-06-14 | Morehouse | Louisiana | 22067 | 2865 | 78 |
1397336 | 1397336 | 2021-06-07 | Accomack | Virginia | 51001 | 2865 | 43 |
1393450 | 1393450 | 2021-06-06 | Elk | Pennsylvania | 42047 | 2865 | 40 |
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);