ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 5626 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 7
- Wisconsin 7
- Illinois 5
- Virginia 4
- South Dakota 3
- Tennessee 3
- Arkansas 2
- Colorado 2
- Florida 2
- Georgia 2
- Kansas 2
- Louisiana 2
- Minnesota 2
- Mississippi 2
- Missouri 2
- New Jersey 2
- New York 2
- Puerto Rico 2
- South Carolina 2
- Texas 2
- Utah 2
- Alabama 1
- California 1
- Delaware 1
- Indiana 1
- Iowa 1
- Maine 1
- Maryland 1
- North Dakota 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473280 | 2473280 | 2022-05-04 | Page | Virginia | 51139 | 5626 | 120 |
2465118 | 2465118 | 2022-05-02 | Martin | Minnesota | 27091 | 5626 | 64 |
2360887 | 2360887 | 2022-03-31 | Otsego | Michigan | 26137 | 5626 | 99 |
2357633 | 2357633 | 2022-03-30 | Otsego | Michigan | 26137 | 5626 | 99 |
2354380 | 2354380 | 2022-03-29 | Otsego | Michigan | 26137 | 5626 | 99 |
2334740 | 2334740 | 2022-03-23 | Franklin | Maine | 23007 | 5626 | 57 |
2303656 | 2303656 | 2022-03-13 | Austin | Texas | 48015 | 5626 | 71 |
2282013 | 2282013 | 2022-03-07 | Pierce | Georgia | 13229 | 5626 | 124 |
2284692 | 2284692 | 2022-03-07 | Jackson | Wisconsin | 55053 | 5626 | 41 |
2281440 | 2281440 | 2022-03-06 | Jackson | Wisconsin | 55053 | 5626 | 41 |
2278187 | 2278187 | 2022-03-05 | Jackson | Wisconsin | 55053 | 5626 | 41 |
2274934 | 2274934 | 2022-03-04 | Jackson | Wisconsin | 55053 | 5626 | 41 |
2248091 | 2248091 | 2022-02-24 | Cayey | Puerto Rico | 72035 | 5626 | |
2228606 | 2228606 | 2022-02-18 | Juana Diaz | Puerto Rico | 72075 | 5626 | |
2212988 | 2212988 | 2022-02-13 | Mecklenburg | Virginia | 51117 | 5626 | 106 |
2209735 | 2209735 | 2022-02-12 | Mecklenburg | Virginia | 51117 | 5626 | 106 |
2206482 | 2206482 | 2022-02-11 | Mecklenburg | Virginia | 51117 | 5626 | 106 |
2190717 | 2190717 | 2022-02-07 | Delta | Colorado | 8029 | 5626 | 125 |
2127441 | 2127441 | 2022-01-18 | Stutsman | North Dakota | 38093 | 5626 | 92 |
2103310 | 2103310 | 2022-01-11 | Saline | Illinois | 17165 | 5626 | 95 |
2104111 | 2104111 | 2022-01-11 | Tate | Mississippi | 28137 | 5626 | 121 |
2087327 | 2087327 | 2022-01-06 | Miami | Kansas | 20121 | 5626 | 75 |
2084075 | 2084075 | 2022-01-05 | Miami | Kansas | 20121 | 5626 | 75 |
2037604 | 2037604 | 2021-12-21 | Park | Wyoming | 56029 | 5626 | 117 |
2017762 | 2017762 | 2021-12-15 | Uintah | Utah | 49047 | 5626 | 54 |
2004997 | 2004997 | 2021-12-11 | Randolph | West Virginia | 54083 | 5626 | 58 |
1770609 | 1770609 | 2021-09-30 | Hill | Texas | 48217 | 5626 | 134 |
1759601 | 1759601 | 2021-09-27 | Pike | Mississippi | 28113 | 5626 | 138 |
1744791 | 1744791 | 2021-09-22 | Wasatch | Utah | 49051 | 5626 | 27 |
1631928 | 1631928 | 2021-08-19 | Murray | Georgia | 13213 | 5626 | 94 |
1530884 | 1530884 | 2021-07-19 | Hot Spring | Arkansas | 5059 | 5626 | 78 |
1434929 | 1434929 | 2021-06-19 | Newton | Missouri | 29145 | 5626 | 80 |
1431682 | 1431682 | 2021-06-18 | Newton | Missouri | 29145 | 5626 | 80 |
1420390 | 1420390 | 2021-06-15 | Coffee | Alabama | 1031 | 5626 | 127 |
1401550 | 1401550 | 2021-06-09 | Knox | Illinois | 17095 | 5626 | 183 |
1398305 | 1398305 | 2021-06-08 | Knox | Illinois | 17095 | 5626 | 183 |
1395058 | 1395058 | 2021-06-07 | Knox | Illinois | 17095 | 5626 | 183 |
1370913 | 1370913 | 2021-05-30 | Brown | South Dakota | 46013 | 5626 | 93 |
1367667 | 1367667 | 2021-05-29 | Brown | South Dakota | 46013 | 5626 | 93 |
1364421 | 1364421 | 2021-05-28 | Brown | South Dakota | 46013 | 5626 | 93 |
1347045 | 1347045 | 2021-05-23 | Tuscola | Michigan | 26157 | 5626 | 174 |
1343797 | 1343797 | 2021-05-22 | Tuscola | Michigan | 26157 | 5626 | 174 |
1310767 | 1310767 | 2021-05-12 | Noble | Indiana | 18113 | 5626 | 87 |
1261649 | 1261649 | 2021-04-27 | Gadsden | Florida | 12039 | 5626 | 93 |
1230904 | 1230904 | 2021-04-17 | Belmont | Ohio | 39013 | 5626 | 158 |
1206017 | 1206017 | 2021-04-09 | Columbia | Wisconsin | 55021 | 5626 | 68 |
1181441 | 1181441 | 2021-04-02 | Van Buren | Michigan | 26159 | 5626 | 100 |
1143726 | 1143726 | 2021-03-21 | Lawrence | Tennessee | 47099 | 5626 | 86 |
1140479 | 1140479 | 2021-03-20 | Lawrence | Tennessee | 47099 | 5626 | 86 |
1137233 | 1137233 | 2021-03-19 | Lawrence | Tennessee | 47099 | 5626 | 86 |
1128776 | 1128776 | 2021-03-17 | Clinton | Illinois | 17027 | 5626 | 98 |
1121578 | 1121578 | 2021-03-14 | Barron | Wisconsin | 55005 | 5626 | 76 |
1050386 | 1050386 | 2021-02-21 | Crittenden | Arkansas | 5035 | 5626 | 94 |
1048891 | 1048891 | 2021-02-20 | Ontario | New York | 36069 | 5626 | 88 |
1037642 | 1037642 | 2021-02-17 | Monroe | Florida | 12087 | 5626 | 44 |
1038547 | 1038547 | 2021-02-17 | Gratiot | Michigan | 26057 | 5626 | 103 |
987787 | 987787 | 2021-02-01 | Kershaw | South Carolina | 45055 | 5626 | 100 |
954703 | 954703 | 2021-01-22 | Warren | New Jersey | 34041 | 5626 | 193 |
934644 | 934644 | 2021-01-16 | Wicomico | Maryland | 24045 | 5626 | 101 |
895868 | 895868 | 2021-01-04 | Rice | Minnesota | 27131 | 5626 | 57 |
829533 | 829533 | 2020-12-14 | St. Croix | Wisconsin | 55109 | 5626 | 22 |
668137 | 668137 | 2020-10-26 | Black Hawk | Iowa | 19013 | 5626 | 98 |
614600 | 614600 | 2020-10-09 | Berkeley | South Carolina | 45015 | 5626 | 91 |
526515 | 526515 | 2020-09-12 | Somerset | New Jersey | 34035 | 5626 | 568 |
445083 | 445083 | 2020-08-18 | St. Tammany | Louisiana | 22103 | 5626 | 221 |
373317 | 373317 | 2020-07-27 | Adams | Colorado | 8001 | 5626 | 167 |
374195 | 374195 | 2020-07-27 | Calcasieu | Louisiana | 22019 | 5626 | 107 |
336817 | 336817 | 2020-07-15 | Tulsa | Oklahoma | 40143 | 5626 | 79 |
315853 | 315853 | 2020-07-09 | New Castle | Delaware | 10003 | 5626 | 249 |
293575 | 293575 | 2020-07-02 | Fresno | California | 6019 | 5626 | 77 |
174141 | 174141 | 2020-05-24 | Erie | New York | 36029 | 5626 | 484 |
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);