ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
311 rows where cases = 1773 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Texas 17
- Virginia 17
- Missouri 16
- Oklahoma 15
- Kansas 14
- Arkansas 13
- Illinois 13
- Puerto Rico 12
- Tennessee 11
- Colorado 10
- Indiana 10
- North Carolina 10
- California 9
- Kentucky 9
- Alabama 8
- Iowa 8
- Mississippi 7
- Nebraska 7
- Louisiana 6
- Pennsylvania 6
- Wisconsin 6
- Minnesota 5
- New York 5
- North Dakota 5
- Ohio 5
- Michigan 4
- South Carolina 4
- South Dakota 4
- Washington 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501322 | 2501322 | 2022-05-13 | Richardson | Nebraska | 31147 | 1773 | 24 |
2490230 | 2490230 | 2022-05-10 | Crawford | Georgia | 13079 | 1773 | 55 |
2486973 | 2486973 | 2022-05-09 | Crawford | Georgia | 13079 | 1773 | 55 |
2483715 | 2483715 | 2022-05-08 | Crawford | Georgia | 13079 | 1773 | 55 |
2480457 | 2480457 | 2022-05-07 | Crawford | Georgia | 13079 | 1773 | 55 |
2477199 | 2477199 | 2022-05-06 | Crawford | Georgia | 13079 | 1773 | 55 |
2473941 | 2473941 | 2022-05-05 | Crawford | Georgia | 13079 | 1773 | 55 |
2470684 | 2470684 | 2022-05-04 | Crawford | Georgia | 13079 | 1773 | 55 |
2453547 | 2453547 | 2022-04-28 | Refugio | Texas | 48391 | 1773 | 36 |
2450291 | 2450291 | 2022-04-27 | Refugio | Texas | 48391 | 1773 | 36 |
2417849 | 2417849 | 2022-04-17 | Bland | Virginia | 51021 | 1773 | 22 |
2414593 | 2414593 | 2022-04-16 | Bland | Virginia | 51021 | 1773 | 22 |
2411337 | 2411337 | 2022-04-15 | Bland | Virginia | 51021 | 1773 | 22 |
2287130 | 2287130 | 2022-03-08 | Hormigueros | Puerto Rico | 72067 | 1773 | |
2283878 | 2283878 | 2022-03-07 | Hormigueros | Puerto Rico | 72067 | 1773 | |
2280014 | 2280014 | 2022-03-06 | Thurston | Nebraska | 31173 | 1773 | 20 |
2276761 | 2276761 | 2022-03-05 | Thurston | Nebraska | 31173 | 1773 | 20 |
2273508 | 2273508 | 2022-03-04 | Thurston | Nebraska | 31173 | 1773 | 20 |
2262928 | 2262928 | 2022-03-01 | Greenwood | Kansas | 20073 | 1773 | 22 |
2259677 | 2259677 | 2022-02-28 | Greenwood | Kansas | 20073 | 1773 | 22 |
2224925 | 2224925 | 2022-02-17 | Gates | North Carolina | 37073 | 1773 | 19 |
2214768 | 2214768 | 2022-02-14 | Harrison | Missouri | 29081 | 1773 | 27 |
2212820 | 2212820 | 2022-02-13 | Stephens | Texas | 48429 | 1773 | 39 |
2137851 | 2137851 | 2022-01-21 | Floyd | Texas | 48153 | 1773 | 42 |
2133469 | 2133469 | 2022-01-20 | Oregon | Missouri | 29149 | 1773 | 27 |
2129984 | 2129984 | 2022-01-19 | Clearwater | Minnesota | 27029 | 1773 | 27 |
2107446 | 2107446 | 2022-01-12 | Monroe | Missouri | 29137 | 1773 | 37 |
2089784 | 2089784 | 2022-01-07 | Perry | Arkansas | 5105 | 1773 | 26 |
2083693 | 2083693 | 2022-01-05 | Clearwater | Idaho | 16035 | 1773 | 28 |
2080445 | 2080445 | 2022-01-04 | Fremont | Idaho | 16043 | 1773 | 20 |
2075290 | 2075290 | 2022-01-02 | Clay | North Carolina | 37043 | 1773 | 38 |
2072039 | 2072039 | 2022-01-01 | Clay | North Carolina | 37043 | 1773 | 38 |
2068788 | 2068788 | 2021-12-31 | Clay | North Carolina | 37043 | 1773 | 38 |
2018826 | 2018826 | 2021-12-16 | Crawford | Indiana | 18025 | 1773 | 30 |
2019108 | 2019108 | 2021-12-16 | Wilson | Kansas | 20205 | 1773 | 34 |
2015858 | 2015858 | 2021-12-15 | Wilson | Kansas | 20205 | 1773 | 34 |
2016445 | 2016445 | 2021-12-15 | Ralls | Missouri | 29173 | 1773 | 19 |
2012316 | 2012316 | 2021-12-14 | Benton | Indiana | 18007 | 1773 | 18 |
2009554 | 2009554 | 2021-12-13 | Piscataquis | Maine | 23021 | 1773 | 14 |
2009780 | 2009780 | 2021-12-13 | Carroll | Mississippi | 28015 | 1773 | 41 |
2006303 | 2006303 | 2021-12-12 | Piscataquis | Maine | 23021 | 1773 | 14 |
2003052 | 2003052 | 2021-12-11 | Piscataquis | Maine | 23021 | 1773 | 14 |
1995519 | 1995519 | 2021-12-09 | Pike | Arkansas | 5109 | 1773 | 38 |
1965278 | 1965278 | 2021-11-29 | Calhoun | South Carolina | 45017 | 1773 | 53 |
1946661 | 1946661 | 2021-11-24 | Wilcox | Alabama | 1131 | 1773 | 38 |
1928851 | 1928851 | 2021-11-18 | Unknown | Nebraska | 1773 | 200 | |
1924324 | 1924324 | 2021-11-17 | Long | Georgia | 13183 | 1773 | 26 |
1921075 | 1921075 | 2021-11-16 | Long | Georgia | 13183 | 1773 | 26 |
1917825 | 1917825 | 2021-11-15 | Long | Georgia | 13183 | 1773 | 26 |
1919715 | 1919715 | 2021-11-15 | Juana Diaz | Puerto Rico | 72075 | 1773 | |
1897754 | 1897754 | 2021-11-08 | Bayfield | Wisconsin | 55007 | 1773 | 25 |
1893251 | 1893251 | 2021-11-07 | Yates | New York | 36123 | 1773 | 30 |
1881639 | 1881639 | 2021-11-04 | Lowndes | Alabama | 1085 | 1773 | 65 |
1872379 | 1872379 | 2021-11-01 | Towns | Georgia | 13281 | 1773 | 82 |
1866858 | 1866858 | 2021-10-30 | Bollinger | Missouri | 29017 | 1773 | 20 |
1858938 | 1858938 | 2021-10-28 | Northwest Arctic Borough | Alaska | 2188 | 1773 | 7 |
1834362 | 1834362 | 2021-10-20 | Barton | Missouri | 29011 | 1773 | 27 |
1828368 | 1828368 | 2021-10-18 | Barnes | North Dakota | 38003 | 1773 | 33 |
1825583 | 1825583 | 2021-10-17 | Butte | South Dakota | 46019 | 1773 | 27 |
1822208 | 1822208 | 2021-10-16 | Camuy | Puerto Rico | 72027 | 1773 | |
1822334 | 1822334 | 2021-10-16 | Butte | South Dakota | 46019 | 1773 | 27 |
1818959 | 1818959 | 2021-10-15 | Camuy | Puerto Rico | 72027 | 1773 | |
1819085 | 1819085 | 2021-10-15 | Butte | South Dakota | 46019 | 1773 | 27 |
1813384 | 1813384 | 2021-10-14 | Coosa | Alabama | 1037 | 1773 | 38 |
1815682 | 1815682 | 2021-10-14 | Potter | Pennsylvania | 42105 | 1773 | 35 |
1811251 | 1811251 | 2021-10-13 | Catahoula | Louisiana | 22025 | 1773 | 48 |
1808002 | 1808002 | 2021-10-12 | Catahoula | Louisiana | 22025 | 1773 | 48 |
1787659 | 1787659 | 2021-10-06 | Moffat | Colorado | 8081 | 1773 | 32 |
1777825 | 1777825 | 2021-10-03 | Inyo | California | 6027 | 1773 | 39 |
1774575 | 1774575 | 2021-10-02 | Inyo | California | 6027 | 1773 | 39 |
1771325 | 1771325 | 2021-10-01 | Inyo | California | 6027 | 1773 | 39 |
1770446 | 1770446 | 2021-09-30 | Houston | Tennessee | 47083 | 1773 | 41 |
1741555 | 1741555 | 2021-09-21 | Orleans | Vermont | 50019 | 1773 | 13 |
1733370 | 1733370 | 2021-09-19 | Dukes | Massachusetts | 25007 | 1773 | 0 |
1730120 | 1730120 | 2021-09-18 | Dukes | Massachusetts | 25007 | 1773 | 0 |
1726870 | 1726870 | 2021-09-17 | Dukes | Massachusetts | 25007 | 1773 | 0 |
1724021 | 1724021 | 2021-09-16 | Glacier | Montana | 30035 | 1773 | 45 |
1725408 | 1725408 | 2021-09-16 | Patrick | Virginia | 51141 | 1773 | 47 |
1712916 | 1712916 | 2021-09-13 | Grand | Colorado | 8049 | 1773 | 8 |
1712007 | 1712007 | 2021-09-12 | Stewart | Tennessee | 47161 | 1773 | 28 |
1708760 | 1708760 | 2021-09-11 | Stewart | Tennessee | 47161 | 1773 | 28 |
1705513 | 1705513 | 2021-09-10 | Stewart | Tennessee | 47161 | 1773 | 28 |
1679250 | 1679250 | 2021-09-02 | Barranquitas | Puerto Rico | 72019 | 1773 | |
1674909 | 1674909 | 2021-09-01 | Antrim | Michigan | 26009 | 1773 | 33 |
1676811 | 1676811 | 2021-09-01 | Wetzel | West Virginia | 54103 | 1773 | 34 |
1667666 | 1667666 | 2021-08-30 | Oglethorpe | Georgia | 13221 | 1773 | 32 |
1669518 | 1669518 | 2021-08-30 | Cidra | Puerto Rico | 72041 | 1773 | |
1664988 | 1664988 | 2021-08-29 | Lewis | Kentucky | 21135 | 1773 | 47 |
1665960 | 1665960 | 2021-08-29 | Ramsey | North Dakota | 38071 | 1773 | 30 |
1661740 | 1661740 | 2021-08-28 | Lewis | Kentucky | 21135 | 1773 | 47 |
1662533 | 1662533 | 2021-08-28 | Essex | New York | 36031 | 1773 | 26 |
1658492 | 1658492 | 2021-08-27 | Lewis | Kentucky | 21135 | 1773 | 47 |
1643758 | 1643758 | 2021-08-22 | Lake | Tennessee | 47095 | 1773 | 31 |
1640508 | 1640508 | 2021-08-21 | Lake | Tennessee | 47095 | 1773 | 31 |
1634864 | 1634864 | 2021-08-20 | Van Buren | Arkansas | 5141 | 1773 | 34 |
1636185 | 1636185 | 2021-08-20 | Bates | Missouri | 29013 | 1773 | 34 |
1637258 | 1637258 | 2021-08-20 | Lake | Tennessee | 47095 | 1773 | 31 |
1631552 | 1631552 | 2021-08-19 | Chicot | Arkansas | 5017 | 1773 | 42 |
1586859 | 1586859 | 2021-08-05 | Bourbon | Kansas | 20011 | 1773 | 29 |
1583609 | 1583609 | 2021-08-04 | Bourbon | Kansas | 20011 | 1773 | 29 |
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);