ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where cases = 5580 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Michigan 11
- Minnesota 9
- Virginia 8
- Oklahoma 7
- Georgia 6
- Kentucky 5
- Ohio 5
- Texas 5
- Missouri 4
- Maryland 3
- North Carolina 3
- Washington 3
- Florida 2
- Illinois 2
- Mississippi 2
- Pennsylvania 2
- Tennessee 2
- West Virginia 2
- Arkansas 1
- Colorado 1
- Nebraska 1
- New York 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- Vermont 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494470 | 2494470 | 2022-05-11 | Waseca | Minnesota | 27161 | 5580 | 39 |
2468270 | 2468270 | 2022-05-03 | Gladwin | Michigan | 26051 | 5580 | 114 |
2465015 | 2465015 | 2022-05-02 | Gladwin | Michigan | 26051 | 5580 | 114 |
2461759 | 2461759 | 2022-05-01 | Gladwin | Michigan | 26051 | 5580 | 114 |
2458503 | 2458503 | 2022-04-30 | Gladwin | Michigan | 26051 | 5580 | 114 |
2455247 | 2455247 | 2022-04-29 | Gladwin | Michigan | 26051 | 5580 | 114 |
2451991 | 2451991 | 2022-04-28 | Gladwin | Michigan | 26051 | 5580 | 114 |
2448735 | 2448735 | 2022-04-27 | Gladwin | Michigan | 26051 | 5580 | 114 |
2416130 | 2416130 | 2022-04-17 | Talbot | Maryland | 24041 | 5580 | 86 |
2412874 | 2412874 | 2022-04-16 | Talbot | Maryland | 24041 | 5580 | 86 |
2409618 | 2409618 | 2022-04-15 | Talbot | Maryland | 24041 | 5580 | 86 |
2359121 | 2359121 | 2022-03-30 | Moore | Texas | 48341 | 5580 | 110 |
2355867 | 2355867 | 2022-03-29 | Moore | Texas | 48341 | 5580 | 110 |
2338051 | 2338051 | 2022-03-24 | Alpena | Michigan | 26007 | 5580 | 134 |
2334797 | 2334797 | 2022-03-23 | Alpena | Michigan | 26007 | 5580 | 134 |
2336465 | 2336465 | 2022-03-23 | Caledonia | Vermont | 50005 | 5580 | 24 |
2282934 | 2282934 | 2022-03-07 | Chickasaw | Mississippi | 28017 | 5580 | 95 |
2228889 | 2228889 | 2022-02-18 | Calhoun | Texas | 48057 | 5580 | 45 |
2203335 | 2203335 | 2022-02-10 | Hampshire | West Virginia | 54027 | 5580 | 64 |
2188578 | 2188578 | 2022-02-06 | Meeker | Minnesota | 27093 | 5580 | 73 |
2185325 | 2185325 | 2022-02-05 | Meeker | Minnesota | 27093 | 5580 | 73 |
2182073 | 2182073 | 2022-02-04 | Meeker | Minnesota | 27093 | 5580 | 73 |
2150416 | 2150416 | 2022-01-25 | Lincoln | Oregon | 41041 | 5580 | 64 |
2147904 | 2147904 | 2022-01-24 | Hopewell city | Virginia | 51670 | 5580 | 99 |
2119362 | 2119362 | 2022-01-16 | Lee | Georgia | 13177 | 5580 | 87 |
2116110 | 2116110 | 2022-01-15 | Lee | Georgia | 13177 | 5580 | 87 |
2112859 | 2112859 | 2022-01-14 | Lee | Georgia | 13177 | 5580 | 87 |
2087750 | 2087750 | 2022-01-06 | Nobles | Minnesota | 27105 | 5580 | 56 |
2085213 | 2085213 | 2022-01-05 | Hardin | Ohio | 39065 | 5580 | 123 |
2074440 | 2074440 | 2022-01-02 | Marshall | Kentucky | 21157 | 5580 | 85 |
2071189 | 2071189 | 2022-01-01 | Marshall | Kentucky | 21157 | 5580 | 85 |
2067938 | 2067938 | 2021-12-31 | Marshall | Kentucky | 21157 | 5580 | 85 |
2064687 | 2064687 | 2021-12-30 | Marshall | Kentucky | 21157 | 5580 | 85 |
2061437 | 2061437 | 2021-12-29 | Marshall | Kentucky | 21157 | 5580 | 85 |
2036229 | 2036229 | 2021-12-21 | Greene | New York | 36039 | 5580 | 94 |
2017596 | 2017596 | 2021-12-15 | Hopkins | Texas | 48223 | 5580 | 149 |
2013162 | 2013162 | 2021-12-14 | Lawrence | Missouri | 29109 | 5580 | 137 |
2014059 | 2014059 | 2021-12-14 | Marion | South Carolina | 45067 | 5580 | 143 |
1995245 | 1995245 | 2021-12-08 | Randolph | West Virginia | 54083 | 5580 | 57 |
1964435 | 1964435 | 2021-11-29 | Pulaski | Missouri | 29169 | 5580 | 97 |
1932446 | 1932446 | 2021-11-19 | Jackson | Ohio | 39079 | 5580 | 92 |
1917152 | 1917152 | 2021-11-14 | Wise | Virginia | 51195 | 5580 | 129 |
1913902 | 1913902 | 2021-11-13 | Wise | Virginia | 51195 | 5580 | 129 |
1910652 | 1910652 | 2021-11-12 | Wise | Virginia | 51195 | 5580 | 129 |
1897839 | 1897839 | 2021-11-08 | Sheridan | Wyoming | 56033 | 5580 | 50 |
1856285 | 1856285 | 2021-10-27 | Randolph | Illinois | 17157 | 5580 | 107 |
1812246 | 1812246 | 2021-10-13 | Preble | Ohio | 39135 | 5580 | 120 |
1792038 | 1792038 | 2021-10-07 | Alcorn | Mississippi | 28003 | 5580 | 96 |
1759878 | 1759878 | 2021-09-27 | Scotts Bluff | Nebraska | 31157 | 5580 | 96 |
1740219 | 1740219 | 2021-09-21 | Platte | Missouri | 29165 | 5580 | 58 |
1733515 | 1733515 | 2021-09-19 | Mower | Minnesota | 27099 | 5580 | 38 |
1730265 | 1730265 | 2021-09-18 | Mower | Minnesota | 27099 | 5580 | 38 |
1727015 | 1727015 | 2021-09-17 | Mower | Minnesota | 27099 | 5580 | 38 |
1711798 | 1711798 | 2021-09-12 | Toa Alta | Puerto Rico | 72135 | 5580 | |
1678489 | 1678489 | 2021-09-02 | Phelps | Missouri | 29161 | 5580 | 165 |
1649603 | 1649603 | 2021-08-24 | Chatham | North Carolina | 37037 | 5580 | 89 |
1625434 | 1625434 | 2021-08-17 | Murray | Georgia | 13213 | 5580 | 94 |
1497128 | 1497128 | 2021-07-08 | Huron | Ohio | 39077 | 5580 | 122 |
1413515 | 1413515 | 2021-06-12 | Box Elder | Utah | 49003 | 5580 | 53 |
1384448 | 1384448 | 2021-06-03 | Pittsylvania | Virginia | 51143 | 5580 | 82 |
1346983 | 1346983 | 2021-05-23 | Chippewa | Michigan | 26033 | 5580 | 49 |
1343735 | 1343735 | 2021-05-22 | Chippewa | Michigan | 26033 | 5580 | 49 |
1330135 | 1330135 | 2021-05-18 | Knox | Illinois | 17095 | 5580 | 181 |
1271526 | 1271526 | 2021-04-30 | Laurens | Georgia | 13175 | 5580 | 167 |
1266826 | 1266826 | 2021-04-28 | Bradford | Pennsylvania | 42015 | 5580 | 86 |
1240739 | 1240739 | 2021-04-20 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1237492 | 1237492 | 2021-04-19 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1234225 | 1234225 | 2021-04-18 | Union | Ohio | 39159 | 5580 | 47 |
1234245 | 1234245 | 2021-04-18 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1230997 | 1230997 | 2021-04-17 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1227749 | 1227749 | 2021-04-16 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1224501 | 1224501 | 2021-04-15 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1221254 | 1221254 | 2021-04-14 | Cherokee | Oklahoma | 40021 | 5580 | 74 |
1212866 | 1212866 | 2021-04-12 | Garfield | Colorado | 8045 | 5580 | 38 |
1215532 | 1215532 | 2021-04-12 | Augusta | Virginia | 51015 | 5580 | 69 |
1136613 | 1136613 | 2021-03-19 | Lee | North Carolina | 37105 | 5580 | 73 |
1095028 | 1095028 | 2021-03-06 | Lawrence | Tennessee | 47099 | 5580 | 83 |
1062567 | 1062567 | 2021-02-24 | Jefferson | Tennessee | 47089 | 5580 | 116 |
1056267 | 1056267 | 2021-02-22 | Lamar | Texas | 48277 | 5580 | 140 |
1027904 | 1027904 | 2021-02-14 | Monroe | Florida | 12087 | 5580 | 42 |
1027227 | 1027227 | 2021-02-13 | Bedford | Virginia | 51019 | 5580 | 42 |
1017931 | 1017931 | 2021-02-11 | Crittenden | Arkansas | 5035 | 5580 | 90 |
960742 | 960742 | 2021-01-24 | Kandiyohi | Minnesota | 27067 | 5580 | 72 |
962540 | 962540 | 2021-01-24 | Calumet | Wisconsin | 55015 | 5580 | 41 |
939723 | 939723 | 2021-01-17 | Chelan | Washington | 53007 | 5580 | 43 |
936478 | 936478 | 2021-01-16 | Chelan | Washington | 53007 | 5580 | 43 |
933233 | 933233 | 2021-01-15 | Chelan | Washington | 53007 | 5580 | 43 |
499335 | 499335 | 2020-09-04 | Muscogee | Georgia | 13215 | 5580 | 146 |
450118 | 450118 | 2020-08-19 | Loudoun | Virginia | 51107 | 5580 | 115 |
413603 | 413603 | 2020-08-08 | Guilford | North Carolina | 37081 | 5580 | 156 |
267266 | 267266 | 2020-06-23 | Bucks | Pennsylvania | 42017 | 5580 | 555 |
259172 | 259172 | 2020-06-21 | Hillsborough | Florida | 12057 | 5580 | 114 |
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);