ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8834 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Missouri 6
- Minnesota 5
- North Carolina 5
- California 3
- Louisiana 3
- New York 3
- Texas 3
- Wisconsin 3
- Alabama 2
- Arkansas 2
- Georgia 2
- Connecticut 1
- Guam 1
- Indiana 1
- Ohio 1
- Pennsylvania 1
- South Dakota 1
- Tennessee 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486657 | 2486657 | 2022-05-09 | Baxter | Arkansas | 5005 | 8834 | 247 |
2483399 | 2483399 | 2022-05-08 | Baxter | Arkansas | 5005 | 8834 | 247 |
2449351 | 2449351 | 2022-04-27 | Orleans | New York | 36073 | 8834 | 113 |
2404810 | 2404810 | 2022-04-13 | Windsor | Vermont | 50027 | 8834 | 50 |
2347950 | 2347950 | 2022-03-27 | Polk | Minnesota | 27119 | 8834 | 104 |
2344697 | 2344697 | 2022-03-26 | Polk | Minnesota | 27119 | 8834 | 104 |
2341444 | 2341444 | 2022-03-25 | Polk | Minnesota | 27119 | 8834 | 104 |
2331632 | 2331632 | 2022-03-22 | Carlton | Minnesota | 27017 | 8834 | 96 |
2305609 | 2305609 | 2022-03-14 | Carlton | Minnesota | 27017 | 8834 | 95 |
2289863 | 2289863 | 2022-03-09 | Allegany | New York | 36003 | 8834 | 151 |
2270602 | 2270602 | 2022-03-03 | Jackson | Ohio | 39079 | 8834 | 132 |
2223172 | 2223172 | 2022-02-17 | Amador | California | 6005 | 8834 | 77 |
2216886 | 2216886 | 2022-02-15 | Bryan | Georgia | 13029 | 8834 | 81 |
2211123 | 2211123 | 2022-02-13 | Iberville | Louisiana | 22047 | 8834 | 144 |
2207870 | 2207870 | 2022-02-12 | Iberville | Louisiana | 22047 | 8834 | 144 |
2204617 | 2204617 | 2022-02-11 | Iberville | Louisiana | 22047 | 8834 | 144 |
2087942 | 2087942 | 2022-01-06 | Newton | Missouri | 29145 | 8834 | 169 |
1971972 | 1971972 | 2021-12-01 | Warren | Tennessee | 47177 | 8834 | 132 |
1909143 | 1909143 | 2021-11-12 | Joplin | Missouri | 8834 | 153 | |
1904258 | 1904258 | 2021-11-10 | Calumet | Wisconsin | 55015 | 8834 | 62 |
1877075 | 1877075 | 2021-11-02 | Pender | North Carolina | 37141 | 8834 | 100 |
1781090 | 1781090 | 2021-10-04 | Nevada | California | 6057 | 8834 | 90 |
1761855 | 1761855 | 2021-09-28 | Laurens | Georgia | 13175 | 8834 | 218 |
1712682 | 1712682 | 2021-09-13 | Jackson | Alabama | 1071 | 8834 | 132 |
1611202 | 1611202 | 2021-08-12 | Lincoln | South Dakota | 46083 | 8834 | 78 |
1597695 | 1597695 | 2021-08-08 | Surry | North Carolina | 37171 | 8834 | 174 |
1594446 | 1594446 | 2021-08-07 | Surry | North Carolina | 37171 | 8834 | 174 |
1591197 | 1591197 | 2021-08-06 | Surry | North Carolina | 37171 | 8834 | 174 |
1543113 | 1543113 | 2021-07-22 | Angelina | Texas | 48005 | 8834 | 288 |
1539865 | 1539865 | 2021-07-21 | Angelina | Texas | 48005 | 8834 | 288 |
1536618 | 1536618 | 2021-07-20 | Angelina | Texas | 48005 | 8834 | 288 |
1334585 | 1334585 | 2021-05-19 | Chautauqua | New York | 36013 | 8834 | 141 |
1229387 | 1229387 | 2021-04-17 | Unknown | Guam | 8834 | 137 | |
1085894 | 1085894 | 2021-03-03 | Jefferson | Wisconsin | 55055 | 8834 | 125 |
1082648 | 1082648 | 2021-03-02 | Jefferson | Wisconsin | 55055 | 8834 | 125 |
1018120 | 1018120 | 2021-02-11 | Windham | Connecticut | 9015 | 8834 | 162 |
983610 | 983610 | 2021-01-31 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
980364 | 980364 | 2021-01-30 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
977118 | 977118 | 2021-01-29 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
973873 | 973873 | 2021-01-28 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
940655 | 940655 | 2021-01-18 | LaPorte | Indiana | 18091 | 8834 | 158 |
897964 | 897964 | 2021-01-05 | Yolo | California | 6113 | 8834 | 123 |
877277 | 877277 | 2020-12-29 | Centre | Pennsylvania | 42027 | 8834 | 135 |
675757 | 675757 | 2020-10-28 | Forsyth | North Carolina | 37067 | 8834 | 119 |
570092 | 570092 | 2020-09-26 | Montgomery | Alabama | 1101 | 8834 | 184 |
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);