ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6280 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Indiana 7
- Louisiana 7
- Ohio 5
- Florida 4
- Tennessee 4
- Kansas 3
- Michigan 3
- Nebraska 3
- New York 3
- Texas 3
- Alabama 2
- Kentucky 2
- North Carolina 2
- Virginia 2
- Colorado 1
- Georgia 1
- Idaho 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Montana 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- South Dakota 1
- Utah 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488947 | 2488947 | 2022-05-09 | San Lorenzo | Puerto Rico | 72129 | 6280 | |
2468161 | 2468161 | 2022-05-03 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2464906 | 2464906 | 2022-05-02 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2461650 | 2461650 | 2022-05-01 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2458394 | 2458394 | 2022-04-30 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2455138 | 2455138 | 2022-04-29 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2451882 | 2451882 | 2022-04-28 | Pointe Coupee | Louisiana | 22077 | 6280 | 93 |
2313837 | 2313837 | 2022-03-16 | Winchester city | Virginia | 51840 | 6280 | 76 |
2265763 | 2265763 | 2022-03-02 | Stephens | Georgia | 13257 | 6280 | 138 |
2213106 | 2213106 | 2022-02-13 | Mason | West Virginia | 54053 | 6280 | 86 |
2171528 | 2171528 | 2022-02-01 | Latah | Idaho | 16057 | 6280 | 45 |
2160626 | 2160626 | 2022-01-28 | Fannin | Texas | 48147 | 6280 | 162 |
2101844 | 2101844 | 2022-01-10 | Brookings | South Dakota | 46011 | 6280 | 41 |
2075687 | 2075687 | 2022-01-02 | Tioga | Pennsylvania | 42117 | 6280 | 172 |
2062462 | 2062462 | 2021-12-29 | Jackson | Ohio | 39079 | 6280 | 108 |
2055725 | 2055725 | 2021-12-27 | Franklin | New York | 36033 | 6280 | 29 |
1993764 | 1993764 | 2021-12-08 | Silver Bow | Montana | 30093 | 6280 | 113 |
1990711 | 1990711 | 2021-12-07 | Cortland | New York | 36023 | 6280 | 89 |
1958246 | 1958246 | 2021-11-27 | Tioga | New York | 36107 | 6280 | 73 |
1937625 | 1937625 | 2021-11-21 | Steuben | Indiana | 18151 | 6280 | 86 |
1934375 | 1934375 | 2021-11-20 | Steuben | Indiana | 18151 | 6280 | 86 |
1931124 | 1931124 | 2021-11-19 | Steuben | Indiana | 18151 | 6280 | 86 |
1915791 | 1915791 | 2021-11-14 | Dodge | Nebraska | 31053 | 6280 | 83 |
1912541 | 1912541 | 2021-11-13 | Dodge | Nebraska | 31053 | 6280 | 83 |
1909291 | 1909291 | 2021-11-12 | Dodge | Nebraska | 31053 | 6280 | 83 |
1896704 | 1896704 | 2021-11-08 | Logan | Ohio | 39091 | 6280 | 103 |
1830329 | 1830329 | 2021-10-19 | DeKalb | Indiana | 18033 | 6280 | 102 |
1829217 | 1829217 | 2021-10-18 | Uvalde | Texas | 48463 | 6280 | 105 |
1825181 | 1825181 | 2021-10-17 | Brown | Ohio | 39015 | 6280 | 82 |
1810856 | 1810856 | 2021-10-13 | Huntington | Indiana | 18069 | 6280 | 101 |
1791357 | 1791357 | 2021-10-07 | Harrison | Indiana | 18061 | 6280 | 93 |
1738647 | 1738647 | 2021-09-21 | Chilton | Alabama | 1021 | 6280 | 137 |
1725289 | 1725289 | 2021-09-16 | Summit | Utah | 49043 | 6280 | 16 |
1625675 | 1625675 | 2021-08-17 | Henry | Indiana | 18065 | 6280 | 114 |
1554640 | 1554640 | 2021-07-26 | St. Charles | Louisiana | 22089 | 6280 | 99 |
1493739 | 1493739 | 2021-07-07 | Lenoir | North Carolina | 37107 | 6280 | 124 |
1393735 | 1393735 | 2021-06-06 | Jefferson | Tennessee | 47089 | 6280 | 125 |
1390490 | 1390490 | 2021-06-05 | Jefferson | Tennessee | 47089 | 6280 | 125 |
1387245 | 1387245 | 2021-06-04 | Jefferson | Tennessee | 47089 | 6280 | 125 |
1361280 | 1361280 | 2021-05-27 | Jefferson | Tennessee | 47089 | 6280 | 125 |
1352570 | 1352570 | 2021-05-25 | Jackson | Florida | 12063 | 6280 | 158 |
1353495 | 1353495 | 2021-05-25 | Isabella | Michigan | 26073 | 6280 | 94 |
1320015 | 1320015 | 2021-05-15 | Fremont | Colorado | 8043 | 6280 | 57 |
1301538 | 1301538 | 2021-05-09 | Grand Traverse | Michigan | 26055 | 6280 | 93 |
1298290 | 1298290 | 2021-05-08 | Grand Traverse | Michigan | 26055 | 6280 | 93 |
1224474 | 1224474 | 2021-04-15 | Scioto | Ohio | 39145 | 6280 | 100 |
1220173 | 1220173 | 2021-04-14 | McCracken | Kentucky | 21145 | 6280 | 119 |
1150678 | 1150678 | 2021-03-23 | Rockingham | Virginia | 51165 | 6280 | 102 |
1122009 | 1122009 | 2021-03-15 | Flagler | Florida | 12035 | 6280 | 94 |
1051274 | 1051274 | 2021-02-21 | Bullitt | Kentucky | 21029 | 6280 | 47 |
1004343 | 1004343 | 2021-02-06 | Liberty | Texas | 48291 | 6280 | 142 |
971197 | 971197 | 2021-01-27 | Erie | Ohio | 39043 | 6280 | 130 |
948622 | 948622 | 2021-01-20 | Wagoner | Oklahoma | 40145 | 6280 | 63 |
899061 | 899061 | 2021-01-05 | Clay | Minnesota | 27027 | 6280 | 78 |
871816 | 871816 | 2020-12-28 | St. Clair | Alabama | 1115 | 6280 | 71 |
802309 | 802309 | 2020-12-06 | Iredell | North Carolina | 37097 | 6280 | 56 |
785654 | 785654 | 2020-12-01 | Cole | Missouri | 29051 | 6280 | 60 |
664471 | 664471 | 2020-10-25 | St. Johns | Florida | 12109 | 6280 | 80 |
506306 | 506306 | 2020-09-06 | Wyandotte | Kansas | 20209 | 6280 | 117 |
503072 | 503072 | 2020-09-05 | Wyandotte | Kansas | 20209 | 6280 | 117 |
499839 | 499839 | 2020-09-04 | Wyandotte | Kansas | 20209 | 6280 | 117 |
344586 | 344586 | 2020-07-18 | Manatee | Florida | 12081 | 6280 | 143 |
110756 | 110756 | 2020-05-03 | Norfolk | Massachusetts | 25021 | 6280 | 550 |
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);