ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
422 rows where cases = 967 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- Mississippi 32
- Georgia 30
- Nebraska 24
- Virginia 23
- Kansas 22
- Kentucky 19
- Missouri 19
- South Dakota 14
- Oklahoma 13
- Indiana 11
- Minnesota 11
- Iowa 10
- Louisiana 10
- North Carolina 10
- New Mexico 9
- Colorado 8
- Oregon 8
- Arkansas 7
- Illinois 7
- North Dakota 7
- Puerto Rico 7
- Idaho 6
- Montana 6
- Tennessee 6
- West Virginia 6
- Wisconsin 6
- Alabama 5
- California 5
- Ohio 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426833 | 2426833 | 2022-04-20 | Beaver | Oklahoma | 40007 | 967 | 11 |
2423577 | 2423577 | 2022-04-19 | Beaver | Oklahoma | 40007 | 967 | 11 |
2420320 | 2420320 | 2022-04-18 | Beaver | Oklahoma | 40007 | 967 | 11 |
2417065 | 2417065 | 2022-04-17 | Beaver | Oklahoma | 40007 | 967 | 11 |
2413809 | 2413809 | 2022-04-16 | Beaver | Oklahoma | 40007 | 967 | 11 |
2410553 | 2410553 | 2022-04-15 | Beaver | Oklahoma | 40007 | 967 | 11 |
2407297 | 2407297 | 2022-04-14 | Beaver | Oklahoma | 40007 | 967 | 11 |
2338356 | 2338356 | 2022-03-24 | Knox | Missouri | 29103 | 967 | 13 |
2335102 | 2335102 | 2022-03-23 | Knox | Missouri | 29103 | 967 | 13 |
2269520 | 2269520 | 2022-03-03 | Carlisle | Kentucky | 21039 | 967 | 19 |
2270493 | 2270493 | 2022-03-03 | Tyrrell | North Carolina | 37177 | 967 | 8 |
2267241 | 2267241 | 2022-03-02 | Tyrrell | North Carolina | 37177 | 967 | 8 |
2263989 | 2263989 | 2022-03-01 | Tyrrell | North Carolina | 37177 | 967 | 8 |
2260738 | 2260738 | 2022-02-28 | Tyrrell | North Carolina | 37177 | 967 | 8 |
2257244 | 2257244 | 2022-02-27 | Sheridan | Nebraska | 31161 | 967 | 23 |
2253993 | 2253993 | 2022-02-26 | Sheridan | Nebraska | 31161 | 967 | 23 |
2250742 | 2250742 | 2022-02-25 | Sheridan | Nebraska | 31161 | 967 | 23 |
2243667 | 2243667 | 2022-02-23 | Unknown | Louisiana | 967 | 0 | |
2240416 | 2240416 | 2022-02-22 | Unknown | Louisiana | 967 | 0 | |
2241979 | 2241979 | 2022-02-22 | Hudspeth | Texas | 48229 | 967 | 16 |
2237165 | 2237165 | 2022-02-21 | Unknown | Louisiana | 967 | 0 | |
2238728 | 2238728 | 2022-02-21 | Hudspeth | Texas | 48229 | 967 | 16 |
2235477 | 2235477 | 2022-02-20 | Hudspeth | Texas | 48229 | 967 | 16 |
2224568 | 2224568 | 2022-02-17 | Putnam | Missouri | 29171 | 967 | 22 |
2221483 | 2221483 | 2022-02-16 | Sheridan | Nebraska | 31161 | 967 | 23 |
2218232 | 2218232 | 2022-02-15 | Sheridan | Nebraska | 31161 | 967 | 23 |
2214405 | 2214405 | 2022-02-14 | Tensas | Louisiana | 22107 | 967 | 11 |
2214981 | 2214981 | 2022-02-14 | Sheridan | Nebraska | 31161 | 967 | 23 |
2211729 | 2211729 | 2022-02-13 | Sheridan | Nebraska | 31161 | 967 | 23 |
2211824 | 2211824 | 2022-02-13 | Union | New Mexico | 35059 | 967 | 12 |
2208476 | 2208476 | 2022-02-12 | Sheridan | Nebraska | 31161 | 967 | 23 |
2208571 | 2208571 | 2022-02-12 | Union | New Mexico | 35059 | 967 | 12 |
2205223 | 2205223 | 2022-02-11 | Sheridan | Nebraska | 31161 | 967 | 23 |
2205318 | 2205318 | 2022-02-11 | Union | New Mexico | 35059 | 967 | 12 |
2205501 | 2205501 | 2022-02-11 | LaMoure | North Dakota | 38045 | 967 | 19 |
2171507 | 2171507 | 2022-02-01 | Boise | Idaho | 16015 | 967 | 13 |
2168254 | 2168254 | 2022-01-31 | Boise | Idaho | 16015 | 967 | 13 |
2169748 | 2169748 | 2022-01-31 | Wells | North Dakota | 38103 | 967 | 11 |
2155306 | 2155306 | 2022-01-27 | Hardin | Illinois | 17069 | 967 | 18 |
2146953 | 2146953 | 2022-01-24 | Pierce | North Dakota | 38069 | 967 | 29 |
2143699 | 2143699 | 2022-01-23 | Pierce | North Dakota | 38069 | 967 | 29 |
2140444 | 2140444 | 2022-01-22 | Pierce | North Dakota | 38069 | 967 | 29 |
2123832 | 2123832 | 2022-01-17 | Dixon | Nebraska | 31051 | 967 | 11 |
2097493 | 2097493 | 2022-01-09 | Lincoln | Minnesota | 27081 | 967 | 5 |
2094241 | 2094241 | 2022-01-08 | Lincoln | Minnesota | 27081 | 967 | 5 |
2090989 | 2090989 | 2022-01-07 | Lincoln | Minnesota | 27081 | 967 | 5 |
2062080 | 2062080 | 2021-12-29 | Kearney | Nebraska | 31099 | 967 | 7 |
2054117 | 2054117 | 2021-12-27 | Clear Creek | Colorado | 8019 | 967 | 7 |
2053136 | 2053136 | 2021-12-26 | Tripp | South Dakota | 46123 | 967 | 21 |
2049886 | 2049886 | 2021-12-25 | Tripp | South Dakota | 46123 | 967 | 21 |
2046636 | 2046636 | 2021-12-24 | Tripp | South Dakota | 46123 | 967 | 21 |
2043386 | 2043386 | 2021-12-23 | Tripp | South Dakota | 46123 | 967 | 21 |
2028859 | 2028859 | 2021-12-19 | Washington | Kansas | 20201 | 967 | 17 |
2025608 | 2025608 | 2021-12-18 | Washington | Kansas | 20201 | 967 | 17 |
2022357 | 2022357 | 2021-12-17 | Washington | Kansas | 20201 | 967 | 17 |
2024146 | 2024146 | 2021-12-17 | McCulloch | Texas | 48307 | 967 | 40 |
2020895 | 2020895 | 2021-12-16 | McCulloch | Texas | 48307 | 967 | 39 |
2020911 | 2020911 | 2021-12-16 | Newton | Texas | 48351 | 967 | 54 |
2017644 | 2017644 | 2021-12-15 | McCulloch | Texas | 48307 | 967 | 39 |
2017660 | 2017660 | 2021-12-15 | Newton | Texas | 48351 | 967 | 54 |
2014286 | 2014286 | 2021-12-14 | Crane | Texas | 48103 | 967 | 19 |
2014394 | 2014394 | 2021-12-14 | McCulloch | Texas | 48307 | 967 | 39 |
2014410 | 2014410 | 2021-12-14 | Newton | Texas | 48351 | 967 | 54 |
2011035 | 2011035 | 2021-12-13 | Crane | Texas | 48103 | 967 | 19 |
2011143 | 2011143 | 2021-12-13 | McCulloch | Texas | 48307 | 967 | 39 |
2006936 | 2006936 | 2021-12-12 | Los Alamos | New Mexico | 35028 | 967 | 10 |
2007784 | 2007784 | 2021-12-12 | Crane | Texas | 48103 | 967 | 19 |
2003685 | 2003685 | 2021-12-11 | Los Alamos | New Mexico | 35028 | 967 | 10 |
2004533 | 2004533 | 2021-12-11 | Crane | Texas | 48103 | 967 | 19 |
2000435 | 2000435 | 2021-12-10 | Los Alamos | New Mexico | 35028 | 967 | 10 |
1998182 | 1998182 | 2021-12-09 | Sabine | Texas | 48403 | 967 | 77 |
1994931 | 1994931 | 2021-12-08 | Sabine | Texas | 48403 | 967 | 77 |
1951200 | 1951200 | 2021-11-25 | Grant | Minnesota | 27051 | 967 | 9 |
1947949 | 1947949 | 2021-11-24 | Grant | Minnesota | 27051 | 967 | 9 |
1946354 | 1946354 | 2021-11-23 | Middlesex | Virginia | 51119 | 967 | 33 |
1943103 | 1943103 | 2021-11-22 | Middlesex | Virginia | 51119 | 967 | 33 |
1938291 | 1938291 | 2021-11-21 | Jefferson | Mississippi | 28063 | 967 | 34 |
1935041 | 1935041 | 2021-11-20 | Jefferson | Mississippi | 28063 | 967 | 34 |
1931791 | 1931791 | 2021-11-19 | Jefferson | Mississippi | 28063 | 967 | 34 |
1929600 | 1929600 | 2021-11-18 | McCook | South Dakota | 46087 | 967 | 25 |
1915782 | 1915782 | 2021-11-14 | Clay | Nebraska | 31035 | 967 | 17 |
1912440 | 1912440 | 2021-11-13 | Shelby | Missouri | 29205 | 967 | 9 |
1912532 | 1912532 | 2021-11-13 | Clay | Nebraska | 31035 | 967 | 17 |
1909282 | 1909282 | 2021-11-12 | Clay | Nebraska | 31035 | 967 | 17 |
1904290 | 1904290 | 2021-11-10 | Menominee | Wisconsin | 55078 | 967 | 11 |
1897340 | 1897340 | 2021-11-08 | Jack | Texas | 48237 | 967 | 20 |
1894090 | 1894090 | 2021-11-07 | Jack | Texas | 48237 | 967 | 20 |
1890840 | 1890840 | 2021-11-06 | Jack | Texas | 48237 | 967 | 20 |
1846790 | 1846790 | 2021-10-24 | Greenwood | Kansas | 20073 | 967 | 14 |
1843540 | 1843540 | 2021-10-23 | Greenwood | Kansas | 20073 | 967 | 14 |
1840290 | 1840290 | 2021-10-22 | Greenwood | Kansas | 20073 | 967 | 14 |
1808463 | 1808463 | 2021-10-12 | Shannon | Missouri | 29203 | 967 | 17 |
1792182 | 1792182 | 2021-10-07 | Maries | Missouri | 29125 | 967 | 18 |
1780116 | 1780116 | 2021-10-03 | Hamlin | South Dakota | 46057 | 967 | 40 |
1776866 | 1776866 | 2021-10-02 | Hamlin | South Dakota | 46057 | 967 | 40 |
1772645 | 1772645 | 2021-10-01 | Clark | Missouri | 29045 | 967 | 12 |
1773616 | 1773616 | 2021-10-01 | Hamlin | South Dakota | 46057 | 967 | 40 |
1767146 | 1767146 | 2021-09-29 | Spink | South Dakota | 46115 | 967 | 26 |
1763897 | 1763897 | 2021-09-28 | Spink | South Dakota | 46115 | 967 | 26 |
1748135 | 1748135 | 2021-09-23 | Lunenburg | Virginia | 51111 | 967 | 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);