ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 6862 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 10
- Virginia 10
- Kentucky 6
- Tennessee 6
- Alabama 5
- Indiana 4
- West Virginia 4
- Louisiana 3
- New Mexico 3
- North Carolina 3
- Pennsylvania 3
- Georgia 2
- Michigan 2
- Missouri 2
- Alaska 1
- Arizona 1
- Arkansas 1
- Idaho 1
- Kansas 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474669 | 2474669 | 2022-05-05 | Morehouse | Louisiana | 22067 | 6862 | 134 |
2463441 | 2463441 | 2022-05-01 | Caroline | Virginia | 51033 | 6862 | 84 |
2460185 | 2460185 | 2022-04-30 | Caroline | Virginia | 51033 | 6862 | 84 |
2456929 | 2456929 | 2022-04-29 | Caroline | Virginia | 51033 | 6862 | 84 |
2424121 | 2424121 | 2022-04-19 | Fannin | Texas | 48147 | 6862 | 184 |
2317051 | 2317051 | 2022-03-17 | Orange | Virginia | 51137 | 6862 | 85 |
2304998 | 2304998 | 2022-03-14 | Fayette | Indiana | 18041 | 6862 | 146 |
2281413 | 2281413 | 2022-03-06 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2278160 | 2278160 | 2022-03-05 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2274907 | 2274907 | 2022-03-04 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2246172 | 2246172 | 2022-02-24 | Dawson | Georgia | 13085 | 6862 | 97 |
2240618 | 2240618 | 2022-02-22 | Nobles | Minnesota | 27105 | 6862 | 58 |
2216365 | 2216365 | 2022-02-14 | Nicholas | West Virginia | 54067 | 6862 | 86 |
2167111 | 2167111 | 2022-01-30 | Cooke | Texas | 48097 | 6862 | 118 |
2108899 | 2108899 | 2022-01-12 | Petersburg city | Virginia | 51730 | 6862 | 109 |
2036474 | 2036474 | 2021-12-21 | Madison | Ohio | 39097 | 6862 | 98 |
2013077 | 2013077 | 2021-12-14 | Panola | Mississippi | 28107 | 6862 | 137 |
2009539 | 2009539 | 2021-12-13 | Webster | Louisiana | 22119 | 6862 | 152 |
1937575 | 1937575 | 2021-11-21 | Gibson | Indiana | 18051 | 6862 | 120 |
1934325 | 1934325 | 2021-11-20 | Gibson | Indiana | 18051 | 6862 | 120 |
1931074 | 1931074 | 2021-11-19 | Gibson | Indiana | 18051 | 6862 | 120 |
1923862 | 1923862 | 2021-11-17 | Covington | Alabama | 1039 | 6862 | 191 |
1897856 | 1897856 | 2021-11-09 | Chilton | Alabama | 1021 | 6862 | 167 |
1853616 | 1853616 | 2021-10-26 | Chippewa | Michigan | 26033 | 6862 | 65 |
1850367 | 1850367 | 2021-10-25 | Chippewa | Michigan | 26033 | 6862 | 65 |
1835646 | 1835646 | 2021-10-20 | Medina | Texas | 48325 | 6862 | 161 |
1784185 | 1784185 | 2021-10-05 | Tallapoosa | Alabama | 1123 | 6862 | 189 |
1764430 | 1764430 | 2021-09-28 | Washington | Virginia | 51191 | 6862 | 132 |
1760878 | 1760878 | 2021-09-27 | Jim Wells | Texas | 48249 | 6862 | 158 |
1755925 | 1755925 | 2021-09-26 | Graves | Kentucky | 21083 | 6862 | 116 |
1757630 | 1757630 | 2021-09-26 | Jim Wells | Texas | 48249 | 6862 | 158 |
1752677 | 1752677 | 2021-09-25 | Graves | Kentucky | 21083 | 6862 | 116 |
1749428 | 1749428 | 2021-09-24 | Graves | Kentucky | 21083 | 6862 | 116 |
1723968 | 1723968 | 2021-09-16 | Pettis | Missouri | 29159 | 6862 | 94 |
1697496 | 1697496 | 2021-09-08 | Nelson | Kentucky | 21179 | 6862 | 70 |
1673740 | 1673740 | 2021-09-01 | Kenai Peninsula Borough | Alaska | 2122 | 6862 | 27 |
1669462 | 1669462 | 2021-08-30 | Indiana | Pennsylvania | 42063 | 6862 | 182 |
1664077 | 1664077 | 2021-08-29 | Mississippi | Arkansas | 5093 | 6862 | 118 |
1595196 | 1595196 | 2021-08-07 | Hunt | Texas | 48231 | 6862 | 182 |
1559276 | 1559276 | 2021-07-27 | Gibson | Tennessee | 47053 | 6862 | 152 |
1556012 | 1556012 | 2021-07-26 | Carter | Tennessee | 47019 | 6862 | 162 |
1556209 | 1556209 | 2021-07-26 | Hood | Texas | 48221 | 6862 | 137 |
1552962 | 1552962 | 2021-07-25 | Hood | Texas | 48221 | 6862 | 137 |
1549715 | 1549715 | 2021-07-24 | Hood | Texas | 48221 | 6862 | 137 |
1537058 | 1537058 | 2021-07-20 | Cowlitz | Washington | 53015 | 6862 | 97 |
1442885 | 1442885 | 2021-06-21 | Rockingham | Virginia | 51165 | 6862 | 112 |
1439640 | 1439640 | 2021-06-20 | Rockingham | Virginia | 51165 | 6862 | 112 |
1436393 | 1436393 | 2021-06-19 | Rockingham | Virginia | 51165 | 6862 | 112 |
1392244 | 1392244 | 2021-06-06 | McCracken | Kentucky | 21145 | 6862 | 131 |
1388999 | 1388999 | 2021-06-05 | McCracken | Kentucky | 21145 | 6862 | 131 |
1358714 | 1358714 | 2021-05-27 | Blount | Alabama | 1009 | 6862 | 139 |
1347546 | 1347546 | 2021-05-23 | Eddy | New Mexico | 35015 | 6862 | 130 |
1344298 | 1344298 | 2021-05-22 | Eddy | New Mexico | 35015 | 6862 | 130 |
1341050 | 1341050 | 2021-05-21 | Eddy | New Mexico | 35015 | 6862 | 130 |
1257357 | 1257357 | 2021-04-25 | Coffee | Tennessee | 47031 | 6862 | 121 |
1254110 | 1254110 | 2021-04-24 | Coffee | Tennessee | 47031 | 6862 | 121 |
1250863 | 1250863 | 2021-04-23 | Coffee | Tennessee | 47031 | 6862 | 121 |
1133395 | 1133395 | 2021-03-18 | Rutherford | North Carolina | 37161 | 6862 | 201 |
1096210 | 1096210 | 2021-03-07 | Rockdale | Georgia | 13247 | 6862 | 153 |
1024078 | 1024078 | 2021-02-12 | Roanoke | Virginia | 51161 | 6862 | 89 |
996997 | 996997 | 2021-02-04 | Brunswick | North Carolina | 37019 | 6862 | 103 |
980367 | 980367 | 2021-01-30 | Cass | Missouri | 29037 | 6862 | 69 |
935658 | 935658 | 2021-01-16 | Jackson | Oregon | 41029 | 6862 | 84 |
919399 | 919399 | 2021-01-11 | Payne | Oklahoma | 40119 | 6862 | 33 |
875024 | 875024 | 2020-12-29 | Cullman | Alabama | 1043 | 6862 | 76 |
845893 | 845893 | 2020-12-20 | Apache | Arizona | 4001 | 6862 | 218 |
835111 | 835111 | 2020-12-16 | Lackawanna | Pennsylvania | 42069 | 6862 | 253 |
781486 | 781486 | 2020-11-30 | Twin Falls | Idaho | 16083 | 6862 | 91 |
759154 | 759154 | 2020-11-23 | Shawnee | Kansas | 20177 | 6862 | 115 |
679788 | 679788 | 2020-10-29 | Hays | Texas | 48209 | 6862 | 87 |
556107 | 556107 | 2020-09-21 | Berks | Pennsylvania | 42011 | 6862 | 391 |
443232 | 443232 | 2020-08-17 | Hamilton | Tennessee | 47065 | 6862 | 62 |
422465 | 422465 | 2020-08-11 | Calcasieu | Louisiana | 22019 | 6862 | 146 |
235792 | 235792 | 2020-06-13 | Mecklenburg | North Carolina | 37119 | 6862 | 125 |
37006 | 37006 | 2020-04-06 | Bergen | New Jersey | 34003 | 6862 | 200 |
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);