ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 6186 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 11
- Illinois 10
- Alaska 7
- Montana 4
- Arkansas 3
- Kansas 3
- Mississippi 3
- Puerto Rico 3
- Alabama 2
- Georgia 2
- Pennsylvania 2
- Virginia 2
- Colorado 1
- Florida 1
- Indiana 1
- Louisiana 1
- Minnesota 1
- Nevada 1
- New York 1
- North Carolina 1
- Ohio 1
- Texas 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492374 | 2492374 | 2022-05-10 | Haywood | Tennessee | 47075 | 6186 | 102 |
2489116 | 2489116 | 2022-05-09 | Haywood | Tennessee | 47075 | 6186 | 102 |
2485859 | 2485859 | 2022-05-08 | Haywood | Tennessee | 47075 | 6186 | 102 |
2482601 | 2482601 | 2022-05-07 | Haywood | Tennessee | 47075 | 6186 | 102 |
2479343 | 2479343 | 2022-05-06 | Haywood | Tennessee | 47075 | 6186 | 102 |
2476085 | 2476085 | 2022-05-05 | Haywood | Tennessee | 47075 | 6186 | 102 |
2472828 | 2472828 | 2022-05-04 | Haywood | Tennessee | 47075 | 6186 | 102 |
2444290 | 2444290 | 2022-04-26 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2441034 | 2441034 | 2022-04-25 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2437778 | 2437778 | 2022-04-24 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2434522 | 2434522 | 2022-04-23 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2431266 | 2431266 | 2022-04-22 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2428010 | 2428010 | 2022-04-21 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2430313 | 2430313 | 2022-04-21 | Manati | Puerto Rico | 72091 | 6186 | |
2424754 | 2424754 | 2022-04-20 | Nome Census Area | Alaska | 2180 | 6186 | 5 |
2424959 | 2424959 | 2022-04-20 | Montezuma | Colorado | 8083 | 6186 | 75 |
2384688 | 2384688 | 2022-04-07 | Aguada | Puerto Rico | 72003 | 6186 | |
2373206 | 2373206 | 2022-04-04 | Crawford | Illinois | 17033 | 6186 | 60 |
2369953 | 2369953 | 2022-04-03 | Crawford | Illinois | 17033 | 6186 | 60 |
2366700 | 2366700 | 2022-04-02 | Crawford | Illinois | 17033 | 6186 | 60 |
2363447 | 2363447 | 2022-04-01 | Crawford | Illinois | 17033 | 6186 | 60 |
2360193 | 2360193 | 2022-03-31 | Crawford | Illinois | 17033 | 6186 | 60 |
2356939 | 2356939 | 2022-03-30 | Crawford | Illinois | 17033 | 6186 | 60 |
2347250 | 2347250 | 2022-03-27 | Shelby | Illinois | 17173 | 6186 | 77 |
2343997 | 2343997 | 2022-03-26 | Shelby | Illinois | 17173 | 6186 | 77 |
2340744 | 2340744 | 2022-03-25 | Shelby | Illinois | 17173 | 6186 | 77 |
2311420 | 2311420 | 2022-03-16 | Jersey | Illinois | 17083 | 6186 | 88 |
2265275 | 2265275 | 2022-03-02 | Geneva | Alabama | 1061 | 6186 | 154 |
2198731 | 2198731 | 2022-02-09 | Churchill | Nevada | 32001 | 6186 | 97 |
2164301 | 2164301 | 2022-01-29 | Jackson | West Virginia | 54035 | 6186 | 115 |
2147974 | 2147974 | 2022-01-24 | Wythe | Virginia | 51197 | 6186 | 121 |
2130978 | 2130978 | 2022-01-19 | Aguadilla | Puerto Rico | 72005 | 6186 | |
2096147 | 2096147 | 2022-01-09 | Dallas | Alabama | 1047 | 6186 | 213 |
2008773 | 2008773 | 2021-12-13 | Chattahoochee | Georgia | 13053 | 6186 | 21 |
1989979 | 1989979 | 2021-12-07 | Beauregard | Louisiana | 22011 | 6186 | 126 |
1964512 | 1964512 | 2021-11-29 | Silver Bow | Montana | 30093 | 6186 | 107 |
1961261 | 1961261 | 2021-11-28 | Silver Bow | Montana | 30093 | 6186 | 107 |
1958010 | 1958010 | 2021-11-27 | Silver Bow | Montana | 30093 | 6186 | 107 |
1954759 | 1954759 | 2021-11-26 | Silver Bow | Montana | 30093 | 6186 | 107 |
1782296 | 1782296 | 2021-10-04 | Bolivar | Mississippi | 28011 | 6186 | 145 |
1762840 | 1762840 | 2021-09-28 | Marshall | Mississippi | 28093 | 6186 | 126 |
1694489 | 1694489 | 2021-09-07 | Benton | Minnesota | 27009 | 6186 | 98 |
1683030 | 1683030 | 2021-09-03 | Wilson | Texas | 48493 | 6186 | 90 |
1656457 | 1656457 | 2021-08-26 | Columbia | Pennsylvania | 42037 | 6186 | 136 |
1653545 | 1653545 | 2021-08-25 | Warren | Tennessee | 47177 | 6186 | 91 |
1650298 | 1650298 | 2021-08-24 | Warren | Tennessee | 47177 | 6186 | 91 |
1601225 | 1601225 | 2021-08-09 | Bradford | Pennsylvania | 42015 | 6186 | 97 |
1586434 | 1586434 | 2021-08-05 | Laurens | Georgia | 13175 | 6186 | 173 |
1469186 | 1469186 | 2021-06-30 | Crittenden | Arkansas | 5035 | 6186 | 97 |
1465941 | 1465941 | 2021-06-29 | Crittenden | Arkansas | 5035 | 6186 | 97 |
1462696 | 1462696 | 2021-06-28 | Crittenden | Arkansas | 5035 | 6186 | 97 |
1383386 | 1383386 | 2021-06-03 | Lenoir | North Carolina | 37107 | 6186 | 119 |
1345684 | 1345684 | 2021-05-22 | Sauk | Wisconsin | 55111 | 6186 | 54 |
1289854 | 1289854 | 2021-05-05 | Jefferson | Tennessee | 47089 | 6186 | 124 |
1269253 | 1269253 | 2021-04-29 | Lamar | Mississippi | 28073 | 6186 | 85 |
1248009 | 1248009 | 2021-04-22 | Bedford | Virginia | 51019 | 6186 | 97 |
1176209 | 1176209 | 2021-03-31 | McMinn | Tennessee | 47107 | 6186 | 95 |
1165945 | 1165945 | 2021-03-28 | Ashtabula | Ohio | 39007 | 6186 | 158 |
1093161 | 1093161 | 2021-03-06 | Boone | Indiana | 18011 | 6186 | 96 |
983044 | 983044 | 2021-01-31 | Leavenworth | Kansas | 20103 | 6186 | 45 |
979798 | 979798 | 2021-01-30 | Leavenworth | Kansas | 20103 | 6186 | 45 |
976552 | 976552 | 2021-01-29 | Leavenworth | Kansas | 20103 | 6186 | 45 |
899618 | 899618 | 2021-01-05 | Ulster | New York | 36111 | 6186 | 151 |
894810 | 894810 | 2021-01-04 | Columbia | Florida | 12023 | 6186 | 119 |
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);