ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
503 rows where cases = 719 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45
- Virginia 33
- South Dakota 31
- Missouri 25
- Nebraska 25
- Kentucky 22
- Minnesota 21
- Georgia 20
- Iowa 19
- Mississippi 18
- Arkansas 16
- Illinois 16
- Kansas 15
- Michigan 14
- Montana 13
- New Mexico 12
- North Carolina 12
- Indiana 11
- Tennessee 11
- North Dakota 10
- West Virginia 10
- Louisiana 9
- Washington 9
- Puerto Rico 8
- South Carolina 8
- Alabama 7
- Ohio 7
- Maine 6
- Alaska 5
- Oklahoma 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464630 | 2464630 | 2022-05-02 | Unknown | Iowa | 719 | 0 | |
2461374 | 2461374 | 2022-05-01 | Unknown | Iowa | 719 | 0 | |
2458118 | 2458118 | 2022-04-30 | Unknown | Iowa | 719 | 0 | |
2388382 | 2388382 | 2022-04-08 | Lipscomb | Texas | 48295 | 719 | 15 |
2385127 | 2385127 | 2022-04-07 | Lipscomb | Texas | 48295 | 719 | 15 |
2381872 | 2381872 | 2022-04-06 | Lipscomb | Texas | 48295 | 719 | 16 |
2378617 | 2378617 | 2022-04-05 | Lipscomb | Texas | 48295 | 719 | 16 |
2257178 | 2257178 | 2022-02-27 | Chase | Nebraska | 31029 | 719 | 6 |
2257216 | 2257216 | 2022-02-27 | Kimball | Nebraska | 31105 | 719 | 9 |
2253927 | 2253927 | 2022-02-26 | Chase | Nebraska | 31029 | 719 | 6 |
2253965 | 2253965 | 2022-02-26 | Kimball | Nebraska | 31105 | 719 | 9 |
2250676 | 2250676 | 2022-02-25 | Chase | Nebraska | 31029 | 719 | 6 |
2250714 | 2250714 | 2022-02-25 | Kimball | Nebraska | 31105 | 719 | 9 |
2247425 | 2247425 | 2022-02-24 | Chase | Nebraska | 31029 | 719 | 6 |
2244174 | 2244174 | 2022-02-23 | Chase | Nebraska | 31029 | 719 | 6 |
2240923 | 2240923 | 2022-02-22 | Chase | Nebraska | 31029 | 719 | 6 |
2237672 | 2237672 | 2022-02-21 | Chase | Nebraska | 31029 | 719 | 6 |
2225745 | 2225745 | 2022-02-17 | Kinney | Texas | 48271 | 719 | 10 |
2214915 | 2214915 | 2022-02-14 | Chase | Nebraska | 31029 | 719 | 6 |
2215250 | 2215250 | 2022-02-14 | Emmons | North Dakota | 38029 | 719 | 17 |
2205493 | 2205493 | 2022-02-11 | Emmons | North Dakota | 38029 | 719 | 17 |
2198798 | 2198798 | 2022-02-09 | Mora | New Mexico | 35033 | 719 | 16 |
2195077 | 2195077 | 2022-02-08 | Lake of the Woods | Minnesota | 27077 | 719 | 5 |
2195396 | 2195396 | 2022-02-08 | Chase | Nebraska | 31029 | 719 | 6 |
2112498 | 2112498 | 2022-01-14 | Calhoun | Arkansas | 5013 | 719 | 9 |
2104494 | 2104494 | 2022-01-11 | Hamilton | New York | 36041 | 719 | 4 |
2079099 | 2079099 | 2022-01-03 | Edmunds | South Dakota | 46045 | 719 | 14 |
2043819 | 2043819 | 2021-12-23 | Craig | Virginia | 51045 | 719 | 11 |
2039459 | 2039459 | 2021-12-22 | Union | New Mexico | 35059 | 719 | 12 |
2028883 | 2028883 | 2021-12-19 | Carlisle | Kentucky | 21039 | 719 | 12 |
2025632 | 2025632 | 2021-12-18 | Carlisle | Kentucky | 21039 | 719 | 12 |
2022381 | 2022381 | 2021-12-17 | Carlisle | Kentucky | 21039 | 719 | 12 |
2019130 | 2019130 | 2021-12-16 | Carlisle | Kentucky | 21039 | 719 | 12 |
2019418 | 2019418 | 2021-12-16 | Ontonagon | Michigan | 26131 | 719 | 26 |
2016168 | 2016168 | 2021-12-15 | Ontonagon | Michigan | 26131 | 719 | 26 |
2000190 | 2000190 | 2021-12-10 | Putnam | Missouri | 29171 | 719 | 19 |
1986992 | 1986992 | 2021-12-06 | Red Lake | Minnesota | 27125 | 719 | 10 |
1985319 | 1985319 | 2021-12-05 | Falls Church city | Virginia | 51610 | 719 | 14 |
1982069 | 1982069 | 2021-12-04 | Falls Church city | Virginia | 51610 | 719 | 14 |
1978819 | 1978819 | 2021-12-03 | Falls Church city | Virginia | 51610 | 719 | 14 |
1940684 | 1940684 | 2021-11-22 | Lincoln | Idaho | 16063 | 719 | 14 |
1928098 | 1928098 | 2021-11-18 | Ballard | Kentucky | 21007 | 719 | 20 |
1915794 | 1915794 | 2021-11-14 | Fillmore | Nebraska | 31059 | 719 | 13 |
1915813 | 1915813 | 2021-11-14 | Johnson | Nebraska | 31097 | 719 | 10 |
1912544 | 1912544 | 2021-11-13 | Fillmore | Nebraska | 31059 | 719 | 13 |
1912563 | 1912563 | 2021-11-13 | Johnson | Nebraska | 31097 | 719 | 10 |
1909294 | 1909294 | 2021-11-12 | Fillmore | Nebraska | 31059 | 719 | 13 |
1909313 | 1909313 | 2021-11-12 | Johnson | Nebraska | 31097 | 719 | 10 |
1904652 | 1904652 | 2021-11-11 | Washington | Colorado | 8121 | 719 | 21 |
1895204 | 1895204 | 2021-11-08 | Calhoun | Illinois | 17013 | 719 | 5 |
1895282 | 1895282 | 2021-11-08 | Scott | Illinois | 17171 | 719 | 7 |
1872487 | 1872487 | 2021-11-01 | Henderson | Illinois | 17071 | 719 | 23 |
1851816 | 1851816 | 2021-10-25 | Garza | Texas | 48169 | 719 | 22 |
1848361 | 1848361 | 2021-10-24 | Lyman | South Dakota | 46085 | 719 | 11 |
1848566 | 1848566 | 2021-10-24 | Garza | Texas | 48169 | 719 | 22 |
1845111 | 1845111 | 2021-10-23 | Lyman | South Dakota | 46085 | 719 | 11 |
1845316 | 1845316 | 2021-10-23 | Garza | Texas | 48169 | 719 | 22 |
1841861 | 1841861 | 2021-10-22 | Lyman | South Dakota | 46085 | 719 | 11 |
1838612 | 1838612 | 2021-10-21 | Lyman | South Dakota | 46085 | 719 | 11 |
1833462 | 1833462 | 2021-10-20 | Alexander | Illinois | 17003 | 719 | 12 |
1835363 | 1835363 | 2021-10-20 | Lyman | South Dakota | 46085 | 719 | 11 |
1830050 | 1830050 | 2021-10-19 | Echols | Georgia | 13101 | 719 | 11 |
1830213 | 1830213 | 2021-10-19 | Alexander | Illinois | 17003 | 719 | 12 |
1826801 | 1826801 | 2021-10-18 | Echols | Georgia | 13101 | 719 | 11 |
1823552 | 1823552 | 2021-10-17 | Echols | Georgia | 13101 | 719 | 11 |
1820303 | 1820303 | 2021-10-16 | Echols | Georgia | 13101 | 719 | 11 |
1817054 | 1817054 | 2021-10-15 | Echols | Georgia | 13101 | 719 | 11 |
1813806 | 1813806 | 2021-10-14 | Echols | Georgia | 13101 | 719 | 11 |
1810190 | 1810190 | 2021-10-13 | Dillingham Census Area | Alaska | 2070 | 719 | 5 |
1801736 | 1801736 | 2021-10-10 | Lincoln | Minnesota | 27081 | 719 | 5 |
1798487 | 1798487 | 2021-10-09 | Lincoln | Minnesota | 27081 | 719 | 5 |
1795238 | 1795238 | 2021-10-08 | Lincoln | Minnesota | 27081 | 719 | 5 |
1791142 | 1791142 | 2021-10-07 | Talbot | Georgia | 13263 | 719 | 24 |
1779289 | 1779289 | 2021-10-03 | Teton | Montana | 30099 | 719 | 7 |
1779666 | 1779666 | 2021-10-03 | Pierce | North Dakota | 38069 | 719 | 26 |
1776039 | 1776039 | 2021-10-02 | Teton | Montana | 30099 | 719 | 7 |
1772789 | 1772789 | 2021-10-01 | Teton | Montana | 30099 | 719 | 7 |
1722400 | 1722400 | 2021-09-16 | Choctaw | Alabama | 1023 | 719 | 25 |
1719152 | 1719152 | 2021-09-15 | Choctaw | Alabama | 1023 | 719 | 25 |
1720932 | 1720932 | 2021-09-15 | Unknown | New Hampshire | 719 | 1 | |
1721652 | 1721652 | 2021-09-15 | Moody | South Dakota | 46101 | 719 | 20 |
1716523 | 1716523 | 2021-09-14 | Gallatin | Illinois | 17059 | 719 | 5 |
1716724 | 1716724 | 2021-09-14 | Fremont | Iowa | 19071 | 719 | 10 |
1713478 | 1713478 | 2021-09-13 | Fremont | Iowa | 19071 | 719 | 10 |
1710231 | 1710231 | 2021-09-12 | Fremont | Iowa | 19071 | 719 | 10 |
1710377 | 1710377 | 2021-09-12 | Rooks | Kansas | 20163 | 719 | 11 |
1706984 | 1706984 | 2021-09-11 | Fremont | Iowa | 19071 | 719 | 10 |
1707130 | 1707130 | 2021-09-11 | Rooks | Kansas | 20163 | 719 | 11 |
1703736 | 1703736 | 2021-09-10 | Fremont | Iowa | 19071 | 719 | 10 |
1703882 | 1703882 | 2021-09-10 | Rooks | Kansas | 20163 | 719 | 11 |
1704934 | 1704934 | 2021-09-10 | McHenry | North Dakota | 38049 | 719 | 23 |
1700486 | 1700486 | 2021-09-09 | Fremont | Iowa | 19071 | 719 | 10 |
1701702 | 1701702 | 2021-09-09 | Sioux | North Dakota | 38085 | 719 | 13 |
1697237 | 1697237 | 2021-09-08 | Fremont | Iowa | 19071 | 719 | 10 |
1691153 | 1691153 | 2021-09-06 | Alger | Michigan | 26003 | 719 | 7 |
1687903 | 1687903 | 2021-09-05 | Alger | Michigan | 26003 | 719 | 7 |
1684653 | 1684653 | 2021-09-04 | Alger | Michigan | 26003 | 719 | 7 |
1681402 | 1681402 | 2021-09-03 | Alger | Michigan | 26003 | 719 | 7 |
1676768 | 1676768 | 2021-09-01 | Doddridge | West Virginia | 54017 | 719 | 6 |
1673563 | 1673563 | 2021-08-31 | Webster | West Virginia | 54101 | 719 | 10 |
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);