ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 6927 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Indiana 6
- Tennessee 5
- Illinois 4
- North Carolina 4
- Ohio 4
- Texas 4
- Georgia 3
- Nebraska 3
- New Hampshire 3
- New York 3
- Virginia 3
- Wisconsin 3
- California 2
- Louisiana 2
- Michigan 2
- Pennsylvania 2
- Puerto Rico 2
- Arkansas 1
- Idaho 1
- Kentucky 1
- Minnesota 1
- Mississippi 1
- Montana 1
- New Jersey 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2402313 | 2402313 | 2022-04-13 | Dawson | Georgia | 13085 | 6927 | 100 |
2395803 | 2395803 | 2022-04-11 | Dawson | Georgia | 13085 | 6927 | 100 |
2393904 | 2393904 | 2022-04-10 | Coos | New Hampshire | 33007 | 6927 | 113 |
2390648 | 2390648 | 2022-04-09 | Coos | New Hampshire | 33007 | 6927 | 113 |
2387392 | 2387392 | 2022-04-08 | Coos | New Hampshire | 33007 | 6927 | 113 |
2331676 | 2331676 | 2022-03-22 | Nobles | Minnesota | 27105 | 6927 | 59 |
2311925 | 2311925 | 2022-03-16 | Jefferson Davis | Louisiana | 22053 | 6927 | 154 |
2313708 | 2313708 | 2022-03-16 | Accomack | Virginia | 51001 | 6927 | 104 |
2313949 | 2313949 | 2022-03-16 | Door | Wisconsin | 55029 | 6927 | 69 |
2310455 | 2310455 | 2022-03-15 | Accomack | Virginia | 51001 | 6927 | 104 |
2285339 | 2285339 | 2022-03-08 | Elmore | Idaho | 16039 | 6927 | 69 |
2239177 | 2239177 | 2022-02-21 | Lincoln | Wisconsin | 55069 | 6927 | 136 |
2191887 | 2191887 | 2022-02-07 | Copiah | Mississippi | 28029 | 6927 | 101 |
2192824 | 2192824 | 2022-02-07 | Gurabo | Puerto Rico | 72063 | 6927 | |
2183437 | 2183437 | 2022-02-04 | Hopkins | Texas | 48223 | 6927 | 163 |
2176524 | 2176524 | 2022-02-02 | Warren | Pennsylvania | 42123 | 6927 | 198 |
2155810 | 2155810 | 2022-01-27 | East Feliciana | Louisiana | 22037 | 6927 | 157 |
2149177 | 2149177 | 2022-01-25 | Boyle | Kentucky | 21021 | 6927 | 118 |
2111232 | 2111232 | 2022-01-13 | Jackson | Ohio | 39079 | 6927 | 114 |
2101280 | 2101280 | 2022-01-10 | Wyoming | New York | 36121 | 6927 | 75 |
2080478 | 2080478 | 2022-01-04 | Christian | Illinois | 17021 | 6927 | 109 |
2032842 | 2032842 | 2021-12-20 | Madison | Nebraska | 31119 | 6927 | 53 |
1990549 | 1990549 | 2021-12-07 | Dodge | Nebraska | 31053 | 6927 | 83 |
1984947 | 1984947 | 2021-12-05 | Obion | Tennessee | 47131 | 6927 | 115 |
1981697 | 1981697 | 2021-12-04 | Obion | Tennessee | 47131 | 6927 | 115 |
1978216 | 1978216 | 2021-12-03 | Guaynabo | Puerto Rico | 72061 | 6927 | |
1978447 | 1978447 | 2021-12-03 | Obion | Tennessee | 47131 | 6927 | 115 |
1960330 | 1960330 | 2021-11-28 | Gibson | Indiana | 18051 | 6927 | 122 |
1957079 | 1957079 | 2021-11-27 | Gibson | Indiana | 18051 | 6927 | 122 |
1953828 | 1953828 | 2021-11-26 | Gibson | Indiana | 18051 | 6927 | 122 |
1950577 | 1950577 | 2021-11-25 | Gibson | Indiana | 18051 | 6927 | 122 |
1947326 | 1947326 | 2021-11-24 | Gibson | Indiana | 18051 | 6927 | 122 |
1945415 | 1945415 | 2021-11-23 | Brown | Ohio | 39015 | 6927 | 113 |
1921220 | 1921220 | 2021-11-16 | Effingham | Illinois | 17049 | 6927 | 113 |
1920546 | 1920546 | 2021-11-15 | Pierce | Wisconsin | 55093 | 6927 | 48 |
1907133 | 1907133 | 2021-11-11 | Medina | Texas | 48325 | 6927 | 166 |
1903884 | 1903884 | 2021-11-10 | Medina | Texas | 48325 | 6927 | 166 |
1899151 | 1899151 | 2021-11-09 | Newaygo | Michigan | 26123 | 6927 | 85 |
1900634 | 1900634 | 2021-11-09 | Medina | Texas | 48325 | 6927 | 166 |
1895901 | 1895901 | 2021-11-08 | Newaygo | Michigan | 26123 | 6927 | 85 |
1896592 | 1896592 | 2021-11-08 | Vance | North Carolina | 37181 | 6927 | 102 |
1832600 | 1832600 | 2021-10-19 | James City | Virginia | 51095 | 6927 | 93 |
1827018 | 1827018 | 2021-10-18 | Macoupin | Illinois | 17117 | 6927 | 133 |
1815904 | 1815904 | 2021-10-14 | Cheatham | Tennessee | 47021 | 6927 | 66 |
1802350 | 1802350 | 2021-10-10 | Richmond | North Carolina | 37153 | 6927 | 134 |
1799101 | 1799101 | 2021-10-09 | Richmond | North Carolina | 37153 | 6927 | 134 |
1795852 | 1795852 | 2021-10-08 | Richmond | North Carolina | 37153 | 6927 | 134 |
1796005 | 1796005 | 2021-10-08 | Seneca | Ohio | 39147 | 6927 | 140 |
1557480 | 1557480 | 2021-07-27 | Morgan | Indiana | 18109 | 6927 | 148 |
1518160 | 1518160 | 2021-07-15 | Bulloch | Georgia | 13031 | 6927 | 122 |
1406277 | 1406277 | 2021-06-10 | Ross | Ohio | 39141 | 6927 | 159 |
1332029 | 1332029 | 2021-05-18 | Coffee | Tennessee | 47031 | 6927 | 124 |
1108837 | 1108837 | 2021-03-11 | Lonoke | Arkansas | 5085 | 6927 | 110 |
1074778 | 1074778 | 2021-02-28 | Hunterdon | New Jersey | 34019 | 6927 | 159 |
961265 | 961265 | 2021-01-24 | Putnam | New York | 36079 | 6927 | 76 |
918837 | 918837 | 2021-01-11 | Missoula | Montana | 30063 | 6927 | 58 |
919089 | 919089 | 2021-01-11 | Ulster | New York | 36111 | 6927 | 170 |
833046 | 833046 | 2020-12-16 | Shasta | California | 6089 | 6927 | 64 |
829799 | 829799 | 2020-12-15 | Shasta | California | 6089 | 6927 | 63 |
757209 | 757209 | 2020-11-22 | Dauphin | Pennsylvania | 42043 | 6927 | 212 |
736129 | 736129 | 2020-11-16 | Rock Island | Illinois | 17161 | 6927 | 117 |
701514 | 701514 | 2020-11-05 | Sarpy | Nebraska | 31153 | 6927 | 39 |
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);