ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 5764 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Mississippi 8
- Georgia 7
- Wisconsin 7
- Alabama 5
- Florida 5
- Indiana 5
- Kentucky 5
- New York 4
- South Carolina 4
- Washington 4
- Missouri 3
- Puerto Rico 3
- Virginia 3
- Arkansas 2
- Kansas 2
- Ohio 2
- Texas 2
- West Virginia 2
- California 1
- Idaho 1
- Louisiana 1
- Michigan 1
- North Carolina 1
- North Dakota 1
- Oklahoma 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396854 | 2396854 | 2022-04-11 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2393599 | 2393599 | 2022-04-10 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2390343 | 2390343 | 2022-04-09 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2387087 | 2387087 | 2022-04-08 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2383832 | 2383832 | 2022-04-07 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2380577 | 2380577 | 2022-04-06 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2377322 | 2377322 | 2022-04-05 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2374070 | 2374070 | 2022-04-04 | Sunflower | Mississippi | 28133 | 5764 | 124 |
2334053 | 2334053 | 2022-03-23 | Pierce | Georgia | 13229 | 5764 | 129 |
2223747 | 2223747 | 2022-02-17 | Owen | Indiana | 18119 | 5764 | 111 |
2218861 | 2218861 | 2022-02-15 | Manati | Puerto Rico | 72091 | 5764 | |
2212359 | 2212359 | 2022-02-13 | Manati | Puerto Rico | 72091 | 5764 | |
2192368 | 2192368 | 2022-02-07 | Ashe | North Carolina | 37009 | 5764 | 67 |
2187996 | 2187996 | 2022-02-06 | Washington | Indiana | 18175 | 5764 | 75 |
2184743 | 2184743 | 2022-02-05 | Washington | Indiana | 18175 | 5764 | 75 |
2181491 | 2181491 | 2022-02-04 | Washington | Indiana | 18175 | 5764 | 75 |
2166037 | 2166037 | 2022-01-30 | Stoddard | Missouri | 29207 | 5764 | 112 |
2144701 | 2144701 | 2022-01-23 | Salem city | Virginia | 51775 | 5764 | 85 |
2141446 | 2141446 | 2022-01-22 | Salem city | Virginia | 51775 | 5764 | 85 |
2138190 | 2138190 | 2022-01-21 | Salem city | Virginia | 51775 | 5764 | 85 |
2134579 | 2134579 | 2022-01-20 | DeWitt | Texas | 48123 | 5764 | 86 |
2128707 | 2128707 | 2022-01-19 | Winston | Alabama | 1133 | 5764 | 114 |
2126536 | 2126536 | 2022-01-18 | Jefferson Davis | Louisiana | 22053 | 5764 | 133 |
2089666 | 2089666 | 2022-01-07 | Marion | Alabama | 1093 | 5764 | 132 |
2030325 | 2030325 | 2021-12-19 | Williamsburg | South Carolina | 45089 | 5764 | 129 |
2027074 | 2027074 | 2021-12-18 | Williamsburg | South Carolina | 45089 | 5764 | 129 |
2023823 | 2023823 | 2021-12-17 | Williamsburg | South Carolina | 45089 | 5764 | 129 |
2015564 | 2015564 | 2021-12-15 | Adams | Indiana | 18001 | 5764 | 86 |
2015871 | 2015871 | 2021-12-15 | Boyle | Kentucky | 21021 | 5764 | 109 |
2009909 | 2009909 | 2021-12-13 | Laclede | Missouri | 29105 | 5764 | 149 |
1916495 | 1916495 | 2021-11-14 | Toa Alta | Puerto Rico | 72135 | 5764 | |
1832707 | 1832707 | 2021-10-19 | Whitman | Washington | 53075 | 5764 | 71 |
1803476 | 1803476 | 2021-10-10 | Fayette | West Virginia | 54019 | 5764 | 110 |
1790505 | 1790505 | 2021-10-06 | Ohio | West Virginia | 54069 | 5764 | 98 |
1739200 | 1739200 | 2021-09-21 | Bingham | Idaho | 16011 | 5764 | 87 |
1724448 | 1724448 | 2021-09-16 | Williams | North Dakota | 38105 | 5764 | 42 |
1698985 | 1698985 | 2021-09-08 | Lincoln | Tennessee | 47103 | 5764 | 75 |
1693562 | 1693562 | 2021-09-07 | Bryan | Georgia | 13029 | 5764 | 45 |
1685274 | 1685274 | 2021-09-04 | Genesee | New York | 36037 | 5764 | 125 |
1672843 | 1672843 | 2021-08-31 | Chesterfield | South Carolina | 45025 | 5764 | 118 |
1573385 | 1573385 | 2021-08-01 | Coffee | Georgia | 13069 | 5764 | 182 |
1570137 | 1570137 | 2021-07-31 | Coffee | Georgia | 13069 | 5764 | 182 |
1566889 | 1566889 | 2021-07-30 | Coffee | Georgia | 13069 | 5764 | 182 |
1562869 | 1562869 | 2021-07-28 | Summit | Utah | 49043 | 5764 | 15 |
1545583 | 1545583 | 2021-07-23 | Cattaraugus | New York | 36009 | 5764 | 92 |
1511277 | 1511277 | 2021-07-13 | Coffee | Alabama | 1031 | 5764 | 130 |
1508030 | 1508030 | 2021-07-12 | Coffee | Alabama | 1031 | 5764 | 130 |
1490639 | 1490639 | 2021-07-06 | Lawrence | Ohio | 39087 | 5764 | 103 |
1491709 | 1491709 | 2021-07-06 | Grant | Wisconsin | 55043 | 5764 | 94 |
1488462 | 1488462 | 2021-07-05 | Grant | Wisconsin | 55043 | 5764 | 94 |
1485215 | 1485215 | 2021-07-04 | Grant | Wisconsin | 55043 | 5764 | 94 |
1481969 | 1481969 | 2021-07-03 | Grant | Wisconsin | 55043 | 5764 | 94 |
1478722 | 1478722 | 2021-07-02 | Grant | Wisconsin | 55043 | 5764 | 94 |
1467066 | 1467066 | 2021-06-29 | Branch | Michigan | 26023 | 5764 | 121 |
1460893 | 1460893 | 2021-06-27 | Newton | Missouri | 29145 | 5764 | 80 |
1396311 | 1396311 | 2021-06-07 | Wayne | New York | 36117 | 5764 | 69 |
1372034 | 1372034 | 2021-05-31 | Gadsden | Florida | 12039 | 5764 | 100 |
1368789 | 1368789 | 2021-05-30 | Gadsden | Florida | 12039 | 5764 | 100 |
1365543 | 1365543 | 2021-05-29 | Gadsden | Florida | 12039 | 5764 | 100 |
1362297 | 1362297 | 2021-05-28 | Gadsden | Florida | 12039 | 5764 | 100 |
1353141 | 1353141 | 2021-05-25 | Ford | Kansas | 20057 | 5764 | 75 |
1349895 | 1349895 | 2021-05-24 | Ford | Kansas | 20057 | 5764 | 75 |
1193265 | 1193265 | 2021-04-06 | Mississippi | Arkansas | 5093 | 5764 | 106 |
1190015 | 1190015 | 2021-04-05 | Mississippi | Arkansas | 5093 | 5764 | 106 |
1074079 | 1074079 | 2021-02-28 | Pulaski | Kentucky | 21199 | 5764 | 87 |
1070812 | 1070812 | 2021-02-27 | McCracken | Kentucky | 21145 | 5764 | 69 |
1070833 | 1070833 | 2021-02-27 | Pulaski | Kentucky | 21199 | 5764 | 87 |
1071611 | 1071611 | 2021-02-27 | Ontario | New York | 36069 | 5764 | 88 |
1008420 | 1008420 | 2021-02-08 | Jackson | Florida | 12063 | 5764 | 134 |
985856 | 985856 | 2021-02-01 | Rockdale | Georgia | 13247 | 5764 | 112 |
981018 | 981018 | 2021-01-30 | Creek | Oklahoma | 40037 | 5764 | 92 |
927947 | 927947 | 2021-01-14 | Campbell | Kentucky | 21037 | 5764 | 38 |
865222 | 865222 | 2020-12-25 | Portage | Wisconsin | 55097 | 5764 | 50 |
861612 | 861612 | 2020-12-24 | Starr | Texas | 48427 | 5764 | 199 |
820059 | 820059 | 2020-12-12 | Santa Cruz | California | 6087 | 5764 | 53 |
773234 | 773234 | 2020-11-27 | Fairfield | Ohio | 39045 | 5764 | 64 |
741948 | 741948 | 2020-11-18 | Calhoun | Alabama | 1015 | 5764 | 95 |
699581 | 699581 | 2020-11-04 | Benton | Washington | 53005 | 5764 | 139 |
602412 | 602412 | 2020-10-05 | Racine | Wisconsin | 55101 | 5764 | 98 |
524556 | 524556 | 2020-09-11 | Spokane | Washington | 53063 | 5764 | 146 |
521320 | 521320 | 2020-09-10 | Spokane | Washington | 53063 | 5764 | 145 |
418532 | 418532 | 2020-08-10 | Chatham | Georgia | 13051 | 5764 | 75 |
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);