ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
306 rows where cases = 1805 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Texas 28
- Kansas 16
- Oklahoma 16
- Kentucky 15
- Montana 15
- Iowa 12
- Virginia 12
- Minnesota 11
- Florida 10
- Missouri 9
- Nebraska 9
- North Carolina 9
- Indiana 8
- Mississippi 8
- Tennessee 8
- Illinois 7
- West Virginia 7
- Arkansas 6
- Louisiana 6
- Oregon 6
- Puerto Rico 6
- South Carolina 5
- Alabama 4
- Colorado 4
- New York 4
- Ohio 4
- Pennsylvania 4
- California 3
- Michigan 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501942 | 2501942 | 2022-05-13 | Guanica | Puerto Rico | 72055 | 1805 | |
2417905 | 2417905 | 2022-04-17 | Lancaster | Virginia | 51103 | 1805 | 31 |
2414649 | 2414649 | 2022-04-16 | Lancaster | Virginia | 51103 | 1805 | 31 |
2411393 | 2411393 | 2022-04-15 | Lancaster | Virginia | 51103 | 1805 | 31 |
2380738 | 2380738 | 2022-04-06 | Madison | Montana | 30057 | 1805 | 20 |
2377483 | 2377483 | 2022-04-05 | Madison | Montana | 30057 | 1805 | 20 |
2374230 | 2374230 | 2022-04-04 | Madison | Montana | 30057 | 1805 | 20 |
2370978 | 2370978 | 2022-04-03 | Madison | Montana | 30057 | 1805 | 20 |
2367725 | 2367725 | 2022-04-02 | Madison | Montana | 30057 | 1805 | 20 |
2364472 | 2364472 | 2022-04-01 | Madison | Montana | 30057 | 1805 | 20 |
2333307 | 2333307 | 2022-03-22 | Middlesex | Virginia | 51119 | 1805 | 45 |
2330054 | 2330054 | 2022-03-21 | Middlesex | Virginia | 51119 | 1805 | 45 |
2325536 | 2325536 | 2022-03-20 | Richardson | Nebraska | 31147 | 1805 | 24 |
2322282 | 2322282 | 2022-03-19 | Richardson | Nebraska | 31147 | 1805 | 24 |
2309215 | 2309215 | 2022-03-15 | Cuming | Nebraska | 31039 | 1805 | 15 |
2305915 | 2305915 | 2022-03-14 | Madison | Montana | 30057 | 1805 | 20 |
2306017 | 2306017 | 2022-03-14 | Richardson | Nebraska | 31147 | 1805 | 24 |
2302766 | 2302766 | 2022-03-13 | Richardson | Nebraska | 31147 | 1805 | 24 |
2299514 | 2299514 | 2022-03-12 | Richardson | Nebraska | 31147 | 1805 | 24 |
2296262 | 2296262 | 2022-03-11 | Richardson | Nebraska | 31147 | 1805 | 24 |
2281099 | 2281099 | 2022-03-06 | Stephens | Texas | 48429 | 1805 | 45 |
2277846 | 2277846 | 2022-03-05 | Stephens | Texas | 48429 | 1805 | 45 |
2214322 | 2214322 | 2022-02-14 | Nicholas | Kentucky | 21181 | 1805 | 29 |
2194019 | 2194019 | 2022-02-08 | Yuma | Colorado | 8125 | 1805 | 22 |
2196392 | 2196392 | 2022-02-08 | Crosby | Texas | 48107 | 1805 | 44 |
2193138 | 2193138 | 2022-02-07 | Crosby | Texas | 48107 | 1805 | 44 |
2176990 | 2176990 | 2022-02-02 | Mitchell | Texas | 48335 | 1805 | 46 |
2169470 | 2169470 | 2022-01-31 | White Pine | Nevada | 32033 | 1805 | 18 |
2147616 | 2147616 | 2022-01-24 | Floyd | Texas | 48153 | 1805 | 42 |
2141518 | 2141518 | 2022-01-22 | Gilmer | West Virginia | 54021 | 1805 | 17 |
2137993 | 2137993 | 2022-01-21 | Swisher | Texas | 48437 | 1805 | 29 |
2138299 | 2138299 | 2022-01-21 | Tyler | West Virginia | 54095 | 1805 | 27 |
2133586 | 2133586 | 2022-01-20 | Custer | Nebraska | 31041 | 1805 | 26 |
2126022 | 2126022 | 2022-01-18 | Hamilton | Illinois | 17065 | 1805 | 29 |
2123762 | 2123762 | 2022-01-17 | Deer Lodge | Montana | 30023 | 1805 | 28 |
2120510 | 2120510 | 2022-01-16 | Deer Lodge | Montana | 30023 | 1805 | 28 |
2117258 | 2117258 | 2022-01-15 | Deer Lodge | Montana | 30023 | 1805 | 28 |
2118297 | 2118297 | 2022-01-15 | Clay | Texas | 48077 | 1805 | 26 |
2114007 | 2114007 | 2022-01-14 | Deer Lodge | Montana | 30023 | 1805 | 28 |
2115201 | 2115201 | 2022-01-14 | Red River | Texas | 48387 | 1805 | 58 |
2107536 | 2107536 | 2022-01-12 | Rosebud | Montana | 30087 | 1805 | 58 |
2086094 | 2086094 | 2022-01-05 | Galax city | Virginia | 51640 | 1805 | 69 |
2079411 | 2079411 | 2022-01-03 | Morris | Texas | 48343 | 1805 | 58 |
2034844 | 2034844 | 2021-12-21 | Long | Georgia | 13183 | 1805 | 29 |
2019512 | 2019512 | 2021-12-16 | Swift | Minnesota | 27151 | 1805 | 28 |
2015151 | 2015151 | 2021-12-15 | Park | Colorado | 8093 | 1805 | 13 |
2009751 | 2009751 | 2021-12-13 | Rock | Minnesota | 27133 | 1805 | 31 |
2007399 | 2007399 | 2021-12-12 | Forest | Pennsylvania | 42053 | 1805 | 30 |
1989680 | 1989680 | 2021-12-07 | Emmet | Iowa | 19063 | 1805 | 46 |
1986430 | 1986430 | 2021-12-06 | Emmet | Iowa | 19063 | 1805 | 46 |
1983180 | 1983180 | 2021-12-05 | Emmet | Iowa | 19063 | 1805 | 46 |
1979930 | 1979930 | 2021-12-04 | Emmet | Iowa | 19063 | 1805 | 46 |
1976680 | 1976680 | 2021-12-03 | Emmet | Iowa | 19063 | 1805 | 46 |
1973431 | 1973431 | 2021-12-02 | Emmet | Iowa | 19063 | 1805 | 46 |
1973669 | 1973669 | 2021-12-02 | Lee | Kentucky | 21129 | 1805 | 37 |
1969882 | 1969882 | 2021-12-01 | Towns | Georgia | 13281 | 1805 | 84 |
1970181 | 1970181 | 2021-12-01 | Emmet | Iowa | 19063 | 1805 | 46 |
1970419 | 1970419 | 2021-12-01 | Lee | Kentucky | 21129 | 1805 | 37 |
1958695 | 1958695 | 2021-11-27 | Camuy | Puerto Rico | 72027 | 1805 | |
1935111 | 1935111 | 2021-11-20 | Cedar | Missouri | 29039 | 1805 | 42 |
1918972 | 1918972 | 2021-11-15 | Fergus | Montana | 30027 | 1805 | 46 |
1914608 | 1914608 | 2021-11-14 | Screven | Georgia | 13251 | 1805 | 62 |
1911358 | 1911358 | 2021-11-13 | Screven | Georgia | 13251 | 1805 | 62 |
1908109 | 1908109 | 2021-11-12 | Screven | Georgia | 13251 | 1805 | 62 |
1904641 | 1904641 | 2021-11-11 | Prowers | Colorado | 8099 | 1805 | 32 |
1906250 | 1906250 | 2021-11-11 | Yates | New York | 36123 | 1805 | 30 |
1899310 | 1899310 | 2021-11-09 | Montgomery | Mississippi | 28097 | 1805 | 57 |
1900061 | 1900061 | 2021-11-09 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1896811 | 1896811 | 2021-11-08 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1893561 | 1893561 | 2021-11-07 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1890311 | 1890311 | 2021-11-06 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1887061 | 1887061 | 2021-11-05 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1883811 | 1883811 | 2021-11-04 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1880562 | 1880562 | 2021-11-03 | Pushmataha | Oklahoma | 40127 | 1805 | 40 |
1865014 | 1865014 | 2021-10-29 | Caledonia | Vermont | 50005 | 1805 | 16 |
1855010 | 1855010 | 2021-10-26 | Callahan | Texas | 48059 | 1805 | 53 |
1855440 | 1855440 | 2021-10-26 | Pacific | Washington | 53049 | 1805 | 31 |
1838115 | 1838115 | 2021-10-21 | Barnes | North Dakota | 38003 | 1805 | 33 |
1814136 | 1814136 | 2021-10-14 | Pulaski | Indiana | 18131 | 1805 | 54 |
1788571 | 1788571 | 2021-10-06 | Sagadahoc | Maine | 23023 | 1805 | 12 |
1766094 | 1766094 | 2021-09-29 | Noxubee | Mississippi | 28103 | 1805 | 40 |
1759473 | 1759473 | 2021-09-27 | Cottonwood | Minnesota | 27033 | 1805 | 24 |
1761260 | 1761260 | 2021-09-27 | Morgan | West Virginia | 54065 | 1805 | 31 |
1757110 | 1757110 | 2021-09-26 | Baker | Oregon | 41001 | 1805 | 24 |
1753862 | 1753862 | 2021-09-25 | Baker | Oregon | 41001 | 1805 | 24 |
1750614 | 1750614 | 2021-09-24 | Baker | Oregon | 41001 | 1805 | 24 |
1741614 | 1741614 | 2021-09-21 | Goochland | Virginia | 51075 | 1805 | 27 |
1736461 | 1736461 | 2021-09-20 | Lyon | Kentucky | 21143 | 1805 | 24 |
1720797 | 1720797 | 2021-09-15 | Roosevelt | Montana | 30085 | 1805 | 56 |
1712797 | 1712797 | 2021-09-13 | Little River | Arkansas | 5081 | 1805 | 44 |
1700741 | 1700741 | 2021-09-09 | Monroe | Kentucky | 21171 | 1805 | 49 |
1694405 | 1694405 | 2021-09-07 | Antrim | Michigan | 26009 | 1805 | 33 |
1678380 | 1678380 | 2021-09-02 | Perry | Mississippi | 28111 | 1805 | 45 |
1680023 | 1680023 | 2021-09-02 | Hardy | West Virginia | 54031 | 1805 | 25 |
1656808 | 1656808 | 2021-08-26 | Bandera | Texas | 48019 | 1805 | 36 |
1651981 | 1651981 | 2021-08-25 | Henry | Kentucky | 21103 | 1805 | 21 |
1643113 | 1643113 | 2021-08-22 | Currituck | North Carolina | 37053 | 1805 | 17 |
1638087 | 1638087 | 2021-08-21 | Marion | Arkansas | 5089 | 1805 | 45 |
1639863 | 1639863 | 2021-08-21 | Currituck | North Carolina | 37053 | 1805 | 17 |
1640281 | 1640281 | 2021-08-21 | Cayey | Puerto Rico | 72035 | 1805 |
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);