ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Texas 9
- Indiana 8
- Missouri 7
- North Dakota 7
- Oklahoma 7
- Idaho 6
- Mississippi 5
- Colorado 4
- Kentucky 4
- Ohio 4
- Maryland 3
- New York 3
- Washington 3
- Wisconsin 3
- Arkansas 2
- Florida 2
- Louisiana 2
- Michigan 2
- Tennessee 2
- California 1
- Georgia 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500139 | 2500139 | 2022-05-13 | Blaine | Idaho | 16013 | 6059 | 30 |
2501043 | 2501043 | 2022-05-13 | Newton | Mississippi | 28101 | 6059 | 98 |
2497785 | 2497785 | 2022-05-12 | Newton | Mississippi | 28101 | 6059 | 98 |
2494527 | 2494527 | 2022-05-11 | Newton | Mississippi | 28101 | 6059 | 98 |
2491269 | 2491269 | 2022-05-10 | Newton | Mississippi | 28101 | 6059 | 98 |
2488012 | 2488012 | 2022-05-09 | Newton | Mississippi | 28101 | 6059 | 98 |
2452770 | 2452770 | 2022-04-28 | Rolette | North Dakota | 38079 | 6059 | 43 |
2449514 | 2449514 | 2022-04-27 | Rolette | North Dakota | 38079 | 6059 | 43 |
2446257 | 2446257 | 2022-04-26 | Rolette | North Dakota | 38079 | 6059 | 43 |
2443002 | 2443002 | 2022-04-25 | Rolette | North Dakota | 38079 | 6059 | 43 |
2439746 | 2439746 | 2022-04-24 | Rolette | North Dakota | 38079 | 6059 | 43 |
2436490 | 2436490 | 2022-04-23 | Rolette | North Dakota | 38079 | 6059 | 43 |
2433234 | 2433234 | 2022-04-22 | Rolette | North Dakota | 38079 | 6059 | 43 |
2406347 | 2406347 | 2022-04-14 | Caroline | Maryland | 24011 | 6059 | 80 |
2403777 | 2403777 | 2022-04-13 | Seneca | New York | 36099 | 6059 | 89 |
2356905 | 2356905 | 2022-03-30 | Jerome | Idaho | 16053 | 6059 | 64 |
2347147 | 2347147 | 2022-03-27 | Jerome | Idaho | 16053 | 6059 | 64 |
2343894 | 2343894 | 2022-03-26 | Jerome | Idaho | 16053 | 6059 | 64 |
2340641 | 2340641 | 2022-03-25 | Jerome | Idaho | 16053 | 6059 | 64 |
2297887 | 2297887 | 2022-03-12 | Carroll | Arkansas | 5015 | 6059 | 97 |
2297265 | 2297265 | 2022-03-11 | Jasper | Texas | 48241 | 6059 | 183 |
2294013 | 2294013 | 2022-03-10 | Jasper | Texas | 48241 | 6059 | 183 |
2290761 | 2290761 | 2022-03-09 | Jasper | Texas | 48241 | 6059 | 181 |
2287509 | 2287509 | 2022-03-08 | Jasper | Texas | 48241 | 6059 | 181 |
2279822 | 2279822 | 2022-03-06 | Miller | Missouri | 29131 | 6059 | 114 |
2276569 | 2276569 | 2022-03-05 | Miller | Missouri | 29131 | 6059 | 114 |
2273316 | 2273316 | 2022-03-04 | Miller | Missouri | 29131 | 6059 | 114 |
2270064 | 2270064 | 2022-03-03 | Miller | Missouri | 29131 | 6059 | 114 |
2239739 | 2239739 | 2022-02-22 | Peach | Georgia | 13225 | 6059 | 119 |
2210277 | 2210277 | 2022-02-13 | Routt | Colorado | 8107 | 6059 | 24 |
2207024 | 2207024 | 2022-02-12 | Routt | Colorado | 8107 | 6059 | 24 |
2203771 | 2203771 | 2022-02-11 | Routt | Colorado | 8107 | 6059 | 24 |
2056446 | 2056446 | 2021-12-27 | Marion | Tennessee | 47115 | 6059 | 110 |
1977060 | 1977060 | 2021-12-03 | Calvert | Maryland | 24009 | 6059 | 102 |
1939943 | 1939943 | 2021-11-21 | Whitman | Washington | 53075 | 6059 | 82 |
1936693 | 1936693 | 2021-11-20 | Whitman | Washington | 53075 | 6059 | 82 |
1932474 | 1932474 | 2021-11-19 | Preble | Ohio | 39135 | 6059 | 137 |
1933443 | 1933443 | 2021-11-19 | Whitman | Washington | 53075 | 6059 | 82 |
1893246 | 1893246 | 2021-11-07 | Warren | New York | 36113 | 6059 | 88 |
1857702 | 1857702 | 2021-10-27 | Highland | Ohio | 39071 | 6059 | 104 |
1821944 | 1821944 | 2021-10-16 | Defiance | Ohio | 39039 | 6059 | 102 |
1750253 | 1750253 | 2021-09-24 | Herkimer | New York | 36043 | 6059 | 117 |
1740833 | 1740833 | 2021-09-21 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1737584 | 1737584 | 2021-09-20 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1734334 | 1734334 | 2021-09-19 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1731084 | 1731084 | 2021-09-18 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1727834 | 1727834 | 2021-09-17 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1724585 | 1724585 | 2021-09-16 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1721336 | 1721336 | 2021-09-15 | Mayes | Oklahoma | 40097 | 6059 | 86 |
1717061 | 1717061 | 2021-09-14 | St. John the Baptist | Louisiana | 22095 | 6059 | 156 |
1690648 | 1690648 | 2021-09-06 | Jackson | Indiana | 18071 | 6059 | 80 |
1690914 | 1690914 | 2021-09-06 | Barren | Kentucky | 21009 | 6059 | 109 |
1687398 | 1687398 | 2021-09-05 | Jackson | Indiana | 18071 | 6059 | 80 |
1687664 | 1687664 | 2021-09-05 | Barren | Kentucky | 21009 | 6059 | 109 |
1684148 | 1684148 | 2021-09-04 | Jackson | Indiana | 18071 | 6059 | 80 |
1684414 | 1684414 | 2021-09-04 | Barren | Kentucky | 21009 | 6059 | 109 |
1680897 | 1680897 | 2021-09-03 | Jackson | Indiana | 18071 | 6059 | 80 |
1681163 | 1681163 | 2021-09-03 | Barren | Kentucky | 21009 | 6059 | 109 |
1614089 | 1614089 | 2021-08-13 | Union | Ohio | 39159 | 6059 | 49 |
1603456 | 1603456 | 2021-08-10 | Branch | Michigan | 26023 | 6059 | 121 |
1600207 | 1600207 | 2021-08-09 | Branch | Michigan | 26023 | 6059 | 121 |
1505480 | 1505480 | 2021-07-11 | Cass | Indiana | 18017 | 6059 | 112 |
1502234 | 1502234 | 2021-07-10 | Cass | Indiana | 18017 | 6059 | 112 |
1498988 | 1498988 | 2021-07-09 | Cass | Indiana | 18017 | 6059 | 112 |
1463789 | 1463789 | 2021-06-28 | St. Mary's | Maryland | 24037 | 6059 | 132 |
1462476 | 1462476 | 2021-06-27 | Barron | Wisconsin | 55005 | 6059 | 86 |
1459231 | 1459231 | 2021-06-26 | Barron | Wisconsin | 55005 | 6059 | 86 |
1455986 | 1455986 | 2021-06-25 | Barron | Wisconsin | 55005 | 6059 | 86 |
1305062 | 1305062 | 2021-05-10 | Joplin | Missouri | 6059 | 106 | |
1301816 | 1301816 | 2021-05-09 | Joplin | Missouri | 6059 | 106 | |
1228974 | 1228974 | 2021-04-17 | Greene | Arkansas | 5055 | 6059 | 75 |
1213320 | 1213320 | 2021-04-12 | Dubois | Indiana | 18037 | 6059 | 118 |
1170729 | 1170729 | 2021-03-30 | Jackson | Florida | 12063 | 6059 | 154 |
1127501 | 1127501 | 2021-03-16 | McMinn | Tennessee | 47107 | 6059 | 93 |
1121141 | 1121141 | 2021-03-14 | Hale | Texas | 48189 | 6059 | 153 |
1117894 | 1117894 | 2021-03-13 | Hale | Texas | 48189 | 6059 | 153 |
1114647 | 1114647 | 2021-03-12 | Hale | Texas | 48189 | 6059 | 152 |
1109050 | 1109050 | 2021-03-11 | Monroe | Florida | 12087 | 6059 | 47 |
1111401 | 1111401 | 2021-03-11 | Hale | Texas | 48189 | 6059 | 152 |
1015147 | 1015147 | 2021-02-10 | Madison | Idaho | 16065 | 6059 | 21 |
660022 | 660022 | 2020-10-23 | Beaufort | South Carolina | 45013 | 6059 | 91 |
596244 | 596244 | 2020-10-04 | Jefferson | Colorado | 8059 | 6059 | 255 |
541129 | 541129 | 2020-09-17 | Solano | California | 6095 | 6059 | 55 |
477803 | 477803 | 2020-08-28 | St. Louis city | Missouri | 29510 | 6059 | 188 |
414426 | 414426 | 2020-08-08 | Lubbock | Texas | 48303 | 6059 | 80 |
90714 | 90714 | 2020-04-26 | Jefferson | Louisiana | 22051 | 6059 | 329 |
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);