ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 7561 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Alabama 7
- Mississippi 4
- Missouri 4
- Washington 4
- Colorado 3
- Georgia 3
- North Carolina 3
- Oregon 3
- Wisconsin 3
- Indiana 2
- Kansas 2
- Ohio 2
- Texas 2
- Virginia 2
- Arizona 1
- Arkansas 1
- California 1
- Kentucky 1
- Louisiana 1
- Michigan 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447518 | 2447518 | 2022-04-27 | Pike | Alabama | 1109 | 7561 | 134 |
2301087 | 2301087 | 2022-03-13 | Winston | Alabama | 1133 | 7561 | 122 |
2297835 | 2297835 | 2022-03-12 | Winston | Alabama | 1133 | 7561 | 122 |
2294583 | 2294583 | 2022-03-11 | Winston | Alabama | 1133 | 7561 | 122 |
2291331 | 2291331 | 2022-03-10 | Winston | Alabama | 1133 | 7561 | 122 |
2255532 | 2255532 | 2022-02-27 | Lawrence | Alabama | 1079 | 7561 | 150 |
2258229 | 2258229 | 2022-02-27 | Hockley | Texas | 48219 | 7561 | 157 |
2254978 | 2254978 | 2022-02-26 | Hockley | Texas | 48219 | 7561 | 157 |
2211532 | 2211532 | 2022-02-13 | Lawrence | Missouri | 29109 | 7561 | 148 |
2208279 | 2208279 | 2022-02-12 | Lawrence | Missouri | 29109 | 7561 | 148 |
2205026 | 2205026 | 2022-02-11 | Lawrence | Missouri | 29109 | 7561 | 148 |
2201773 | 2201773 | 2022-02-10 | Lawrence | Missouri | 29109 | 7561 | 148 |
2180865 | 2180865 | 2022-02-04 | Poinsett | Arkansas | 5111 | 7561 | 109 |
2084300 | 2084300 | 2022-01-05 | Webster | Louisiana | 22119 | 7561 | 154 |
1996279 | 1996279 | 2021-12-09 | Ford | Kansas | 20057 | 7561 | 98 |
1993028 | 1993028 | 2021-12-08 | Ford | Kansas | 20057 | 7561 | 98 |
1990805 | 1990805 | 2021-12-07 | Hoke | North Carolina | 37093 | 7561 | 86 |
1987093 | 1987093 | 2021-12-06 | Washington | Mississippi | 28151 | 7561 | 169 |
1987514 | 1987514 | 2021-12-06 | Beaufort | North Carolina | 37013 | 7561 | 136 |
1975032 | 1975032 | 2021-12-02 | Chesterfield | South Carolina | 45025 | 7561 | 149 |
1963889 | 1963889 | 2021-11-29 | Franklin | Kentucky | 21073 | 7561 | 97 |
1961896 | 1961896 | 2021-11-28 | Huntingdon | Pennsylvania | 42061 | 7561 | 177 |
1932409 | 1932409 | 2021-11-19 | Ashland | Ohio | 39005 | 7561 | 146 |
1878806 | 1878806 | 2021-11-03 | Habersham | Georgia | 13137 | 7561 | 207 |
1875850 | 1875850 | 2021-11-02 | Lawrence | Indiana | 18093 | 7561 | 179 |
1872345 | 1872345 | 2021-11-01 | Murray | Georgia | 13213 | 7561 | 136 |
1870856 | 1870856 | 2021-10-31 | Polk | Oregon | 41053 | 7561 | 82 |
1867607 | 1867607 | 2021-10-30 | Polk | Oregon | 41053 | 7561 | 82 |
1864358 | 1864358 | 2021-10-29 | Polk | Oregon | 41053 | 7561 | 82 |
1787145 | 1787145 | 2021-10-05 | Pittsylvania | Virginia | 51143 | 7561 | 101 |
1766773 | 1766773 | 2021-09-29 | Washington | Ohio | 39167 | 7561 | 127 |
1767783 | 1767783 | 2021-09-29 | Barron | Wisconsin | 55005 | 7561 | 86 |
1767836 | 1767836 | 2021-09-29 | Sauk | Wisconsin | 55111 | 7561 | 62 |
1709663 | 1709663 | 2021-09-12 | Eagle | Colorado | 8037 | 7561 | 29 |
1706416 | 1706416 | 2021-09-11 | Eagle | Colorado | 8037 | 7561 | 29 |
1703168 | 1703168 | 2021-09-10 | Eagle | Colorado | 8037 | 7561 | 29 |
1679844 | 1679844 | 2021-09-02 | Augusta | Virginia | 51015 | 7561 | 89 |
1633970 | 1633970 | 2021-08-19 | Carter | Tennessee | 47019 | 7561 | 171 |
1600799 | 1600799 | 2021-08-09 | Valencia | New Mexico | 35061 | 7561 | 124 |
1602016 | 1602016 | 2021-08-09 | Chelan | Washington | 53007 | 7561 | 74 |
1598768 | 1598768 | 2021-08-08 | Chelan | Washington | 53007 | 7561 | 74 |
1595519 | 1595519 | 2021-08-07 | Chelan | Washington | 53007 | 7561 | 74 |
1592270 | 1592270 | 2021-08-06 | Chelan | Washington | 53007 | 7561 | 74 |
1551679 | 1551679 | 2021-07-25 | Lauderdale | Mississippi | 28075 | 7561 | 243 |
1548432 | 1548432 | 2021-07-24 | Lauderdale | Mississippi | 28075 | 7561 | 243 |
1545185 | 1545185 | 2021-07-23 | Lauderdale | Mississippi | 28075 | 7561 | 243 |
1428164 | 1428164 | 2021-06-17 | Midland | Michigan | 26111 | 7561 | 93 |
1360590 | 1360590 | 2021-05-27 | Oswego | New York | 36075 | 7561 | 90 |
1300182 | 1300182 | 2021-05-08 | Chippewa | Wisconsin | 55017 | 7561 | 96 |
882239 | 882239 | 2020-12-31 | LaPorte | Indiana | 18091 | 7561 | 139 |
719694 | 719694 | 2020-11-11 | Henry | Georgia | 13151 | 7561 | 130 |
701696 | 701696 | 2020-11-05 | Cumberland | North Carolina | 37051 | 7561 | 103 |
570243 | 570243 | 2020-09-26 | Kings | California | 6031 | 7561 | 80 |
456878 | 456878 | 2020-08-22 | Montgomery | Alabama | 1101 | 7561 | 158 |
373180 | 373180 | 2020-07-27 | Pinal | Arizona | 4021 | 7561 | 122 |
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);