ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
447 rows where cases = 959 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 32
- West Virginia 30
- Texas 25
- Mississippi 23
- Georgia 22
- Kentucky 17
- Missouri 17
- Illinois 16
- Nebraska 16
- Arkansas 15
- Iowa 15
- Puerto Rico 15
- Virginia 15
- Minnesota 13
- Tennessee 13
- Oklahoma 11
- Louisiana 10
- Nevada 10
- Alabama 9
- Colorado 9
- North Dakota 9
- South Dakota 9
- Wisconsin 9
- Indiana 8
- Idaho 7
- North Carolina 7
- Ohio 7
- Michigan 6
- New Mexico 6
- South Carolina 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493736 | 2493736 | 2022-05-11 | Pope | Illinois | 17151 | 959 | 8 |
2490478 | 2490478 | 2022-05-10 | Pope | Illinois | 17151 | 959 | 8 |
2487221 | 2487221 | 2022-05-09 | Pope | Illinois | 17151 | 959 | 8 |
2438373 | 2438373 | 2022-04-24 | Pope | Illinois | 17151 | 959 | 8 |
2435117 | 2435117 | 2022-04-23 | Pope | Illinois | 17151 | 959 | 8 |
2431861 | 2431861 | 2022-04-22 | Pope | Illinois | 17151 | 959 | 8 |
2428605 | 2428605 | 2022-04-21 | Pope | Illinois | 17151 | 959 | 8 |
2330413 | 2330413 | 2022-03-22 | Calhoun | Arkansas | 5013 | 959 | 10 |
2327161 | 2327161 | 2022-03-21 | Calhoun | Arkansas | 5013 | 959 | 10 |
2323908 | 2323908 | 2022-03-20 | Calhoun | Arkansas | 5013 | 959 | 10 |
2320654 | 2320654 | 2022-03-19 | Calhoun | Arkansas | 5013 | 959 | 10 |
2312329 | 2312329 | 2022-03-16 | Knox | Missouri | 29103 | 959 | 12 |
2312935 | 2312935 | 2022-03-16 | Beaver | Oklahoma | 40007 | 959 | 10 |
2309076 | 2309076 | 2022-03-15 | Knox | Missouri | 29103 | 959 | 12 |
2309682 | 2309682 | 2022-03-15 | Beaver | Oklahoma | 40007 | 959 | 10 |
2306429 | 2306429 | 2022-03-14 | Beaver | Oklahoma | 40007 | 959 | 10 |
2303178 | 2303178 | 2022-03-13 | Beaver | Oklahoma | 40007 | 959 | 10 |
2299926 | 2299926 | 2022-03-12 | Beaver | Oklahoma | 40007 | 959 | 10 |
2296674 | 2296674 | 2022-03-11 | Beaver | Oklahoma | 40007 | 959 | 10 |
2293422 | 2293422 | 2022-03-10 | Beaver | Oklahoma | 40007 | 959 | 10 |
2283286 | 2283286 | 2022-03-07 | Mineral | Nevada | 32021 | 959 | 16 |
2280033 | 2280033 | 2022-03-06 | Mineral | Nevada | 32021 | 959 | 15 |
2276780 | 2276780 | 2022-03-05 | Mineral | Nevada | 32021 | 959 | 15 |
2273527 | 2273527 | 2022-03-04 | Mineral | Nevada | 32021 | 959 | 15 |
2270275 | 2270275 | 2022-03-03 | Mineral | Nevada | 32021 | 959 | 15 |
2267022 | 2267022 | 2022-03-02 | Mineral | Nevada | 32021 | 959 | 15 |
2263771 | 2263771 | 2022-03-01 | Mineral | Nevada | 32021 | 959 | 15 |
2214815 | 2214815 | 2022-02-14 | Putnam | Missouri | 29171 | 959 | 21 |
2202241 | 2202241 | 2022-02-10 | Foster | North Dakota | 38031 | 959 | 20 |
2198140 | 2198140 | 2022-02-09 | Tensas | Louisiana | 22107 | 959 | 11 |
2194889 | 2194889 | 2022-02-08 | Unknown | Louisiana | 959 | 0 | |
2156497 | 2156497 | 2022-01-27 | Hidalgo | New Mexico | 35023 | 959 | 12 |
2130904 | 2130904 | 2022-01-19 | Wallowa | Oregon | 41063 | 959 | 13 |
2097857 | 2097857 | 2022-01-09 | Morrill | Nebraska | 31123 | 959 | 16 |
2094605 | 2094605 | 2022-01-08 | Morrill | Nebraska | 31123 | 959 | 16 |
2091353 | 2091353 | 2022-01-07 | Morrill | Nebraska | 31123 | 959 | 16 |
2088102 | 2088102 | 2022-01-06 | Morrill | Nebraska | 31123 | 959 | 16 |
2079363 | 2079363 | 2022-01-03 | Jim Hogg | Texas | 48247 | 959 | 20 |
2031124 | 2031124 | 2021-12-20 | Choctaw | Alabama | 1023 | 959 | 30 |
2027873 | 2027873 | 2021-12-19 | Choctaw | Alabama | 1023 | 959 | 30 |
2024622 | 2024622 | 2021-12-18 | Choctaw | Alabama | 1023 | 959 | 30 |
2021371 | 2021371 | 2021-12-17 | Choctaw | Alabama | 1023 | 959 | 30 |
1997184 | 1997184 | 2021-12-09 | Los Alamos | New Mexico | 35028 | 959 | 10 |
1998156 | 1998156 | 2021-12-09 | Newton | Texas | 48351 | 959 | 54 |
1994905 | 1994905 | 2021-12-08 | Newton | Texas | 48351 | 959 | 54 |
1969426 | 1969426 | 2021-12-01 | Dillingham Census Area | Alaska | 2070 | 959 | 8 |
1965353 | 1965353 | 2021-11-29 | Kingsbury | South Dakota | 46077 | 959 | 18 |
1942136 | 1942136 | 2021-11-22 | Ransom | North Dakota | 38073 | 959 | 20 |
1938886 | 1938886 | 2021-11-21 | Ransom | North Dakota | 38073 | 959 | 20 |
1935636 | 1935636 | 2021-11-20 | Ransom | North Dakota | 38073 | 959 | 20 |
1928088 | 1928088 | 2021-11-18 | Wabaunsee | Kansas | 20197 | 959 | 18 |
1924838 | 1924838 | 2021-11-17 | Wabaunsee | Kansas | 20197 | 959 | 18 |
1923100 | 1923100 | 2021-11-16 | McCook | South Dakota | 46087 | 959 | 25 |
1907172 | 1907172 | 2021-11-11 | Sabine | Texas | 48403 | 959 | 73 |
1903923 | 1903923 | 2021-11-10 | Sabine | Texas | 48403 | 959 | 73 |
1899876 | 1899876 | 2021-11-09 | McHenry | North Dakota | 38049 | 959 | 23 |
1900673 | 1900673 | 2021-11-09 | Sabine | Texas | 48403 | 959 | 73 |
1897423 | 1897423 | 2021-11-08 | Sabine | Texas | 48403 | 959 | 73 |
1894173 | 1894173 | 2021-11-07 | Sabine | Texas | 48403 | 959 | 73 |
1890923 | 1890923 | 2021-11-06 | Sabine | Texas | 48403 | 959 | 73 |
1887673 | 1887673 | 2021-11-05 | Sabine | Texas | 48403 | 959 | 73 |
1879795 | 1879795 | 2021-11-03 | Jefferson | Mississippi | 28063 | 959 | 34 |
1876546 | 1876546 | 2021-11-02 | Jefferson | Mississippi | 28063 | 959 | 34 |
1878204 | 1878204 | 2021-11-02 | Calhoun | West Virginia | 54013 | 959 | 5 |
1873297 | 1873297 | 2021-11-01 | Jefferson | Mississippi | 28063 | 959 | 34 |
1871706 | 1871706 | 2021-10-31 | Calhoun | West Virginia | 54013 | 959 | 4 |
1860538 | 1860538 | 2021-10-28 | Cedar | Nebraska | 31027 | 959 | 11 |
1857289 | 1857289 | 2021-10-27 | Cedar | Nebraska | 31027 | 959 | 11 |
1858798 | 1858798 | 2021-10-27 | Menominee | Wisconsin | 55078 | 959 | 11 |
1853803 | 1853803 | 2021-10-26 | Jefferson | Mississippi | 28063 | 959 | 34 |
1855549 | 1855549 | 2021-10-26 | Menominee | Wisconsin | 55078 | 959 | 11 |
1826847 | 1826847 | 2021-10-18 | Marion | Georgia | 13197 | 959 | 36 |
1826933 | 1826933 | 2021-10-18 | Caribou | Idaho | 16029 | 959 | 17 |
1825128 | 1825128 | 2021-10-17 | Dickey | North Dakota | 38021 | 959 | 33 |
1821879 | 1821879 | 2021-10-16 | Dickey | North Dakota | 38021 | 959 | 33 |
1813622 | 1813622 | 2021-10-14 | Conejos | Colorado | 8021 | 959 | 32 |
1777904 | 1777904 | 2021-10-03 | Lake | Colorado | 8065 | 959 | 1 |
1774654 | 1774654 | 2021-10-02 | Lake | Colorado | 8065 | 959 | 1 |
1771404 | 1771404 | 2021-10-01 | Lake | Colorado | 8065 | 959 | 1 |
1772686 | 1772686 | 2021-10-01 | Maries | Missouri | 29125 | 959 | 17 |
1772720 | 1772720 | 2021-10-01 | Shannon | Missouri | 29203 | 959 | 16 |
1769437 | 1769437 | 2021-09-30 | Maries | Missouri | 29125 | 959 | 17 |
1756823 | 1756823 | 2021-09-26 | Gates | North Carolina | 37073 | 959 | 15 |
1753575 | 1753575 | 2021-09-25 | Gates | North Carolina | 37073 | 959 | 15 |
1750327 | 1750327 | 2021-09-24 | Gates | North Carolina | 37073 | 959 | 15 |
1737308 | 1737308 | 2021-09-20 | Camden | North Carolina | 37029 | 959 | 8 |
1723074 | 1723074 | 2021-09-16 | Schuyler | Illinois | 17169 | 959 | 20 |
1719702 | 1719702 | 2021-09-15 | Benewah | Idaho | 16009 | 959 | 12 |
1721737 | 1721737 | 2021-09-15 | Pickett | Tennessee | 47137 | 959 | 24 |
1722274 | 1722274 | 2021-09-15 | Pendleton | West Virginia | 54071 | 959 | 12 |
1710077 | 1710077 | 2021-09-12 | Pulaski | Illinois | 17153 | 959 | 11 |
1706830 | 1706830 | 2021-09-11 | Pulaski | Illinois | 17153 | 959 | 11 |
1707679 | 1707679 | 2021-09-11 | Daviess | Missouri | 29061 | 959 | 13 |
1703582 | 1703582 | 2021-09-10 | Pulaski | Illinois | 17153 | 959 | 11 |
1690093 | 1690093 | 2021-09-06 | Woodruff | Arkansas | 5147 | 959 | 19 |
1685746 | 1685746 | 2021-09-04 | Aibonito | Puerto Rico | 72009 | 959 | |
1677949 | 1677949 | 2021-09-02 | Gallatin | Kentucky | 21077 | 959 | 34 |
1674195 | 1674195 | 2021-09-01 | Twiggs | Georgia | 13289 | 959 | 49 |
1675003 | 1675003 | 2021-09-01 | Clearwater | Minnesota | 27029 | 959 | 18 |
1664007 | 1664007 | 2021-08-29 | Sitka City and Borough | Alaska | 2220 | 959 | 2 |
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);