ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 9596 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499731 | 2499731 | 2022-05-13 | Miller | Arkansas | 5091 | 9596 | 181 |
2470925 | 2470925 | 2022-05-04 | Morgan | Illinois | 17137 | 9596 | 144 |
2431056 | 2431056 | 2022-04-21 | Logan | West Virginia | 54045 | 9596 | 183 |
2417772 | 2417772 | 2022-04-17 | Waller | Texas | 48473 | 9596 | 107 |
2414516 | 2414516 | 2022-04-16 | Waller | Texas | 48473 | 9596 | 107 |
2411260 | 2411260 | 2022-04-15 | Waller | Texas | 48473 | 9596 | 107 |
2408004 | 2408004 | 2022-04-14 | Waller | Texas | 48473 | 9596 | 107 |
2236783 | 2236783 | 2022-02-21 | Whitley | Indiana | 18183 | 9596 | 80 |
2195220 | 2195220 | 2022-02-08 | Butler | Missouri | 29023 | 9596 | 147 |
2182279 | 2182279 | 2022-02-04 | Phelps | Missouri | 29161 | 9596 | 216 |
2178804 | 2178804 | 2022-02-03 | Isanti | Minnesota | 27059 | 9596 | 109 |
2167715 | 2167715 | 2022-01-31 | Escambia | Alabama | 1053 | 9596 | 152 |
2165707 | 2165707 | 2022-01-30 | Hillsdale | Michigan | 26059 | 9596 | 180 |
2162452 | 2162452 | 2022-01-29 | Hillsdale | Michigan | 26059 | 9596 | 180 |
2159197 | 2159197 | 2022-01-28 | Hillsdale | Michigan | 26059 | 9596 | 180 |
2097296 | 2097296 | 2022-01-09 | St. Martin | Louisiana | 22099 | 9596 | 163 |
2094044 | 2094044 | 2022-01-08 | St. Martin | Louisiana | 22099 | 9596 | 163 |
2090792 | 2090792 | 2022-01-07 | St. Martin | Louisiana | 22099 | 9596 | 163 |
2084900 | 2084900 | 2022-01-05 | Belknap | New Hampshire | 33001 | 9596 | 149 |
2085265 | 2085265 | 2022-01-05 | Washington | Ohio | 39167 | 9596 | 168 |
2085771 | 2085771 | 2022-01-05 | Caldwell | Texas | 48055 | 9596 | 158 |
2057588 | 2057588 | 2021-12-28 | Laurens | Georgia | 13175 | 9596 | 258 |
2057744 | 2057744 | 2021-12-28 | Grundy | Illinois | 17063 | 9596 | 104 |
2017476 | 2017476 | 2021-12-15 | Unknown | Tennessee | 9596 | 145 | |
1938116 | 1938116 | 2021-11-21 | Gratiot | Michigan | 26057 | 9596 | 141 |
1934866 | 1934866 | 2021-11-20 | Gratiot | Michigan | 26057 | 9596 | 141 |
1931616 | 1931616 | 2021-11-19 | Gratiot | Michigan | 26057 | 9596 | 141 |
1741187 | 1741187 | 2021-09-21 | Dickson | Tennessee | 47043 | 9596 | 147 |
1737938 | 1737938 | 2021-09-20 | Dickson | Tennessee | 47043 | 9596 | 147 |
1696469 | 1696469 | 2021-09-08 | Walker | Alabama | 1127 | 9596 | 300 |
1645133 | 1645133 | 2021-08-23 | Williamson | Illinois | 17199 | 9596 | 152 |
1561614 | 1561614 | 2021-07-28 | Missoula | Montana | 30063 | 9596 | 100 |
1519373 | 1519373 | 2021-07-15 | Cascade | Montana | 30013 | 9596 | 188 |
1426906 | 1426906 | 2021-06-17 | Lauderdale | Alabama | 1077 | 9596 | 249 |
1423660 | 1423660 | 2021-06-16 | Lauderdale | Alabama | 1077 | 9596 | 249 |
1333332 | 1333332 | 2021-05-19 | Twin Falls | Idaho | 16083 | 9596 | 128 |
1264350 | 1264350 | 2021-04-27 | Spotsylvania | Virginia | 51177 | 9596 | 113 |
1254020 | 1254020 | 2021-04-24 | Orangeburg | South Carolina | 45075 | 9596 | 242 |
1196824 | 1196824 | 2021-04-07 | Jackson | Georgia | 13157 | 9596 | 145 |
1059849 | 1059849 | 2021-02-23 | Berkeley | West Virginia | 54003 | 9596 | 98 |
1025166 | 1025166 | 2021-02-13 | Pottawattamie | Iowa | 19155 | 9596 | 139 |
865393 | 865393 | 2020-12-26 | Craighead | Arkansas | 5031 | 9596 | 129 |
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);