ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 4992 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 12
- Georgia 9
- Minnesota 8
- Oklahoma 8
- Wisconsin 8
- Missouri 6
- Michigan 5
- Texas 5
- Virginia 5
- Arkansas 4
- New York 4
- Pennsylvania 4
- Tennessee 4
- Alaska 3
- California 3
- Indiana 3
- Alabama 2
- Florida 2
- New Jersey 2
- South Carolina 2
- Washington 2
- Arizona 1
- Colorado 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Mississippi 1
- North Dakota 1
- Puerto Rico 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499654 | 2499654 | 2022-05-13 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2496396 | 2496396 | 2022-05-12 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2493138 | 2493138 | 2022-05-11 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2362571 | 2362571 | 2022-03-31 | King George | Virginia | 51099 | 4992 | 38 |
2335557 | 2335557 | 2022-03-23 | Yancey | North Carolina | 37199 | 4992 | 51 |
2313884 | 2313884 | 2022-03-16 | Brooke | West Virginia | 54009 | 4992 | 103 |
2237595 | 2237595 | 2022-02-21 | Vernon | Missouri | 29217 | 4992 | 99 |
2234344 | 2234344 | 2022-02-20 | Vernon | Missouri | 29217 | 4992 | 99 |
2231093 | 2231093 | 2022-02-19 | Vernon | Missouri | 29217 | 4992 | 99 |
2227842 | 2227842 | 2022-02-18 | Vernon | Missouri | 29217 | 4992 | 99 |
2206731 | 2206731 | 2022-02-12 | Butler | Alabama | 1013 | 4992 | 112 |
2195634 | 2195634 | 2022-02-08 | Caswell | North Carolina | 37033 | 4992 | 40 |
2176573 | 2176573 | 2022-02-02 | Las Piedras | Puerto Rico | 72085 | 4992 | |
2154795 | 2154795 | 2022-01-27 | Conway | Arkansas | 5029 | 4992 | 50 |
2145362 | 2145362 | 2022-01-24 | Franklin | Georgia | 13119 | 4992 | 90 |
2081173 | 2081173 | 2022-01-04 | Oceana | Michigan | 26127 | 4992 | 84 |
2077921 | 2077921 | 2022-01-03 | Oceana | Michigan | 26127 | 4992 | 84 |
2051979 | 2051979 | 2021-12-26 | Le Sueur | Minnesota | 27079 | 4992 | 41 |
2048729 | 2048729 | 2021-12-25 | Le Sueur | Minnesota | 27079 | 4992 | 41 |
2044290 | 2044290 | 2021-12-24 | St. Francis | Arkansas | 5123 | 4992 | 72 |
2045479 | 2045479 | 2021-12-24 | Le Sueur | Minnesota | 27079 | 4992 | 41 |
2042229 | 2042229 | 2021-12-23 | Le Sueur | Minnesota | 27079 | 4992 | 41 |
2037170 | 2037170 | 2021-12-21 | Palo Pinto | Texas | 48363 | 4992 | 126 |
2028594 | 2028594 | 2021-12-19 | Greene | Indiana | 18055 | 4992 | 108 |
2025343 | 2025343 | 2021-12-18 | Greene | Indiana | 18055 | 4992 | 108 |
2022092 | 2022092 | 2021-12-17 | Greene | Indiana | 18055 | 4992 | 108 |
2008590 | 2008590 | 2021-12-13 | Siskiyou | California | 6093 | 4992 | 75 |
1911010 | 1911010 | 2021-11-13 | Poinsett | Arkansas | 5111 | 4992 | 101 |
1900911 | 1900911 | 2021-11-09 | Clallam | Washington | 53009 | 4992 | 67 |
1883877 | 1883877 | 2021-11-04 | Clarion | Pennsylvania | 42031 | 4992 | 128 |
1781902 | 1781902 | 2021-10-04 | Clay | Kentucky | 21051 | 4992 | 55 |
1780189 | 1780189 | 2021-10-03 | Hardeman | Tennessee | 47069 | 4992 | 77 |
1776939 | 1776939 | 2021-10-02 | Hardeman | Tennessee | 47069 | 4992 | 77 |
1773689 | 1773689 | 2021-10-01 | Hardeman | Tennessee | 47069 | 4992 | 77 |
1762961 | 1762961 | 2021-09-28 | Polk | Missouri | 29167 | 4992 | 52 |
1722891 | 1722891 | 2021-09-16 | Pickens | Georgia | 13227 | 4992 | 93 |
1709935 | 1709935 | 2021-09-12 | Upson | Georgia | 13293 | 4992 | 138 |
1706688 | 1706688 | 2021-09-11 | Upson | Georgia | 13293 | 4992 | 138 |
1708022 | 1708022 | 2021-09-11 | Livingston | New York | 36051 | 4992 | 63 |
1703440 | 1703440 | 2021-09-10 | Upson | Georgia | 13293 | 4992 | 138 |
1691773 | 1691773 | 2021-09-06 | Fulton | New York | 36035 | 4992 | 95 |
1691913 | 1691913 | 2021-09-06 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1688663 | 1688663 | 2021-09-05 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1685413 | 1685413 | 2021-09-04 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1682162 | 1682162 | 2021-09-03 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1649535 | 1649535 | 2021-08-24 | Clinton | New York | 36019 | 4992 | 33 |
1631636 | 1631636 | 2021-08-19 | Lake | California | 6033 | 4992 | 69 |
1632808 | 1632808 | 2021-08-19 | Mower | Minnesota | 27099 | 4992 | 34 |
1634628 | 1634628 | 2021-08-19 | Monroe | Wisconsin | 55081 | 4992 | 51 |
1619748 | 1619748 | 2021-08-15 | Newaygo | Michigan | 26123 | 4992 | 69 |
1620025 | 1620025 | 2021-08-15 | Platte | Missouri | 29165 | 4992 | 53 |
1616500 | 1616500 | 2021-08-14 | Newaygo | Michigan | 26123 | 4992 | 69 |
1613252 | 1613252 | 2021-08-13 | Newaygo | Michigan | 26123 | 4992 | 69 |
1550653 | 1550653 | 2021-07-25 | Colquitt | Georgia | 13071 | 4992 | 131 |
1547406 | 1547406 | 2021-07-24 | Colquitt | Georgia | 13071 | 4992 | 131 |
1544159 | 1544159 | 2021-07-23 | Colquitt | Georgia | 13071 | 4992 | 131 |
1494726 | 1494726 | 2021-07-07 | Campbell | Virginia | 51031 | 4992 | 101 |
1467806 | 1467806 | 2021-06-29 | Vance | North Carolina | 37181 | 4992 | 89 |
1439805 | 1439805 | 2021-06-20 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1436558 | 1436558 | 2021-06-19 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1433311 | 1433311 | 2021-06-18 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1417050 | 1417050 | 2021-06-13 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1413804 | 1413804 | 2021-06-12 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1410559 | 1410559 | 2021-06-11 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1400706 | 1400706 | 2021-06-08 | Washington | Virginia | 51191 | 4992 | 110 |
1358689 | 1358689 | 2021-05-26 | Campbell | Wyoming | 56005 | 4992 | 60 |
1299472 | 1299472 | 2021-05-08 | Newberry | South Carolina | 45071 | 4992 | 103 |
1296560 | 1296560 | 2021-05-07 | Medina | Texas | 48325 | 4992 | 103 |
1225428 | 1225428 | 2021-04-15 | Skagit | Washington | 53057 | 4992 | 67 |
1181449 | 1181449 | 2021-04-02 | Benton | Minnesota | 27009 | 4992 | 95 |
1172600 | 1172600 | 2021-03-30 | Washington | Oklahoma | 40147 | 4992 | 94 |
1169353 | 1169353 | 2021-03-29 | Washington | Oklahoma | 40147 | 4992 | 94 |
1166105 | 1166105 | 2021-03-28 | Washington | Oklahoma | 40147 | 4992 | 94 |
1162857 | 1162857 | 2021-03-27 | Washington | Oklahoma | 40147 | 4992 | 94 |
1159418 | 1159418 | 2021-03-26 | Morton | North Dakota | 38059 | 4992 | 98 |
1159608 | 1159608 | 2021-03-26 | Washington | Oklahoma | 40147 | 4992 | 94 |
1156361 | 1156361 | 2021-03-25 | Washington | Oklahoma | 40147 | 4992 | 94 |
1153114 | 1153114 | 2021-03-24 | Washington | Oklahoma | 40147 | 4992 | 94 |
1142957 | 1142957 | 2021-03-21 | Salem | New Jersey | 34033 | 4992 | 167 |
1143112 | 1143112 | 2021-03-21 | McDowell | North Carolina | 37111 | 4992 | 62 |
1139865 | 1139865 | 2021-03-20 | McDowell | North Carolina | 37111 | 4992 | 62 |
1136039 | 1136039 | 2021-03-19 | Otter Tail | Minnesota | 27111 | 4992 | 71 |
1134133 | 1134133 | 2021-03-18 | Hardin | Texas | 48199 | 4992 | 102 |
1130885 | 1130885 | 2021-03-17 | Hardin | Texas | 48199 | 4992 | 101 |
1122560 | 1122560 | 2021-03-15 | Webster | Iowa | 19187 | 4992 | 88 |
1123935 | 1123935 | 2021-03-15 | Armstrong | Pennsylvania | 42005 | 4992 | 116 |
1068432 | 1068432 | 2021-02-26 | Halifax | North Carolina | 37083 | 4992 | 97 |
1054153 | 1054153 | 2021-02-22 | Knox | Illinois | 17095 | 4992 | 156 |
1027921 | 1027921 | 2021-02-14 | Suwannee | Florida | 12121 | 4992 | 119 |
1029431 | 1029431 | 2021-02-14 | St. Lawrence | New York | 36089 | 4992 | 75 |
1000795 | 1000795 | 2021-02-05 | Brown | South Dakota | 46013 | 4992 | 79 |
991140 | 991140 | 2021-02-02 | Dyer | Tennessee | 47045 | 4992 | 90 |
991800 | 991800 | 2021-02-02 | Shawano | Wisconsin | 55115 | 4992 | 80 |
959721 | 959721 | 2021-01-24 | Flagler | Florida | 12035 | 4992 | 60 |
949803 | 949803 | 2021-01-21 | Mississippi | Arkansas | 5093 | 4992 | 103 |
945916 | 945916 | 2021-01-19 | Lamar | Texas | 48277 | 4992 | 112 |
936399 | 936399 | 2021-01-16 | Harrisonburg city | Virginia | 51660 | 4992 | 52 |
932471 | 932471 | 2021-01-15 | Lawrence | Pennsylvania | 42073 | 4992 | 144 |
886189 | 886189 | 2021-01-01 | Lauderdale | Mississippi | 28075 | 4992 | 171 |
825283 | 825283 | 2020-12-13 | Payne | Oklahoma | 40119 | 4992 | 24 |
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);