ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
218 rows where cases = 2815 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 37
- Texas 13
- Georgia 11
- Missouri 10
- Tennessee 10
- Arkansas 8
- Kentucky 8
- North Carolina 8
- Oklahoma 8
- Florida 7
- Louisiana 7
- Mississippi 7
- Minnesota 6
- Puerto Rico 6
- West Virginia 6
- Colorado 5
- Ohio 5
- Alabama 4
- Illinois 4
- Indiana 4
- Nevada 4
- Wisconsin 4
- Iowa 3
- Oregon 3
- Pennsylvania 3
- Virginia 3
- Alaska 2
- California 2
- Idaho 2
- New Jersey 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428879 | 2428879 | 2022-04-21 | Linn | Kansas | 20107 | 2815 | 28 |
2425623 | 2425623 | 2022-04-20 | Linn | Kansas | 20107 | 2815 | 28 |
2422367 | 2422367 | 2022-04-19 | Linn | Kansas | 20107 | 2815 | 28 |
2419111 | 2419111 | 2022-04-18 | Linn | Kansas | 20107 | 2815 | 28 |
2415855 | 2415855 | 2022-04-17 | Linn | Kansas | 20107 | 2815 | 28 |
2412599 | 2412599 | 2022-04-16 | Linn | Kansas | 20107 | 2815 | 28 |
2409343 | 2409343 | 2022-04-15 | Linn | Kansas | 20107 | 2815 | 28 |
2406087 | 2406087 | 2022-04-14 | Linn | Kansas | 20107 | 2815 | 28 |
2406137 | 2406137 | 2022-04-14 | Wilson | Kansas | 20205 | 2815 | 43 |
2402831 | 2402831 | 2022-04-13 | Linn | Kansas | 20107 | 2815 | 28 |
2402881 | 2402881 | 2022-04-13 | Wilson | Kansas | 20205 | 2815 | 43 |
2399577 | 2399577 | 2022-04-12 | Linn | Kansas | 20107 | 2815 | 28 |
2399627 | 2399627 | 2022-04-12 | Wilson | Kansas | 20205 | 2815 | 43 |
2396321 | 2396321 | 2022-04-11 | Linn | Kansas | 20107 | 2815 | 28 |
2396371 | 2396371 | 2022-04-11 | Wilson | Kansas | 20205 | 2815 | 43 |
2392407 | 2392407 | 2022-04-10 | Park | Colorado | 8093 | 2815 | 20 |
2393066 | 2393066 | 2022-04-10 | Linn | Kansas | 20107 | 2815 | 28 |
2393116 | 2393116 | 2022-04-10 | Wilson | Kansas | 20205 | 2815 | 43 |
2389151 | 2389151 | 2022-04-09 | Park | Colorado | 8093 | 2815 | 20 |
2389810 | 2389810 | 2022-04-09 | Linn | Kansas | 20107 | 2815 | 28 |
2389860 | 2389860 | 2022-04-09 | Wilson | Kansas | 20205 | 2815 | 43 |
2385896 | 2385896 | 2022-04-08 | Park | Colorado | 8093 | 2815 | 20 |
2386554 | 2386554 | 2022-04-08 | Linn | Kansas | 20107 | 2815 | 28 |
2386604 | 2386604 | 2022-04-08 | Wilson | Kansas | 20205 | 2815 | 43 |
2383349 | 2383349 | 2022-04-07 | Wilson | Kansas | 20205 | 2815 | 43 |
2380094 | 2380094 | 2022-04-06 | Wilson | Kansas | 20205 | 2815 | 43 |
2376839 | 2376839 | 2022-04-05 | Wilson | Kansas | 20205 | 2815 | 43 |
2373587 | 2373587 | 2022-04-04 | Wilson | Kansas | 20205 | 2815 | 43 |
2370334 | 2370334 | 2022-04-03 | Wilson | Kansas | 20205 | 2815 | 43 |
2367081 | 2367081 | 2022-04-02 | Wilson | Kansas | 20205 | 2815 | 43 |
2363828 | 2363828 | 2022-04-01 | Wilson | Kansas | 20205 | 2815 | 43 |
2342923 | 2342923 | 2022-03-25 | Ward | Texas | 48475 | 2815 | 43 |
2337754 | 2337754 | 2022-03-24 | Linn | Kansas | 20107 | 2815 | 27 |
2334500 | 2334500 | 2022-03-23 | Linn | Kansas | 20107 | 2815 | 27 |
2308474 | 2308474 | 2022-03-15 | Linn | Kansas | 20107 | 2815 | 27 |
2305223 | 2305223 | 2022-03-14 | Linn | Kansas | 20107 | 2815 | 27 |
2291356 | 2291356 | 2022-03-10 | Valdez-Cordova Census Area | Alaska | 2261 | 2815 | 16 |
2288104 | 2288104 | 2022-03-09 | Valdez-Cordova Census Area | Alaska | 2261 | 2815 | 16 |
2267635 | 2267635 | 2022-03-02 | Orocovis | Puerto Rico | 72107 | 2815 | |
2213296 | 2213296 | 2022-02-14 | Wilcox | Alabama | 1131 | 2815 | 40 |
2214341 | 2214341 | 2022-02-14 | Todd | Kentucky | 21219 | 2815 | 41 |
2210043 | 2210043 | 2022-02-13 | Wilcox | Alabama | 1131 | 2815 | 40 |
2193859 | 2193859 | 2022-02-08 | Lee | Arkansas | 5077 | 2815 | 55 |
2178911 | 2178911 | 2022-02-03 | Montgomery | Mississippi | 28097 | 2815 | 65 |
2174777 | 2174777 | 2022-02-02 | Idaho | Idaho | 16049 | 2815 | 44 |
2170100 | 2170100 | 2022-01-31 | Villalba | Puerto Rico | 72149 | 2815 | |
2149232 | 2149232 | 2022-01-25 | Leslie | Kentucky | 21131 | 2815 | 39 |
2144539 | 2144539 | 2022-01-23 | Zapata | Texas | 48505 | 2815 | 47 |
2131700 | 2131700 | 2022-01-19 | Westmoreland | Virginia | 51193 | 2815 | 39 |
2127512 | 2127512 | 2022-01-18 | Noble | Ohio | 39121 | 2815 | 51 |
2109483 | 2109483 | 2022-01-13 | Jefferson | Florida | 12065 | 2815 | 36 |
2106232 | 2106232 | 2022-01-12 | Jefferson | Florida | 12065 | 2815 | 36 |
2106953 | 2106953 | 2022-01-12 | Magoffin | Kentucky | 21153 | 2815 | 36 |
2102981 | 2102981 | 2022-01-11 | Jefferson | Florida | 12065 | 2815 | 36 |
2103714 | 2103714 | 2022-01-11 | Monroe | Kentucky | 21171 | 2815 | 69 |
2099730 | 2099730 | 2022-01-10 | Jefferson | Florida | 12065 | 2815 | 36 |
2096479 | 2096479 | 2022-01-09 | Jefferson | Florida | 12065 | 2815 | 36 |
2099312 | 2099312 | 2022-01-09 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2093227 | 2093227 | 2022-01-08 | Jefferson | Florida | 12065 | 2815 | 36 |
2096061 | 2096061 | 2022-01-08 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2089975 | 2089975 | 2022-01-07 | Jefferson | Florida | 12065 | 2815 | 36 |
2092809 | 2092809 | 2022-01-07 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2084320 | 2084320 | 2022-01-05 | Washington | Maine | 23029 | 2815 | 41 |
2084516 | 2084516 | 2022-01-05 | Sibley | Minnesota | 27143 | 2815 | 20 |
2064081 | 2064081 | 2021-12-30 | Jefferson | Georgia | 13163 | 2815 | 94 |
2063135 | 2063135 | 2021-12-29 | Llano | Texas | 48299 | 2815 | 84 |
2055011 | 2055011 | 2021-12-27 | LaSalle | Louisiana | 22059 | 2815 | 46 |
2049741 | 2049741 | 2021-12-25 | Manati | Puerto Rico | 72091 | 2815 | |
2031256 | 2031256 | 2021-12-20 | Izard | Arkansas | 5065 | 2815 | 56 |
1993458 | 1993458 | 2021-12-08 | Houston | Minnesota | 27055 | 2815 | 17 |
1983922 | 1983922 | 2021-12-05 | Morgan | Missouri | 29141 | 2815 | 73 |
1970499 | 1970499 | 2021-12-01 | Jackson | Louisiana | 22049 | 2815 | 64 |
1967203 | 1967203 | 2021-11-30 | Powell | Kentucky | 21197 | 2815 | 24 |
1967249 | 1967249 | 2021-11-30 | Jackson | Louisiana | 22049 | 2815 | 64 |
1968257 | 1968257 | 2021-11-30 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1963997 | 1963997 | 2021-11-29 | Jackson | Louisiana | 22049 | 2815 | 64 |
1964432 | 1964432 | 2021-11-29 | Pike | Missouri | 29163 | 2815 | 50 |
1965006 | 1965006 | 2021-11-29 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1961754 | 1961754 | 2021-11-28 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1958503 | 1958503 | 2021-11-27 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1955252 | 1955252 | 2021-11-26 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1952001 | 1952001 | 2021-11-25 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1948750 | 1948750 | 2021-11-24 | Atoka | Oklahoma | 40005 | 2815 | 35 |
1943969 | 1943969 | 2021-11-23 | Edgar | Illinois | 17045 | 2815 | 70 |
1896558 | 1896558 | 2021-11-08 | Madison | North Carolina | 37115 | 2815 | 60 |
1893118 | 1893118 | 2021-11-07 | Humboldt | Nevada | 32013 | 2815 | 36 |
1889868 | 1889868 | 2021-11-06 | Humboldt | Nevada | 32013 | 2815 | 36 |
1886618 | 1886618 | 2021-11-05 | Humboldt | Nevada | 32013 | 2815 | 36 |
1882992 | 1882992 | 2021-11-04 | Roseau | Minnesota | 27135 | 2815 | 29 |
1877630 | 1877630 | 2021-11-02 | Benton | Tennessee | 47005 | 2815 | 53 |
1834810 | 1834810 | 2021-10-20 | Hertford | North Carolina | 37091 | 2815 | 70 |
1835157 | 1835157 | 2021-10-20 | Juniata | Pennsylvania | 42067 | 2815 | 115 |
1835687 | 1835687 | 2021-10-20 | San Jacinto | Texas | 48407 | 2815 | 75 |
1830527 | 1830527 | 2021-10-19 | Dickinson | Kansas | 20041 | 2815 | 60 |
1826538 | 1826538 | 2021-10-18 | Sharp | Arkansas | 5135 | 2815 | 66 |
1827278 | 1827278 | 2021-10-18 | Dickinson | Kansas | 20041 | 2815 | 60 |
1825373 | 1825373 | 2021-10-17 | Wasco | Oregon | 41065 | 2815 | 40 |
1822124 | 1822124 | 2021-10-16 | Wasco | Oregon | 41065 | 2815 | 40 |
1818875 | 1818875 | 2021-10-15 | Wasco | Oregon | 41065 | 2815 | 40 |
1768639 | 1768639 | 2021-09-30 | Orange | Indiana | 18117 | 2815 | 62 |
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);