ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8825 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 8
- Minnesota 5
- Arkansas 3
- Pennsylvania 3
- Texas 3
- Georgia 2
- North Carolina 2
- Ohio 2
- Virginia 2
- Alabama 1
- Florida 1
- Guam 1
- Hawaii 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Michigan 1
- Mississippi 1
- Nevada 1
- New York 1
- Oregon 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426004 | 2426004 | 2022-04-20 | Becker | Minnesota | 27005 | 8825 | 92 |
2384669 | 2384669 | 2022-04-07 | Perry | Pennsylvania | 42099 | 8825 | 184 |
2328431 | 2328431 | 2022-03-21 | Polk | Minnesota | 27119 | 8825 | 103 |
2302357 | 2302357 | 2022-03-13 | Carlton | Minnesota | 27017 | 8825 | 95 |
2299105 | 2299105 | 2022-03-12 | Carlton | Minnesota | 27017 | 8825 | 95 |
2295853 | 2295853 | 2022-03-11 | Carlton | Minnesota | 27017 | 8825 | 95 |
2264097 | 2264097 | 2022-03-01 | Jackson | Ohio | 39079 | 8825 | 132 |
2213635 | 2213635 | 2022-02-14 | Bryan | Georgia | 13029 | 8825 | 81 |
2195690 | 2195690 | 2022-02-08 | Person | North Carolina | 37145 | 8825 | 99 |
2196335 | 2196335 | 2022-02-08 | Weakley | Tennessee | 47183 | 8825 | 116 |
2193081 | 2193081 | 2022-02-07 | Weakley | Tennessee | 47183 | 8825 | 116 |
2187384 | 2187384 | 2022-02-06 | Union | Arkansas | 5139 | 8825 | 159 |
2189827 | 2189827 | 2022-02-06 | Weakley | Tennessee | 47183 | 8825 | 116 |
2186574 | 2186574 | 2022-02-05 | Weakley | Tennessee | 47183 | 8825 | 116 |
2183322 | 2183322 | 2022-02-04 | Weakley | Tennessee | 47183 | 8825 | 116 |
2180070 | 2180070 | 2022-02-03 | Weakley | Tennessee | 47183 | 8825 | 116 |
2176819 | 2176819 | 2022-02-02 | Weakley | Tennessee | 47183 | 8825 | 116 |
2155340 | 2155340 | 2022-01-27 | Morgan | Illinois | 17137 | 8825 | 130 |
2147984 | 2147984 | 2022-01-24 | Douglas | Washington | 53017 | 8825 | 55 |
2130132 | 2130132 | 2022-01-19 | Warren | Mississippi | 28149 | 8825 | 184 |
1994025 | 1994025 | 2021-12-08 | Carteret | North Carolina | 37031 | 8825 | 83 |
1854121 | 1854121 | 2021-10-26 | Carson City | Nevada | 32510 | 8825 | 150 |
1855120 | 1855120 | 2021-10-26 | Lamar | Texas | 48277 | 8825 | 204 |
1724673 | 1724673 | 2021-09-16 | Crawford | Pennsylvania | 42039 | 8825 | 168 |
1719696 | 1719696 | 2021-09-15 | Maui | Hawaii | 15009 | 8825 | 80 |
1721730 | 1721730 | 2021-09-15 | Monroe | Tennessee | 47123 | 8825 | 108 |
1657327 | 1657327 | 2021-08-26 | Wood | West Virginia | 54107 | 8825 | 180 |
1321867 | 1321867 | 2021-05-15 | Muskingum | Ohio | 39119 | 8825 | 133 |
1293800 | 1293800 | 2021-05-07 | DeKalb | Alabama | 1049 | 8825 | 185 |
1281959 | 1281959 | 2021-05-03 | St. Landry | Louisiana | 22097 | 8825 | 253 |
1222892 | 1222892 | 2021-04-15 | Unknown | Guam | 8825 | 137 | |
1098680 | 1098680 | 2021-03-07 | Hampton city | Virginia | 51650 | 8825 | 129 |
1077272 | 1077272 | 2021-03-01 | Hardin | Kentucky | 21093 | 8825 | 96 |
995219 | 995219 | 2021-02-04 | Garland | Arkansas | 5051 | 8825 | 211 |
950946 | 950946 | 2021-01-21 | Monroe | Michigan | 26115 | 8825 | 171 |
871541 | 871541 | 2020-12-27 | Richmond city | Virginia | 51760 | 8825 | 92 |
859563 | 859563 | 2020-12-24 | Vigo | Indiana | 18167 | 8825 | 144 |
855707 | 855707 | 2020-12-23 | Sebastian | Arkansas | 5131 | 8825 | 145 |
747515 | 747515 | 2020-11-19 | York | Pennsylvania | 42133 | 8825 | 231 |
711368 | 711368 | 2020-11-08 | Monroe | New York | 36055 | 8825 | 262 |
656609 | 656609 | 2020-10-22 | Multnomah | Oregon | 41051 | 8825 | 157 |
606112 | 606112 | 2020-10-07 | Chatham | Georgia | 13051 | 8825 | 170 |
395949 | 395949 | 2020-08-03 | Manatee | Florida | 12081 | 8825 | 187 |
395051 | 395051 | 2020-08-02 | Galveston | Texas | 48167 | 8825 | 97 |
391835 | 391835 | 2020-08-01 | Galveston | Texas | 48167 | 8825 | 97 |
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);