ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where cases = 1449 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 23
- Iowa 21
- Kansas 16
- Puerto Rico 16
- Missouri 15
- Tennessee 14
- Georgia 13
- Virginia 12
- Arkansas 11
- Michigan 11
- Mississippi 11
- South Dakota 10
- Illinois 9
- New York 9
- West Virginia 9
- California 8
- Indiana 8
- North Dakota 8
- Texas 8
- North Carolina 7
- Utah 7
- Colorado 6
- Minnesota 6
- Ohio 6
- Louisiana 5
- Pennsylvania 5
- Washington 5
- Wisconsin 5
- Alabama 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493332 | 2493332 | 2022-05-11 | Huerfano | Colorado | 8055 | 1449 | 35 |
2490074 | 2490074 | 2022-05-10 | Huerfano | Colorado | 8055 | 1449 | 35 |
2486817 | 2486817 | 2022-05-09 | Huerfano | Colorado | 8055 | 1449 | 35 |
2453107 | 2453107 | 2022-04-28 | Maunabo | Puerto Rico | 72095 | 1449 | |
2255732 | 2255732 | 2022-02-27 | Trinity | California | 6105 | 1449 | 20 |
2252481 | 2252481 | 2022-02-26 | Trinity | California | 6105 | 1449 | 20 |
2249230 | 2249230 | 2022-02-25 | Trinity | California | 6105 | 1449 | 20 |
2245979 | 2245979 | 2022-02-24 | Trinity | California | 6105 | 1449 | 20 |
2217862 | 2217862 | 2022-02-15 | Norman | Minnesota | 27107 | 1449 | 13 |
2202262 | 2202262 | 2022-02-10 | Ransom | North Dakota | 38073 | 1449 | 26 |
2203402 | 2203402 | 2022-02-10 | Iron | Wisconsin | 55051 | 1449 | 45 |
2162774 | 2162774 | 2022-01-29 | Shannon | Missouri | 29203 | 1449 | 32 |
2157320 | 2157320 | 2022-01-27 | Brooks | Texas | 48047 | 1449 | 49 |
2150784 | 2150784 | 2022-01-25 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2147532 | 2147532 | 2022-01-24 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2144278 | 2144278 | 2022-01-23 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2141023 | 2141023 | 2022-01-22 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2137767 | 2137767 | 2022-01-21 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2134513 | 2134513 | 2022-01-20 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2131261 | 2131261 | 2022-01-19 | Van Buren | Tennessee | 47175 | 1449 | 45 |
2123071 | 2123071 | 2022-01-17 | Harper | Kansas | 20077 | 1449 | 25 |
2119819 | 2119819 | 2022-01-16 | Harper | Kansas | 20077 | 1449 | 25 |
2116567 | 2116567 | 2022-01-15 | Harper | Kansas | 20077 | 1449 | 25 |
2113316 | 2113316 | 2022-01-14 | Harper | Kansas | 20077 | 1449 | 25 |
2108718 | 2108718 | 2022-01-12 | Stephens | Texas | 48429 | 1449 | 39 |
2076896 | 2076896 | 2022-01-03 | Lincoln | Colorado | 8073 | 1449 | 8 |
2074307 | 2074307 | 2022-01-02 | Kingman | Kansas | 20095 | 1449 | 24 |
2071056 | 2071056 | 2022-01-01 | Kingman | Kansas | 20095 | 1449 | 24 |
2067805 | 2067805 | 2021-12-31 | Kingman | Kansas | 20095 | 1449 | 24 |
2064554 | 2064554 | 2021-12-30 | Kingman | Kansas | 20095 | 1449 | 24 |
2061304 | 2061304 | 2021-12-29 | Kingman | Kansas | 20095 | 1449 | 24 |
2062303 | 2062303 | 2021-12-29 | Graham | North Carolina | 37075 | 1449 | 28 |
2056566 | 2056566 | 2021-12-27 | Franklin | Texas | 48159 | 1449 | 37 |
2012398 | 2012398 | 2021-12-14 | Warren | Indiana | 18171 | 1449 | 19 |
2010397 | 2010397 | 2021-12-13 | Pembina | North Dakota | 38067 | 1449 | 14 |
2007146 | 2007146 | 2021-12-12 | Pembina | North Dakota | 38067 | 1449 | 14 |
2001712 | 2001712 | 2021-12-10 | Clay | West Virginia | 54015 | 1449 | 24 |
1995049 | 1995049 | 2021-12-08 | Buena Vista city | Virginia | 51530 | 1449 | 29 |
1988975 | 1988975 | 2021-12-07 | Cleveland | Arkansas | 5025 | 1449 | 33 |
1988127 | 1988127 | 2021-12-06 | Turner | South Dakota | 46125 | 1449 | 61 |
1975975 | 1975975 | 2021-12-03 | Cleveland | Arkansas | 5025 | 1449 | 33 |
1969250 | 1969250 | 2021-11-30 | Tyler | West Virginia | 54095 | 1449 | 24 |
1965863 | 1965863 | 2021-11-29 | Nelson | Virginia | 51125 | 1449 | 20 |
1961050 | 1961050 | 2021-11-28 | Kemper | Mississippi | 28069 | 1449 | 41 |
1957799 | 1957799 | 2021-11-27 | Kemper | Mississippi | 28069 | 1449 | 41 |
1954548 | 1954548 | 2021-11-26 | Kemper | Mississippi | 28069 | 1449 | 41 |
1951297 | 1951297 | 2021-11-25 | Kemper | Mississippi | 28069 | 1449 | 41 |
1948046 | 1948046 | 2021-11-24 | Kemper | Mississippi | 28069 | 1449 | 41 |
1941608 | 1941608 | 2021-11-22 | Carroll | Missouri | 29033 | 1449 | 39 |
1943231 | 1943231 | 2021-11-22 | Pleasants | West Virginia | 54073 | 1449 | 30 |
1938358 | 1938358 | 2021-11-21 | Carroll | Missouri | 29033 | 1449 | 39 |
1922988 | 1922988 | 2021-11-16 | Salinas | Puerto Rico | 72123 | 1449 | |
1919739 | 1919739 | 2021-11-15 | Salinas | Puerto Rico | 72123 | 1449 | |
1916489 | 1916489 | 2021-11-14 | Salinas | Puerto Rico | 72123 | 1449 | |
1917176 | 1917176 | 2021-11-14 | Lincoln | Washington | 53043 | 1449 | 23 |
1913926 | 1913926 | 2021-11-13 | Lincoln | Washington | 53043 | 1449 | 23 |
1910676 | 1910676 | 2021-11-12 | Lincoln | Washington | 53043 | 1449 | 23 |
1877987 | 1877987 | 2021-11-02 | Grand | Utah | 49019 | 1449 | 4 |
1878067 | 1878067 | 2021-11-02 | Floyd | Virginia | 51063 | 1449 | 29 |
1872317 | 1872317 | 2021-11-01 | Irwin | Georgia | 13155 | 1449 | 39 |
1845516 | 1845516 | 2021-10-23 | Addison | Vermont | 50001 | 1449 | 8 |
1839957 | 1839957 | 2021-10-22 | Valley | Idaho | 16085 | 1449 | 10 |
1842498 | 1842498 | 2021-10-22 | Ritchie | West Virginia | 54085 | 1449 | 18 |
1782852 | 1782852 | 2021-10-04 | Perquimans | North Carolina | 37143 | 1449 | 15 |
1778047 | 1778047 | 2021-10-03 | Clinch | Georgia | 13065 | 1449 | 33 |
1774797 | 1774797 | 2021-10-02 | Clinch | Georgia | 13065 | 1449 | 33 |
1771547 | 1771547 | 2021-10-01 | Clinch | Georgia | 13065 | 1449 | 33 |
1769167 | 1769167 | 2021-09-30 | Luce | Michigan | 26095 | 1449 | 6 |
1765918 | 1765918 | 2021-09-29 | Luce | Michigan | 26095 | 1449 | 6 |
1754017 | 1754017 | 2021-09-25 | Naguabo | Puerto Rico | 72103 | 1449 | |
1744203 | 1744203 | 2021-09-22 | Potter | Pennsylvania | 42105 | 1449 | 29 |
1739514 | 1739514 | 2021-09-21 | Sac | Iowa | 19161 | 1449 | 22 |
1740206 | 1740206 | 2021-09-21 | Montgomery | Missouri | 29139 | 1449 | 18 |
1736265 | 1736265 | 2021-09-20 | Sac | Iowa | 19161 | 1449 | 22 |
1733015 | 1733015 | 2021-09-19 | Sac | Iowa | 19161 | 1449 | 22 |
1733724 | 1733724 | 2021-09-19 | Ralls | Missouri | 29173 | 1449 | 14 |
1729765 | 1729765 | 2021-09-18 | Sac | Iowa | 19161 | 1449 | 22 |
1730474 | 1730474 | 2021-09-18 | Ralls | Missouri | 29173 | 1449 | 14 |
1726515 | 1726515 | 2021-09-17 | Sac | Iowa | 19161 | 1449 | 22 |
1723266 | 1723266 | 2021-09-16 | Sac | Iowa | 19161 | 1449 | 22 |
1720017 | 1720017 | 2021-09-15 | Sac | Iowa | 19161 | 1449 | 22 |
1716720 | 1716720 | 2021-09-14 | Emmet | Iowa | 19063 | 1449 | 41 |
1713474 | 1713474 | 2021-09-13 | Emmet | Iowa | 19063 | 1449 | 41 |
1710227 | 1710227 | 2021-09-12 | Emmet | Iowa | 19063 | 1449 | 41 |
1710302 | 1710302 | 2021-09-12 | Brown | Kansas | 20013 | 1449 | 39 |
1711899 | 1711899 | 2021-09-12 | Lake | South Dakota | 46079 | 1449 | 20 |
1706980 | 1706980 | 2021-09-11 | Emmet | Iowa | 19063 | 1449 | 41 |
1707055 | 1707055 | 2021-09-11 | Brown | Kansas | 20013 | 1449 | 39 |
1708652 | 1708652 | 2021-09-11 | Lake | South Dakota | 46079 | 1449 | 20 |
1703732 | 1703732 | 2021-09-10 | Emmet | Iowa | 19063 | 1449 | 41 |
1703807 | 1703807 | 2021-09-10 | Brown | Kansas | 20013 | 1449 | 39 |
1705405 | 1705405 | 2021-09-10 | Lake | South Dakota | 46079 | 1449 | 20 |
1700482 | 1700482 | 2021-09-09 | Emmet | Iowa | 19063 | 1449 | 41 |
1702883 | 1702883 | 2021-09-09 | Big Horn | Wyoming | 56003 | 1449 | 38 |
1696797 | 1696797 | 2021-09-08 | Atkinson | Georgia | 13003 | 1449 | 24 |
1697233 | 1697233 | 2021-09-08 | Emmet | Iowa | 19063 | 1449 | 41 |
1699436 | 1699436 | 2021-09-08 | Richmond | Virginia | 51159 | 1449 | 12 |
1658641 | 1658641 | 2021-08-27 | Kent | Maryland | 24029 | 1449 | 51 |
1649971 | 1649971 | 2021-08-24 | Forest | Pennsylvania | 42053 | 1449 | 21 |
1633438 | 1633438 | 2021-08-19 | Barnes | North Dakota | 38003 | 1449 | 32 |
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);