ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
399 rows where cases = 1214 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 44
- Virginia 25
- Kentucky 23
- Puerto Rico 19
- North Carolina 18
- Kansas 17
- Missouri 17
- Minnesota 16
- Montana 16
- Mississippi 15
- Idaho 13
- Georgia 12
- Indiana 10
- Oklahoma 10
- Tennessee 10
- West Virginia 10
- South Dakota 8
- Alabama 6
- Arkansas 6
- California 6
- Colorado 6
- Illinois 6
- Iowa 6
- Nebraska 6
- Wisconsin 6
- Florida 5
- Michigan 5
- New York 5
- Ohio 5
- Pennsylvania 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416274 | 2416274 | 2022-04-17 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2413018 | 2413018 | 2022-04-16 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2409762 | 2409762 | 2022-04-15 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2287677 | 2287677 | 2022-03-08 | Essex | Vermont | 50009 | 1214 | 3 |
2284425 | 2284425 | 2022-03-07 | Essex | Vermont | 50009 | 1214 | 3 |
2201884 | 2201884 | 2022-02-10 | Toole | Montana | 30101 | 1214 | 22 |
2202931 | 2202931 | 2022-02-10 | Garza | Texas | 48169 | 1214 | 26 |
2203048 | 2203048 | 2022-02-10 | Sabine | Texas | 48403 | 1214 | 79 |
2181286 | 2181286 | 2022-02-04 | Lemhi | Idaho | 16059 | 1214 | 25 |
2175420 | 2175420 | 2022-02-02 | Unknown | Maryland | 1214 | 202 | |
2165120 | 2165120 | 2022-01-30 | Scott | Illinois | 17171 | 1214 | 10 |
2161865 | 2161865 | 2022-01-29 | Scott | Illinois | 17171 | 1214 | 10 |
2158610 | 2158610 | 2022-01-28 | Scott | Illinois | 17171 | 1214 | 10 |
2149261 | 2149261 | 2022-01-25 | Owsley | Kentucky | 21189 | 1214 | 23 |
2150213 | 2150213 | 2022-01-25 | Sioux | North Dakota | 38085 | 1214 | 19 |
2105276 | 2105276 | 2022-01-11 | Brooks | Texas | 48047 | 1214 | 48 |
2101097 | 2101097 | 2022-01-10 | Keith | Nebraska | 31101 | 1214 | 12 |
2099092 | 2099092 | 2022-01-09 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2095841 | 2095841 | 2022-01-08 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2091216 | 2091216 | 2022-01-07 | Shannon | Missouri | 29203 | 1214 | 30 |
2091631 | 2091631 | 2022-01-07 | Bottineau | North Dakota | 38009 | 1214 | 24 |
2092589 | 2092589 | 2022-01-07 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2088148 | 2088148 | 2022-01-06 | Pershing | Nevada | 32027 | 1214 | 29 |
2084896 | 2084896 | 2022-01-05 | Pershing | Nevada | 32027 | 1214 | 29 |
2085485 | 2085485 | 2022-01-05 | Hormigueros | Puerto Rico | 72067 | 1214 | |
2081644 | 2081644 | 2022-01-04 | Pershing | Nevada | 32027 | 1214 | 29 |
2079105 | 2079105 | 2022-01-03 | Hamlin | South Dakota | 46057 | 1214 | 40 |
2063466 | 2063466 | 2021-12-29 | Calhoun | West Virginia | 54013 | 1214 | 9 |
2022880 | 2022880 | 2021-12-17 | Clark | Missouri | 29045 | 1214 | 28 |
2017739 | 2017739 | 2021-12-15 | Beaver | Utah | 49001 | 1214 | 14 |
1995104 | 1995104 | 2021-12-08 | Lunenburg | Virginia | 51111 | 1214 | 23 |
1991194 | 1991194 | 2021-12-07 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1987943 | 1987943 | 2021-12-06 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1984693 | 1984693 | 2021-12-05 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1975098 | 1975098 | 2021-12-02 | Hutchinson | South Dakota | 46067 | 1214 | 28 |
1972409 | 1972409 | 2021-12-01 | Williamsburg city | Virginia | 51830 | 1214 | 13 |
1966583 | 1966583 | 2021-11-30 | Lincoln | Georgia | 13181 | 1214 | 33 |
1956510 | 1956510 | 2021-11-27 | Newton | Arkansas | 5101 | 1214 | 39 |
1946422 | 1946422 | 2021-11-23 | Jefferson | Washington | 53031 | 1214 | 17 |
1928633 | 1928633 | 2021-11-18 | Hickory | Missouri | 29085 | 1214 | 43 |
1930239 | 1930239 | 2021-11-18 | Tucker | West Virginia | 54093 | 1214 | 30 |
1898938 | 1898938 | 2021-11-09 | Nicholas | Kentucky | 21181 | 1214 | 19 |
1897746 | 1897746 | 2021-11-08 | Webster | West Virginia | 54101 | 1214 | 19 |
1882541 | 1882541 | 2021-11-04 | Kingman | Kansas | 20095 | 1214 | 21 |
1879292 | 1879292 | 2021-11-03 | Kingman | Kansas | 20095 | 1214 | 21 |
1873284 | 1873284 | 2021-11-01 | Franklin | Mississippi | 28037 | 1214 | 28 |
1874412 | 1874412 | 2021-11-01 | Hancock | Tennessee | 47067 | 1214 | 20 |
1870035 | 1870035 | 2021-10-31 | Franklin | Mississippi | 28037 | 1214 | 28 |
1871163 | 1871163 | 2021-10-31 | Hancock | Tennessee | 47067 | 1214 | 20 |
1866786 | 1866786 | 2021-10-30 | Franklin | Mississippi | 28037 | 1214 | 28 |
1867914 | 1867914 | 2021-10-30 | Hancock | Tennessee | 47067 | 1214 | 20 |
1863537 | 1863537 | 2021-10-29 | Franklin | Mississippi | 28037 | 1214 | 28 |
1864665 | 1864665 | 2021-10-29 | Hancock | Tennessee | 47067 | 1214 | 20 |
1855228 | 1855228 | 2021-10-26 | Winkler | Texas | 48495 | 1214 | 28 |
1855370 | 1855370 | 2021-10-26 | Northumberland | Virginia | 51133 | 1214 | 30 |
1852121 | 1852121 | 2021-10-25 | Northumberland | Virginia | 51133 | 1214 | 30 |
1846347 | 1846347 | 2021-10-24 | Miller | Georgia | 13201 | 1214 | 22 |
1846647 | 1846647 | 2021-10-24 | Warren | Indiana | 18171 | 1214 | 18 |
1843097 | 1843097 | 2021-10-23 | Miller | Georgia | 13201 | 1214 | 22 |
1843397 | 1843397 | 2021-10-23 | Warren | Indiana | 18171 | 1214 | 18 |
1839847 | 1839847 | 2021-10-22 | Miller | Georgia | 13201 | 1214 | 22 |
1840147 | 1840147 | 2021-10-22 | Warren | Indiana | 18171 | 1214 | 18 |
1834620 | 1834620 | 2021-10-20 | Wayne | Nebraska | 31179 | 1214 | 8 |
1827401 | 1827401 | 2021-10-18 | Gallatin | Kentucky | 21077 | 1214 | 39 |
1791152 | 1791152 | 2021-10-07 | Treutlen | Georgia | 13283 | 1214 | 45 |
1789426 | 1789426 | 2021-10-06 | Traill | North Dakota | 38097 | 1214 | 18 |
1772723 | 1772723 | 2021-10-01 | St. Clair | Missouri | 29185 | 1214 | 14 |
1764909 | 1764909 | 2021-09-29 | Lincoln | Colorado | 8073 | 1214 | 6 |
1764387 | 1764387 | 2021-09-28 | Nelson | Virginia | 51125 | 1214 | 16 |
1758161 | 1758161 | 2021-09-27 | Greene | Alabama | 1063 | 1214 | 43 |
1754913 | 1754913 | 2021-09-26 | Greene | Alabama | 1063 | 1214 | 43 |
1757258 | 1757258 | 2021-09-26 | Luquillo | Puerto Rico | 72089 | 1214 | |
1743829 | 1743829 | 2021-09-22 | Graham | North Carolina | 37075 | 1214 | 22 |
1720173 | 1720173 | 2021-09-15 | Elliott | Kentucky | 21063 | 1214 | 2 |
1688084 | 1688084 | 2021-09-05 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1684834 | 1684834 | 2021-09-04 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1681583 | 1681583 | 2021-09-03 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1679820 | 1679820 | 2021-09-02 | Caledonia | Vermont | 50005 | 1214 | 8 |
1667877 | 1667877 | 2021-08-30 | Brown | Indiana | 18013 | 1214 | 45 |
1670018 | 1670018 | 2021-08-30 | Trinity | Texas | 48455 | 1214 | 37 |
1665307 | 1665307 | 2021-08-29 | Pope | Minnesota | 27121 | 1214 | 8 |
1666771 | 1666771 | 2021-08-29 | Trinity | Texas | 48455 | 1214 | 37 |
1662059 | 1662059 | 2021-08-28 | Pope | Minnesota | 27121 | 1214 | 8 |
1658811 | 1658811 | 2021-08-27 | Pope | Minnesota | 27121 | 1214 | 8 |
1632007 | 1632007 | 2021-08-19 | Clearwater | Idaho | 16035 | 1214 | 16 |
1633057 | 1633057 | 2021-08-19 | Deer Lodge | Montana | 30023 | 1214 | 18 |
1630158 | 1630158 | 2021-08-18 | Pamlico | North Carolina | 37137 | 1214 | 14 |
1623595 | 1623595 | 2021-08-16 | Yates | New York | 36123 | 1214 | 26 |
1609016 | 1609016 | 2021-08-12 | Unknown | Connecticut | 1214 | 1 | |
1592620 | 1592620 | 2021-08-07 | Pike | Arkansas | 5109 | 1214 | 24 |
1588311 | 1588311 | 2021-08-05 | Coamo | Puerto Rico | 72043 | 1214 | |
1577831 | 1577831 | 2021-08-02 | Custer | Montana | 30017 | 1214 | 18 |
1573247 | 1573247 | 2021-08-01 | Moffat | Colorado | 8081 | 1214 | 27 |
1574497 | 1574497 | 2021-08-01 | Grundy | Missouri | 29079 | 1214 | 36 |
1574583 | 1574583 | 2021-08-01 | Custer | Montana | 30017 | 1214 | 18 |
1569999 | 1569999 | 2021-07-31 | Moffat | Colorado | 8081 | 1214 | 27 |
1571249 | 1571249 | 2021-07-31 | Grundy | Missouri | 29079 | 1214 | 36 |
1571335 | 1571335 | 2021-07-31 | Custer | Montana | 30017 | 1214 | 18 |
1566751 | 1566751 | 2021-07-30 | Moffat | Colorado | 8081 | 1214 | 27 |
1568087 | 1568087 | 2021-07-30 | Custer | Montana | 30017 | 1214 | 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);