ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 8848 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 |
---|---|---|---|---|---|---|---|
2499688 | 2499688 | 2022-05-13 | Baxter | Arkansas | 5005 | 8848 | 247 |
2448796 | 2448796 | 2022-04-27 | Becker | Minnesota | 27005 | 8848 | 93 |
2396759 | 2396759 | 2022-04-11 | Polk | Minnesota | 27119 | 8848 | 107 |
2304147 | 2304147 | 2022-03-13 | Marshall | West Virginia | 54051 | 8848 | 152 |
2300895 | 2300895 | 2022-03-12 | Marshall | West Virginia | 54051 | 8848 | 152 |
2297643 | 2297643 | 2022-03-11 | Marshall | West Virginia | 54051 | 8848 | 152 |
2283613 | 2283613 | 2022-03-07 | Jackson | Ohio | 39079 | 8848 | 135 |
2160685 | 2160685 | 2022-01-28 | Kerr | Texas | 48265 | 8848 | 154 |
2150401 | 2150401 | 2022-01-25 | Coos | Oregon | 41011 | 8848 | 130 |
1975221 | 1975221 | 2021-12-02 | Warren | Tennessee | 47177 | 8848 | 132 |
1894724 | 1894724 | 2021-11-08 | Crittenden | Arkansas | 5035 | 8848 | 179 |
1857882 | 1857882 | 2021-10-27 | Carbon | Pennsylvania | 42025 | 8848 | 202 |
1853627 | 1853627 | 2021-10-26 | Grand Traverse | Michigan | 26055 | 8848 | 120 |
1850378 | 1850378 | 2021-10-25 | Grand Traverse | Michigan | 26055 | 8848 | 120 |
1847023 | 1847023 | 2021-10-24 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1843773 | 1843773 | 2021-10-23 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1840523 | 1840523 | 2021-10-22 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1831699 | 1831699 | 2021-10-19 | Geauga | Ohio | 39055 | 8848 | 158 |
1790729 | 1790729 | 2021-10-07 | Santa Cruz | Arizona | 4023 | 8848 | 191 |
1741574 | 1741574 | 2021-09-21 | Bedford | Virginia | 51019 | 8848 | 119 |
1414902 | 1414902 | 2021-06-13 | Campbell | Kentucky | 21037 | 8848 | 84 |
1416985 | 1416985 | 2021-06-13 | Cabell | West Virginia | 54011 | 8848 | 177 |
1411657 | 1411657 | 2021-06-12 | Campbell | Kentucky | 21037 | 8848 | 84 |
1413739 | 1413739 | 2021-06-12 | Cabell | West Virginia | 54011 | 8848 | 177 |
1408412 | 1408412 | 2021-06-11 | Campbell | Kentucky | 21037 | 8848 | 84 |
1410494 | 1410494 | 2021-06-11 | Cabell | West Virginia | 54011 | 8848 | 177 |
1375497 | 1375497 | 2021-06-01 | Bannock | Idaho | 16005 | 8848 | 110 |
1344596 | 1344596 | 2021-05-22 | Muskingum | Ohio | 39119 | 8848 | 134 |
1302235 | 1302235 | 2021-05-09 | Moore | North Carolina | 37125 | 8848 | 187 |
1298987 | 1298987 | 2021-05-08 | Moore | North Carolina | 37125 | 8848 | 187 |
1295741 | 1295741 | 2021-05-07 | Moore | North Carolina | 37125 | 8848 | 187 |
1267577 | 1267577 | 2021-04-28 | Portsmouth city | Virginia | 51740 | 8848 | 187 |
1235883 | 1235883 | 2021-04-19 | Unknown | Guam | 8848 | 137 | |
1210996 | 1210996 | 2021-04-11 | Missoula | Montana | 30063 | 8848 | 90 |
1207747 | 1207747 | 2021-04-10 | Missoula | Montana | 30063 | 8848 | 90 |
1204499 | 1204499 | 2021-04-09 | Missoula | Montana | 30063 | 8848 | 90 |
1056105 | 1056105 | 2021-02-22 | Robertson | Tennessee | 47147 | 8848 | 115 |
942037 | 942037 | 2021-01-18 | Richland | Ohio | 39139 | 8848 | 116 |
937383 | 937383 | 2021-01-17 | Delaware | Indiana | 18035 | 8848 | 136 |
908106 | 908106 | 2021-01-08 | LaSalle | Illinois | 17099 | 8848 | 239 |
845767 | 845767 | 2020-12-19 | Walworth | Wisconsin | 55127 | 8848 | 86 |
617223 | 617223 | 2020-10-10 | Mercer | New Jersey | 34021 | 8848 | 636 |
576853 | 576853 | 2020-09-28 | Brevard | Florida | 12009 | 8848 | 293 |
439243 | 439243 | 2020-08-16 | Camden | New Jersey | 34007 | 8848 | 582 |
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);