ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 5915 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Kentucky 10
- Oklahoma 8
- Georgia 6
- Arkansas 5
- Indiana 5
- Oregon 5
- North Carolina 4
- Texas 4
- Missouri 3
- New York 3
- Pennsylvania 3
- Alabama 2
- Ohio 2
- South Carolina 2
- Tennessee 2
- California 1
- Colorado 1
- Florida 1
- Maine 1
- Maryland 1
- North Dakota 1
- Puerto Rico 1
- Utah 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490244 | 2490244 | 2022-05-10 | Emanuel | Georgia | 13107 | 5915 | 159 |
2486987 | 2486987 | 2022-05-09 | Emanuel | Georgia | 13107 | 5915 | 159 |
2461492 | 2461492 | 2022-05-01 | Adair | Kentucky | 21001 | 5915 | 105 |
2458236 | 2458236 | 2022-04-30 | Adair | Kentucky | 21001 | 5915 | 105 |
2454980 | 2454980 | 2022-04-29 | Adair | Kentucky | 21001 | 5915 | 105 |
2451724 | 2451724 | 2022-04-28 | Adair | Kentucky | 21001 | 5915 | 105 |
2448468 | 2448468 | 2022-04-27 | Adair | Kentucky | 21001 | 5915 | 105 |
2445212 | 2445212 | 2022-04-26 | Adair | Kentucky | 21001 | 5915 | 105 |
2441956 | 2441956 | 2022-04-25 | Adair | Kentucky | 21001 | 5915 | 105 |
2394504 | 2394504 | 2022-04-10 | Moca | Puerto Rico | 72099 | 5915 | |
2218700 | 2218700 | 2022-02-15 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2213348 | 2213348 | 2022-02-14 | Carroll | Arkansas | 5015 | 5915 | 87 |
2215449 | 2215449 | 2022-02-14 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2212198 | 2212198 | 2022-02-13 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2208945 | 2208945 | 2022-02-12 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2205692 | 2205692 | 2022-02-11 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2202439 | 2202439 | 2022-02-10 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2199185 | 2199185 | 2022-02-09 | Seminole | Oklahoma | 40133 | 5915 | 114 |
2152186 | 2152186 | 2022-01-26 | Posey | Indiana | 18129 | 5915 | 48 |
2132346 | 2132346 | 2022-01-20 | Gilmer | Georgia | 13123 | 5915 | 150 |
2125400 | 2125400 | 2022-01-18 | Clarke | Alabama | 1025 | 5915 | 89 |
2098452 | 2098452 | 2022-01-09 | Warren | Pennsylvania | 42123 | 5915 | 184 |
2065524 | 2065524 | 2021-12-30 | Bladen | North Carolina | 37017 | 5915 | 98 |
2027476 | 2027476 | 2021-12-18 | Washington | Texas | 48477 | 5915 | 135 |
2018102 | 2018102 | 2021-12-15 | Sheridan | Wyoming | 56033 | 5915 | 60 |
1984209 | 1984209 | 2021-12-05 | Columbia | New York | 36021 | 5915 | 115 |
1975170 | 1975170 | 2021-12-02 | Henderson | Tennessee | 47077 | 5915 | 106 |
1967193 | 1967193 | 2021-11-30 | Muhlenberg | Kentucky | 21177 | 5915 | 97 |
1961852 | 1961852 | 2021-11-28 | Malheur | Oregon | 41045 | 5915 | 86 |
1958601 | 1958601 | 2021-11-27 | Malheur | Oregon | 41045 | 5915 | 86 |
1955350 | 1955350 | 2021-11-26 | Malheur | Oregon | 41045 | 5915 | 86 |
1952099 | 1952099 | 2021-11-25 | Malheur | Oregon | 41045 | 5915 | 86 |
1948848 | 1948848 | 2021-11-24 | Malheur | Oregon | 41045 | 5915 | 86 |
1940275 | 1940275 | 2021-11-22 | Union | Arkansas | 5139 | 5915 | 142 |
1938052 | 1938052 | 2021-11-21 | Calvert | Maryland | 24009 | 5915 | 101 |
1925038 | 1925038 | 2021-11-17 | Oxford | Maine | 23017 | 5915 | 87 |
1901892 | 1901892 | 2021-11-10 | Whitley | Indiana | 18183 | 5915 | 60 |
1832515 | 1832515 | 2021-10-19 | Wasatch | Utah | 49051 | 5915 | 28 |
1825199 | 1825199 | 2021-10-17 | Fulton | Ohio | 39051 | 5915 | 96 |
1807966 | 1807966 | 2021-10-12 | Perry | Kentucky | 21193 | 5915 | 87 |
1788119 | 1788119 | 2021-10-06 | Knox | Indiana | 18083 | 5915 | 105 |
1759985 | 1759985 | 2021-09-27 | Clinton | New York | 36019 | 5915 | 34 |
1744314 | 1744314 | 2021-09-22 | Chester | South Carolina | 45023 | 5915 | 96 |
1721136 | 1721136 | 2021-09-15 | Vance | North Carolina | 37181 | 5915 | 92 |
1708186 | 1708186 | 2021-09-11 | Morton | North Dakota | 38059 | 5915 | 102 |
1664399 | 1664399 | 2021-08-29 | Liberty | Georgia | 13179 | 5915 | 75 |
1661151 | 1661151 | 2021-08-28 | Liberty | Georgia | 13179 | 5915 | 75 |
1657903 | 1657903 | 2021-08-27 | Liberty | Georgia | 13179 | 5915 | 75 |
1536274 | 1536274 | 2021-07-20 | Columbia | Pennsylvania | 42037 | 5915 | 136 |
1469777 | 1469777 | 2021-06-30 | Dearborn | Indiana | 18029 | 5915 | 81 |
1432909 | 1432909 | 2021-06-18 | Navarro | Texas | 48349 | 5915 | 154 |
1427024 | 1427024 | 2021-06-17 | Mississippi | Arkansas | 5093 | 5915 | 110 |
1423779 | 1423779 | 2021-06-16 | Mississippi | Arkansas | 5093 | 5915 | 110 |
1251834 | 1251834 | 2021-04-24 | Fremont | Colorado | 8043 | 5915 | 54 |
1243677 | 1243677 | 2021-04-21 | Cayuga | New York | 36011 | 5915 | 90 |
1228015 | 1228015 | 2021-04-16 | Cherokee | South Carolina | 45021 | 5915 | 149 |
1219067 | 1219067 | 2021-04-13 | Waupaca | Wisconsin | 55135 | 5915 | 161 |
1206229 | 1206229 | 2021-04-10 | Crittenden | Arkansas | 5035 | 5915 | 96 |
1147887 | 1147887 | 2021-03-23 | Yuba | California | 6115 | 5915 | 42 |
1049311 | 1049311 | 2021-02-20 | Lawrence | Pennsylvania | 42073 | 5915 | 180 |
1021806 | 1021806 | 2021-02-12 | Morgan | Indiana | 18109 | 5915 | 129 |
1017105 | 1017105 | 2021-02-10 | Dickson | Tennessee | 47043 | 5915 | 99 |
1004826 | 1004826 | 2021-02-07 | Blount | Alabama | 1009 | 5915 | 112 |
987986 | 987986 | 2021-02-01 | Bowie | Texas | 48037 | 5915 | 156 |
951559 | 951559 | 2021-01-21 | Brunswick | North Carolina | 37019 | 5915 | 86 |
946789 | 946789 | 2021-01-20 | Walton | Florida | 12131 | 5915 | 60 |
851240 | 851240 | 2020-12-21 | Muskogee | Oklahoma | 40101 | 5915 | 48 |
824595 | 824595 | 2020-12-13 | Clay | Missouri | 29047 | 5915 | 84 |
821349 | 821349 | 2020-12-12 | Clay | Missouri | 29047 | 5915 | 84 |
818103 | 818103 | 2020-12-11 | Clay | Missouri | 29047 | 5915 | 84 |
815451 | 815451 | 2020-12-10 | Miami | Ohio | 39109 | 5915 | 69 |
493406 | 493406 | 2020-09-02 | Fayette | Kentucky | 21067 | 5915 | 58 |
468435 | 468435 | 2020-08-25 | Forsyth | North Carolina | 37067 | 5915 | 69 |
366094 | 366094 | 2020-07-24 | Denton | Texas | 48121 | 5915 | 47 |
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);