ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 9264 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Mississippi 8
- Illinois 4
- Virginia 4
- Arkansas 3
- Pennsylvania 3
- California 2
- Kansas 2
- Kentucky 2
- New Hampshire 2
- New Mexico 2
- New York 2
- Alabama 1
- Arizona 1
- Hawaii 1
- Idaho 1
- Indiana 1
- Missouri 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489981 | 2489981 | 2022-05-10 | Union | Arkansas | 5139 | 9264 | 176 |
2486724 | 2486724 | 2022-05-09 | Union | Arkansas | 5139 | 9264 | 176 |
2483466 | 2483466 | 2022-05-08 | Union | Arkansas | 5139 | 9264 | 176 |
2347984 | 2347984 | 2022-03-27 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2344731 | 2344731 | 2022-03-26 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2341478 | 2341478 | 2022-03-25 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2338225 | 2338225 | 2022-03-24 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2334971 | 2334971 | 2022-03-23 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2331717 | 2331717 | 2022-03-22 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2331809 | 2331809 | 2022-03-22 | Camden | Missouri | 29029 | 9264 | 176 |
2328465 | 2328465 | 2022-03-21 | Bolivar | Mississippi | 28011 | 9264 | 179 |
2210646 | 2210646 | 2022-02-13 | Monroe | Illinois | 17133 | 9264 | 122 |
2207393 | 2207393 | 2022-02-12 | Monroe | Illinois | 17133 | 9264 | 122 |
2204140 | 2204140 | 2022-02-11 | Monroe | Illinois | 17133 | 9264 | 122 |
2200887 | 2200887 | 2022-02-10 | Monroe | Illinois | 17133 | 9264 | 122 |
2147243 | 2147243 | 2022-01-24 | Wayne | Pennsylvania | 42127 | 9264 | 148 |
2096224 | 2096224 | 2022-01-09 | Graham | Arizona | 4009 | 9264 | 159 |
2055648 | 2055648 | 2021-12-27 | Grafton | New Hampshire | 33009 | 9264 | 45 |
2031703 | 2031703 | 2021-12-20 | Madison | Idaho | 16065 | 9264 | 42 |
1989958 | 1989958 | 2021-12-07 | Scott | Kentucky | 21209 | 9264 | 62 |
1906623 | 1906623 | 2021-11-11 | Carbon | Pennsylvania | 42025 | 9264 | 205 |
1852571 | 1852571 | 2021-10-26 | Nevada | California | 6057 | 9264 | 90 |
1789266 | 1789266 | 2021-10-06 | Steuben | New York | 36101 | 9264 | 166 |
1748941 | 1748941 | 2021-09-24 | Maui | Hawaii | 15009 | 9264 | 83 |
1679190 | 1679190 | 2021-09-02 | Clearfield | Pennsylvania | 42033 | 9264 | 166 |
1637298 | 1637298 | 2021-08-20 | Unknown | Tennessee | 9264 | 94 | |
1530519 | 1530519 | 2021-07-18 | Portsmouth city | Virginia | 51740 | 9264 | 205 |
1527272 | 1527272 | 2021-07-17 | Portsmouth city | Virginia | 51740 | 9264 | 205 |
1524025 | 1524025 | 2021-07-16 | Portsmouth city | Virginia | 51740 | 9264 | 205 |
1520777 | 1520777 | 2021-07-15 | Portsmouth city | Virginia | 51740 | 9264 | 205 |
1399471 | 1399471 | 2021-06-08 | Chaves | New Mexico | 35005 | 9264 | 169 |
1396225 | 1396225 | 2021-06-07 | Chaves | New Mexico | 35005 | 9264 | 169 |
1361906 | 1361906 | 2021-05-27 | Ozaukee | Wisconsin | 55089 | 9264 | 98 |
1314172 | 1314172 | 2021-05-13 | Douglas | Kansas | 20045 | 9264 | 87 |
1310925 | 1310925 | 2021-05-12 | Douglas | Kansas | 20045 | 9264 | 87 |
1282577 | 1282577 | 2021-05-03 | Merrimack | New Hampshire | 33013 | 9264 | 113 |
1171424 | 1171424 | 2021-03-30 | Hardin | Kentucky | 21093 | 9264 | 138 |
1163086 | 1163086 | 2021-03-27 | Orangeburg | South Carolina | 45075 | 9264 | 234 |
1050300 | 1050300 | 2021-02-21 | Limestone | Alabama | 1083 | 9264 | 130 |
980307 | 980307 | 2021-01-30 | Lee | Mississippi | 28081 | 9264 | 149 |
978426 | 978426 | 2021-01-29 | Rockwall | Texas | 48397 | 9264 | 95 |
906060 | 906060 | 2021-01-07 | Broome | New York | 36007 | 9264 | 220 |
891979 | 891979 | 2021-01-03 | Madison | Indiana | 18095 | 9264 | 199 |
537885 | 537885 | 2020-09-16 | San Mateo | California | 6081 | 9264 | 142 |
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);