ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
225 rows where cases = 2344 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 19
- Ohio 18
- Texas 18
- Alabama 11
- Tennessee 11
- Virginia 11
- Kentucky 10
- Missouri 10
- Oklahoma 10
- Indiana 9
- Michigan 9
- Illinois 8
- Iowa 8
- Minnesota 7
- Montana 6
- North Carolina 6
- Puerto Rico 6
- Louisiana 5
- Mississippi 5
- Nebraska 5
- Washington 4
- California 3
- Idaho 3
- New York 3
- Oregon 3
- Arkansas 2
- Maine 2
- North Dakota 2
- South Carolina 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494455 | 2494455 | 2022-05-11 | Rock | Minnesota | 27133 | 2344 | 34 |
2491197 | 2491197 | 2022-05-10 | Rock | Minnesota | 27133 | 2344 | 34 |
2424247 | 2424247 | 2022-04-19 | Runnels | Texas | 48399 | 2344 | 66 |
2401654 | 2401654 | 2022-04-12 | Poquoson city | Virginia | 51735 | 2344 | 30 |
2398399 | 2398399 | 2022-04-11 | Poquoson city | Virginia | 51735 | 2344 | 30 |
2336363 | 2336363 | 2022-03-23 | Parmer | Texas | 48369 | 2344 | 52 |
2308352 | 2308352 | 2022-03-15 | Emmet | Iowa | 19063 | 2344 | 51 |
2305101 | 2305101 | 2022-03-14 | Emmet | Iowa | 19063 | 2344 | 51 |
2301849 | 2301849 | 2022-03-13 | Emmet | Iowa | 19063 | 2344 | 51 |
2298597 | 2298597 | 2022-03-12 | Emmet | Iowa | 19063 | 2344 | 51 |
2295345 | 2295345 | 2022-03-11 | Emmet | Iowa | 19063 | 2344 | 51 |
2292093 | 2292093 | 2022-03-10 | Emmet | Iowa | 19063 | 2344 | 51 |
2288841 | 2288841 | 2022-03-09 | Emmet | Iowa | 19063 | 2344 | 51 |
2291263 | 2291263 | 2022-03-09 | Washakie | Wyoming | 56043 | 2344 | 43 |
2288011 | 2288011 | 2022-03-08 | Washakie | Wyoming | 56043 | 2344 | 43 |
2259839 | 2259839 | 2022-02-28 | Owen | Kentucky | 21187 | 2344 | 32 |
2237598 | 2237598 | 2022-02-21 | Wayne | Missouri | 29223 | 2344 | 44 |
2237613 | 2237613 | 2022-02-21 | Deer Lodge | Montana | 30023 | 2344 | 29 |
2234347 | 2234347 | 2022-02-20 | Wayne | Missouri | 29223 | 2344 | 44 |
2234362 | 2234362 | 2022-02-20 | Deer Lodge | Montana | 30023 | 2344 | 29 |
2231096 | 2231096 | 2022-02-19 | Wayne | Missouri | 29223 | 2344 | 44 |
2231111 | 2231111 | 2022-02-19 | Deer Lodge | Montana | 30023 | 2344 | 29 |
2227845 | 2227845 | 2022-02-18 | Wayne | Missouri | 29223 | 2344 | 44 |
2227860 | 2227860 | 2022-02-18 | Deer Lodge | Montana | 30023 | 2344 | 29 |
2224594 | 2224594 | 2022-02-17 | Wayne | Missouri | 29223 | 2344 | 44 |
2193428 | 2193428 | 2022-02-07 | Floyd | Virginia | 51063 | 2344 | 36 |
2167234 | 2167234 | 2022-01-30 | Morris | Texas | 48343 | 2344 | 61 |
2128253 | 2128253 | 2022-01-18 | Ward | Texas | 48475 | 2344 | 37 |
2060884 | 2060884 | 2021-12-29 | Telfair | Georgia | 13271 | 2344 | 75 |
2062950 | 2062950 | 2021-12-29 | Meigs | Tennessee | 47121 | 2344 | 46 |
2052996 | 2052996 | 2021-12-26 | Morovis | Puerto Rico | 72101 | 2344 | |
2049482 | 2049482 | 2021-12-25 | Morgan | Ohio | 39115 | 2344 | 43 |
2046232 | 2046232 | 2021-12-24 | Morgan | Ohio | 39115 | 2344 | 43 |
2016516 | 2016516 | 2021-12-15 | Roosevelt | Montana | 30085 | 2344 | 69 |
1998286 | 1998286 | 2021-12-09 | Alleghany | Virginia | 51005 | 2344 | 84 |
1986714 | 1986714 | 2021-12-06 | Trigg | Kentucky | 21221 | 2344 | 28 |
1962411 | 1962411 | 2021-11-28 | Pecos | Texas | 48371 | 2344 | 54 |
1959160 | 1959160 | 2021-11-27 | Pecos | Texas | 48371 | 2344 | 54 |
1953679 | 1953679 | 2021-11-26 | Gooding | Idaho | 16047 | 2344 | 42 |
1955909 | 1955909 | 2021-11-26 | Pecos | Texas | 48371 | 2344 | 54 |
1950428 | 1950428 | 2021-11-25 | Gooding | Idaho | 16047 | 2344 | 42 |
1952658 | 1952658 | 2021-11-25 | Pecos | Texas | 48371 | 2344 | 54 |
1947177 | 1947177 | 2021-11-24 | Gooding | Idaho | 16047 | 2344 | 42 |
1949407 | 1949407 | 2021-11-24 | Pecos | Texas | 48371 | 2344 | 54 |
1944538 | 1944538 | 2021-11-23 | Knox | Maine | 23013 | 2344 | 15 |
1946156 | 1946156 | 2021-11-23 | Pecos | Texas | 48371 | 2344 | 54 |
1942905 | 1942905 | 2021-11-22 | Pecos | Texas | 48371 | 2344 | 54 |
1939655 | 1939655 | 2021-11-21 | Pecos | Texas | 48371 | 2344 | 53 |
1936405 | 1936405 | 2021-11-20 | Pecos | Texas | 48371 | 2344 | 53 |
1933155 | 1933155 | 2021-11-19 | Pecos | Texas | 48371 | 2344 | 52 |
1917746 | 1917746 | 2021-11-15 | Bleckley | Georgia | 13023 | 2344 | 80 |
1909650 | 1909650 | 2021-11-12 | Walsh | North Dakota | 38099 | 2344 | 29 |
1895380 | 1895380 | 2021-11-08 | Tipton | Indiana | 18159 | 2344 | 63 |
1882713 | 1882713 | 2021-11-04 | Washington | Kentucky | 21229 | 2344 | 46 |
1870365 | 1870365 | 2021-10-31 | York | Nebraska | 31185 | 2344 | 19 |
1866912 | 1866912 | 2021-10-30 | Madison | Missouri | 29123 | 2344 | 25 |
1867116 | 1867116 | 2021-10-30 | York | Nebraska | 31185 | 2344 | 19 |
1863867 | 1863867 | 2021-10-29 | York | Nebraska | 31185 | 2344 | 19 |
1841735 | 1841735 | 2021-10-22 | Manati | Puerto Rico | 72091 | 2344 | |
1838486 | 1838486 | 2021-10-21 | Manati | Puerto Rico | 72091 | 2344 | |
1828185 | 1828185 | 2021-10-18 | Grant | New Mexico | 35017 | 2344 | 49 |
1824427 | 1824427 | 2021-10-17 | Roscommon | Michigan | 26143 | 2344 | 62 |
1821178 | 1821178 | 2021-10-16 | Roscommon | Michigan | 26143 | 2344 | 62 |
1817929 | 1817929 | 2021-10-15 | Roscommon | Michigan | 26143 | 2344 | 62 |
1773240 | 1773240 | 2021-10-01 | Meigs | Ohio | 39105 | 2344 | 44 |
1764369 | 1764369 | 2021-09-28 | King George | Virginia | 51099 | 2344 | 22 |
1757523 | 1757523 | 2021-09-26 | Bosque | Texas | 48035 | 2344 | 50 |
1754275 | 1754275 | 2021-09-25 | Bosque | Texas | 48035 | 2344 | 49 |
1738357 | 1738357 | 2021-09-20 | Fluvanna | Virginia | 51065 | 2344 | 22 |
1720268 | 1720268 | 2021-09-15 | Bienville | Louisiana | 22013 | 2344 | 87 |
1721537 | 1721537 | 2021-09-15 | San Lorenzo | Puerto Rico | 72129 | 2344 | |
1717937 | 1717937 | 2021-09-14 | Rolette | North Dakota | 38079 | 2344 | 28 |
1711957 | 1711957 | 2021-09-12 | Grundy | Tennessee | 47061 | 2344 | 36 |
1708710 | 1708710 | 2021-09-11 | Grundy | Tennessee | 47061 | 2344 | 36 |
1705463 | 1705463 | 2021-09-10 | Grundy | Tennessee | 47061 | 2344 | 36 |
1695357 | 1695357 | 2021-09-07 | Murray | Oklahoma | 40099 | 2344 | 47 |
1690543 | 1690543 | 2021-09-06 | Hancock | Illinois | 17067 | 2344 | 44 |
1692109 | 1692109 | 2021-09-06 | Murray | Oklahoma | 40099 | 2344 | 47 |
1687293 | 1687293 | 2021-09-05 | Hancock | Illinois | 17067 | 2344 | 44 |
1688860 | 1688860 | 2021-09-05 | Murray | Oklahoma | 40099 | 2344 | 47 |
1684043 | 1684043 | 2021-09-04 | Hancock | Illinois | 17067 | 2344 | 44 |
1685610 | 1685610 | 2021-09-04 | Murray | Oklahoma | 40099 | 2344 | 47 |
1680792 | 1680792 | 2021-09-03 | Hancock | Illinois | 17067 | 2344 | 44 |
1682359 | 1682359 | 2021-09-03 | Murray | Oklahoma | 40099 | 2344 | 47 |
1682856 | 1682856 | 2021-09-03 | Falls | Texas | 48145 | 2344 | 35 |
1678523 | 1678523 | 2021-09-02 | Wright | Missouri | 29229 | 2344 | 43 |
1679109 | 1679109 | 2021-09-02 | Murray | Oklahoma | 40099 | 2344 | 47 |
1675861 | 1675861 | 2021-09-01 | Murray | Oklahoma | 40099 | 2344 | 47 |
1671980 | 1671980 | 2021-08-31 | Moniteau | Missouri | 29135 | 2344 | 36 |
1650868 | 1650868 | 2021-08-24 | Langlade | Wisconsin | 55067 | 2344 | 51 |
1626859 | 1626859 | 2021-08-17 | Caswell | North Carolina | 37033 | 2344 | 30 |
1622837 | 1622837 | 2021-08-16 | Jackson | Louisiana | 22049 | 2344 | 55 |
1623448 | 1623448 | 2021-08-16 | Unknown | Nebraska | 2344 | 0 | |
1619712 | 1619712 | 2021-08-15 | Gladwin | Michigan | 26051 | 2344 | 61 |
1616464 | 1616464 | 2021-08-14 | Gladwin | Michigan | 26051 | 2344 | 61 |
1613216 | 1613216 | 2021-08-13 | Gladwin | Michigan | 26051 | 2344 | 61 |
1605241 | 1605241 | 2021-08-10 | Salem city | Virginia | 51775 | 2344 | 50 |
1602013 | 1602013 | 2021-08-09 | Adams | Washington | 53001 | 2344 | 24 |
1577297 | 1577297 | 2021-08-02 | Morgan | Kentucky | 21175 | 2344 | 5 |
1556914 | 1556914 | 2021-07-27 | Colusa | California | 6011 | 2344 | 18 |
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);