ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5833 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 9
- Oklahoma 7
- Arkansas 6
- Georgia 5
- Nebraska 5
- South Carolina 5
- Tennessee 5
- Kentucky 4
- Oregon 4
- Wisconsin 4
- Indiana 3
- Kansas 3
- Missouri 3
- Virginia 3
- Wyoming 3
- Alaska 2
- Illinois 2
- Minnesota 2
- Ohio 2
- Alabama 1
- Colorado 1
- Florida 1
- Louisiana 1
- Nevada 1
- New Jersey 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394828 | 2394828 | 2022-04-10 | Frio | Texas | 48163 | 5833 | 93 |
2383113 | 2383113 | 2022-04-07 | Owen | Indiana | 18119 | 5833 | 120 |
2379858 | 2379858 | 2022-04-06 | Owen | Indiana | 18119 | 5833 | 120 |
2350580 | 2350580 | 2022-03-28 | Owen | Indiana | 18119 | 5833 | 118 |
2336886 | 2336886 | 2022-03-24 | Nome Census Area | Alaska | 2180 | 5833 | 5 |
2333632 | 2333632 | 2022-03-23 | Nome Census Area | Alaska | 2180 | 5833 | 5 |
2256552 | 2256552 | 2022-02-27 | Johnson | Kentucky | 21115 | 5833 | 92 |
2253301 | 2253301 | 2022-02-26 | Johnson | Kentucky | 21115 | 5833 | 92 |
2250050 | 2250050 | 2022-02-25 | Johnson | Kentucky | 21115 | 5833 | 92 |
2238432 | 2238432 | 2022-02-21 | Jasper | South Carolina | 45053 | 5833 | 91 |
2235181 | 2235181 | 2022-02-20 | Jasper | South Carolina | 45053 | 5833 | 91 |
2231930 | 2231930 | 2022-02-19 | Jasper | South Carolina | 45053 | 5833 | 91 |
2228679 | 2228679 | 2022-02-18 | Jasper | South Carolina | 45053 | 5833 | 91 |
2225428 | 2225428 | 2022-02-17 | Jasper | South Carolina | 45053 | 5833 | 91 |
2226201 | 2226201 | 2022-02-17 | Vernon | Wisconsin | 55123 | 5833 | 88 |
2200363 | 2200363 | 2022-02-10 | Jackson | Arkansas | 5067 | 5833 | 53 |
2179050 | 2179050 | 2022-02-03 | Stoddard | Missouri | 29207 | 5833 | 114 |
2166686 | 2166686 | 2022-01-30 | Lincoln | Oregon | 41041 | 5833 | 64 |
2163431 | 2163431 | 2022-01-29 | Lincoln | Oregon | 41041 | 5833 | 64 |
2160176 | 2160176 | 2022-01-28 | Lincoln | Oregon | 41041 | 5833 | 64 |
2108552 | 2108552 | 2022-01-12 | Cooke | Texas | 48097 | 5833 | 114 |
2102014 | 2102014 | 2022-01-10 | Bee | Texas | 48025 | 5833 | 137 |
2019661 | 2019661 | 2021-12-16 | Laclede | Missouri | 29105 | 5833 | 151 |
2012944 | 2012944 | 2021-12-14 | Carlton | Minnesota | 27017 | 5833 | 79 |
2008365 | 2008365 | 2021-12-13 | Chambers | Alabama | 1017 | 5833 | 143 |
1988003 | 1988003 | 2021-12-06 | Toa Alta | Puerto Rico | 72135 | 5833 | |
1981204 | 1981204 | 2021-12-04 | Jackson | Ohio | 39079 | 5833 | 97 |
1961326 | 1961326 | 2021-11-28 | Lincoln | Nebraska | 31111 | 5833 | 80 |
1958075 | 1958075 | 2021-11-27 | Lincoln | Nebraska | 31111 | 5833 | 80 |
1954824 | 1954824 | 2021-11-26 | Lincoln | Nebraska | 31111 | 5833 | 80 |
1955413 | 1955413 | 2021-11-26 | Perry | Pennsylvania | 42099 | 5833 | 132 |
1951573 | 1951573 | 2021-11-25 | Lincoln | Nebraska | 31111 | 5833 | 80 |
1948322 | 1948322 | 2021-11-24 | Lincoln | Nebraska | 31111 | 5833 | 80 |
1945544 | 1945544 | 2021-11-23 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1942293 | 1942293 | 2021-11-22 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1939043 | 1939043 | 2021-11-21 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1935793 | 1935793 | 2021-11-20 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1932543 | 1932543 | 2021-11-19 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1929292 | 1929292 | 2021-11-18 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1926042 | 1926042 | 2021-11-17 | McCurtain | Oklahoma | 40089 | 5833 | 129 |
1920078 | 1920078 | 2021-11-15 | Hill | Texas | 48217 | 5833 | 167 |
1916679 | 1916679 | 2021-11-14 | Marion | Tennessee | 47115 | 5833 | 55 |
1916828 | 1916828 | 2021-11-14 | Hill | Texas | 48217 | 5833 | 167 |
1913429 | 1913429 | 2021-11-13 | Marion | Tennessee | 47115 | 5833 | 55 |
1910179 | 1910179 | 2021-11-12 | Marion | Tennessee | 47115 | 5833 | 55 |
1904888 | 1904888 | 2021-11-11 | Wayne | Georgia | 13305 | 5833 | 172 |
1901638 | 1901638 | 2021-11-10 | Wayne | Georgia | 13305 | 5833 | 172 |
1894776 | 1894776 | 2021-11-08 | Union | Arkansas | 5139 | 5833 | 141 |
1891526 | 1891526 | 2021-11-07 | Union | Arkansas | 5139 | 5833 | 141 |
1855718 | 1855718 | 2021-10-27 | Baxter | Arkansas | 5005 | 5833 | 177 |
1771071 | 1771071 | 2021-09-30 | Monroe | Wisconsin | 55081 | 5833 | 54 |
1716007 | 1716007 | 2021-09-14 | Boone | Arkansas | 5009 | 5833 | 105 |
1678091 | 1678091 | 2021-09-02 | Webster | Louisiana | 22119 | 5833 | 130 |
1675430 | 1675430 | 2021-09-01 | Elko | Nevada | 32007 | 5833 | 70 |
1667825 | 1667825 | 2021-08-30 | Marion | Illinois | 17121 | 5833 | 137 |
1657045 | 1657045 | 2021-08-26 | Wilson | Texas | 48493 | 5833 | 79 |
1644415 | 1644415 | 2021-08-22 | Fremont | Wyoming | 56013 | 5833 | 88 |
1641165 | 1641165 | 2021-08-21 | Fremont | Wyoming | 56013 | 5833 | 88 |
1637915 | 1637915 | 2021-08-20 | Fremont | Wyoming | 56013 | 5833 | 88 |
1501202 | 1501202 | 2021-07-09 | Albemarle | Virginia | 51003 | 5833 | 85 |
1406286 | 1406286 | 2021-06-10 | Union | Ohio | 39159 | 5833 | 49 |
1379565 | 1379565 | 2021-06-02 | Otter Tail | Minnesota | 27111 | 5833 | 81 |
1338778 | 1338778 | 2021-05-20 | Navarro | Texas | 48349 | 5833 | 154 |
1335531 | 1335531 | 2021-05-19 | Navarro | Texas | 48349 | 5833 | 154 |
1332284 | 1332284 | 2021-05-18 | Navarro | Texas | 48349 | 5833 | 154 |
1313522 | 1313522 | 2021-05-13 | Garfield | Colorado | 8045 | 5833 | 38 |
1277700 | 1277700 | 2021-05-02 | Mississippi | Arkansas | 5093 | 5833 | 107 |
1173597 | 1173597 | 2021-03-30 | Waupaca | Wisconsin | 55135 | 5833 | 161 |
1128575 | 1128575 | 2021-03-17 | Catoosa | Georgia | 13047 | 5833 | 66 |
1100047 | 1100047 | 2021-03-08 | Pulaski | Kentucky | 21199 | 5833 | 88 |
1092141 | 1092141 | 2021-03-05 | Bedford | Virginia | 51019 | 5833 | 75 |
1030075 | 1030075 | 2021-02-14 | Carter | Tennessee | 47019 | 5833 | 147 |
1007980 | 1007980 | 2021-02-07 | Calumet | Wisconsin | 55015 | 5833 | 41 |
992349 | 992349 | 2021-02-03 | Rockdale | Georgia | 13247 | 5833 | 115 |
975259 | 975259 | 2021-01-28 | Tooele | Utah | 49045 | 5833 | 21 |
960304 | 960304 | 2021-01-24 | Finney | Kansas | 20055 | 5833 | 45 |
957058 | 957058 | 2021-01-23 | Finney | Kansas | 20055 | 5833 | 45 |
953813 | 953813 | 2021-01-22 | Finney | Kansas | 20055 | 5833 | 45 |
939668 | 939668 | 2021-01-17 | Montgomery | Virginia | 51121 | 5833 | 49 |
933767 | 933767 | 2021-01-16 | Highlands | Florida | 12055 | 5833 | 231 |
866812 | 866812 | 2020-12-26 | Jasper | Missouri | 29097 | 5833 | 83 |
797541 | 797541 | 2020-12-05 | Coweta | Georgia | 13077 | 5833 | 76 |
762063 | 762063 | 2020-11-24 | Kendall | Illinois | 17093 | 5833 | 42 |
611558 | 611558 | 2020-10-08 | Williamson | Tennessee | 47187 | 5833 | 42 |
475215 | 475215 | 2020-08-27 | Multnomah | Oregon | 41051 | 5833 | 115 |
128903 | 128903 | 2020-05-09 | Morris | New Jersey | 34027 | 5833 | 511 |
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);