ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
341 rows where cases = 1480 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Idaho 24
- Kentucky 21
- Georgia 20
- North Carolina 20
- Alabama 18
- Texas 17
- Illinois 16
- Wisconsin 16
- Louisiana 15
- Minnesota 14
- Kansas 13
- Iowa 12
- Missouri 11
- Arkansas 10
- North Dakota 10
- Virginia 10
- Mississippi 8
- Puerto Rico 8
- Tennessee 7
- New York 6
- Alaska 5
- Florida 5
- Michigan 5
- Nevada 5
- New Mexico 5
- Montana 4
- Nebraska 4
- West Virginia 4
- Colorado 3
- Ohio 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496247 | 2496247 | 2022-05-11 | Iron | Wisconsin | 55051 | 1480 | 47 |
2489731 | 2489731 | 2022-05-09 | Iron | Wisconsin | 55051 | 1480 | 47 |
2486474 | 2486474 | 2022-05-08 | Iron | Wisconsin | 55051 | 1480 | 47 |
2483216 | 2483216 | 2022-05-07 | Iron | Wisconsin | 55051 | 1480 | 47 |
2479958 | 2479958 | 2022-05-06 | Iron | Wisconsin | 55051 | 1480 | 47 |
2452549 | 2452549 | 2022-04-28 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2449293 | 2449293 | 2022-04-27 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2446036 | 2446036 | 2022-04-26 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2442781 | 2442781 | 2022-04-25 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2356831 | 2356831 | 2022-03-30 | Randolph | Georgia | 13243 | 1480 | 48 |
2311349 | 2311349 | 2022-03-16 | Caribou | Idaho | 16029 | 1480 | 26 |
2308096 | 2308096 | 2022-03-15 | Caribou | Idaho | 16029 | 1480 | 26 |
2304845 | 2304845 | 2022-03-14 | Caribou | Idaho | 16029 | 1480 | 26 |
2306289 | 2306289 | 2022-03-14 | Dickey | North Dakota | 38021 | 1480 | 39 |
2301593 | 2301593 | 2022-03-13 | Caribou | Idaho | 16029 | 1480 | 26 |
2303038 | 2303038 | 2022-03-13 | Dickey | North Dakota | 38021 | 1480 | 39 |
2298341 | 2298341 | 2022-03-12 | Caribou | Idaho | 16029 | 1480 | 26 |
2299786 | 2299786 | 2022-03-12 | Dickey | North Dakota | 38021 | 1480 | 39 |
2295089 | 2295089 | 2022-03-11 | Caribou | Idaho | 16029 | 1480 | 26 |
2291837 | 2291837 | 2022-03-10 | Caribou | Idaho | 16029 | 1480 | 26 |
2293282 | 2293282 | 2022-03-10 | Dickey | North Dakota | 38021 | 1480 | 39 |
2288585 | 2288585 | 2022-03-09 | Caribou | Idaho | 16029 | 1480 | 26 |
2285334 | 2285334 | 2022-03-08 | Caribou | Idaho | 16029 | 1480 | 26 |
2282082 | 2282082 | 2022-03-07 | Caribou | Idaho | 16029 | 1480 | 26 |
2278829 | 2278829 | 2022-03-06 | Caribou | Idaho | 16029 | 1480 | 26 |
2275576 | 2275576 | 2022-03-05 | Caribou | Idaho | 16029 | 1480 | 26 |
2272323 | 2272323 | 2022-03-04 | Caribou | Idaho | 16029 | 1480 | 26 |
2273768 | 2273768 | 2022-03-04 | Dickey | North Dakota | 38021 | 1480 | 39 |
2269071 | 2269071 | 2022-03-03 | Caribou | Idaho | 16029 | 1480 | 26 |
2270515 | 2270515 | 2022-03-03 | Dickey | North Dakota | 38021 | 1480 | 39 |
2271158 | 2271158 | 2022-03-03 | Carson | Texas | 48065 | 1480 | 34 |
2265818 | 2265818 | 2022-03-02 | Caribou | Idaho | 16029 | 1480 | 26 |
2266980 | 2266980 | 2022-03-02 | Nemaha | Nebraska | 31127 | 1480 | 19 |
2267263 | 2267263 | 2022-03-02 | Dickey | North Dakota | 38021 | 1480 | 39 |
2267906 | 2267906 | 2022-03-02 | Carson | Texas | 48065 | 1480 | 34 |
2262567 | 2262567 | 2022-03-01 | Caribou | Idaho | 16029 | 1480 | 26 |
2263729 | 2263729 | 2022-03-01 | Nemaha | Nebraska | 31127 | 1480 | 19 |
2264011 | 2264011 | 2022-03-01 | Dickey | North Dakota | 38021 | 1480 | 39 |
2264653 | 2264653 | 2022-03-01 | Carson | Texas | 48065 | 1480 | 34 |
2259316 | 2259316 | 2022-02-28 | Caribou | Idaho | 16029 | 1480 | 26 |
2260478 | 2260478 | 2022-02-28 | Nemaha | Nebraska | 31127 | 1480 | 19 |
2256089 | 2256089 | 2022-02-27 | Power | Idaho | 16077 | 1480 | 20 |
2252838 | 2252838 | 2022-02-26 | Power | Idaho | 16077 | 1480 | 20 |
2249587 | 2249587 | 2022-02-25 | Power | Idaho | 16077 | 1480 | 20 |
2246312 | 2246312 | 2022-02-24 | Caribou | Idaho | 16029 | 1480 | 26 |
2244531 | 2244531 | 2022-02-23 | Ransom | North Dakota | 38073 | 1480 | 28 |
2213716 | 2213716 | 2022-02-14 | Marion | Georgia | 13197 | 1480 | 44 |
2210464 | 2210464 | 2022-02-13 | Marion | Georgia | 13197 | 1480 | 44 |
2207211 | 2207211 | 2022-02-12 | Marion | Georgia | 13197 | 1480 | 44 |
2203958 | 2203958 | 2022-02-11 | Marion | Georgia | 13197 | 1480 | 44 |
2177981 | 2177981 | 2022-02-03 | Twiggs | Georgia | 13289 | 1480 | 64 |
2154359 | 2154359 | 2022-01-26 | Bland | Virginia | 51021 | 1480 | 19 |
2108878 | 2108878 | 2022-01-12 | Lunenburg | Virginia | 51111 | 1480 | 24 |
2078395 | 2078395 | 2022-01-03 | White Pine | Nevada | 32033 | 1480 | 18 |
2074335 | 2074335 | 2022-01-02 | Pratt | Kansas | 20151 | 1480 | 29 |
2075144 | 2075144 | 2022-01-02 | White Pine | Nevada | 32033 | 1480 | 18 |
2071084 | 2071084 | 2022-01-01 | Pratt | Kansas | 20151 | 1480 | 29 |
2071893 | 2071893 | 2022-01-01 | White Pine | Nevada | 32033 | 1480 | 18 |
2067833 | 2067833 | 2021-12-31 | Pratt | Kansas | 20151 | 1480 | 29 |
2068642 | 2068642 | 2021-12-31 | White Pine | Nevada | 32033 | 1480 | 18 |
2064582 | 2064582 | 2021-12-30 | Pratt | Kansas | 20151 | 1480 | 29 |
2065391 | 2065391 | 2021-12-30 | White Pine | Nevada | 32033 | 1480 | 18 |
2061332 | 2061332 | 2021-12-29 | Pratt | Kansas | 20151 | 1480 | 29 |
2058953 | 2058953 | 2021-12-28 | Sierra | New Mexico | 35051 | 1480 | 63 |
2059515 | 2059515 | 2021-12-28 | Utuado | Puerto Rico | 72141 | 1480 | |
2059770 | 2059770 | 2021-12-28 | Castro | Texas | 48069 | 1480 | 41 |
2040558 | 2040558 | 2021-12-22 | Buena Vista city | Virginia | 51530 | 1480 | 32 |
2034486 | 2034486 | 2021-12-21 | Cleveland | Arkansas | 5025 | 1480 | 33 |
2035476 | 2035476 | 2021-12-21 | Trimble | Kentucky | 21223 | 1480 | 28 |
2017678 | 2017678 | 2021-12-15 | Red River | Texas | 48387 | 1480 | 56 |
2014202 | 2014202 | 2021-12-14 | Moore | Tennessee | 47127 | 1480 | 25 |
1982212 | 1982212 | 2021-12-04 | Gilmer | West Virginia | 54021 | 1480 | 14 |
1937763 | 1937763 | 2021-11-21 | Doniphan | Kansas | 20043 | 1480 | 28 |
1934513 | 1934513 | 2021-11-20 | Doniphan | Kansas | 20043 | 1480 | 28 |
1931262 | 1931262 | 2021-11-19 | Doniphan | Kansas | 20043 | 1480 | 28 |
1925221 | 1925221 | 2021-11-17 | Murray | Minnesota | 27101 | 1480 | 11 |
1917238 | 1917238 | 2021-11-14 | Summers | West Virginia | 54089 | 1480 | 30 |
1879877 | 1879877 | 2021-11-03 | DeKalb | Missouri | 29063 | 1480 | 34 |
1876628 | 1876628 | 2021-11-02 | DeKalb | Missouri | 29063 | 1480 | 34 |
1851944 | 1851944 | 2021-10-25 | Somervell | Texas | 48425 | 1480 | 21 |
1848694 | 1848694 | 2021-10-24 | Somervell | Texas | 48425 | 1480 | 21 |
1845444 | 1845444 | 2021-10-23 | Somervell | Texas | 48425 | 1480 | 21 |
1791171 | 1791171 | 2021-10-07 | Wilkinson | Georgia | 13319 | 1480 | 40 |
1784673 | 1784673 | 2021-10-05 | Wilkinson | Georgia | 13319 | 1480 | 38 |
1786646 | 1786646 | 2021-10-05 | Todd | South Dakota | 46121 | 1480 | 35 |
1778203 | 1778203 | 2021-10-03 | Franklin | Idaho | 16041 | 1480 | 20 |
1774953 | 1774953 | 2021-10-02 | Franklin | Idaho | 16041 | 1480 | 20 |
1771703 | 1771703 | 2021-10-01 | Franklin | Idaho | 16041 | 1480 | 20 |
1767479 | 1767479 | 2021-09-29 | Trinity | Texas | 48455 | 1480 | 48 |
1758038 | 1758038 | 2021-09-26 | Bayfield | Wisconsin | 55007 | 1480 | 23 |
1754790 | 1754790 | 2021-09-25 | Bayfield | Wisconsin | 55007 | 1480 | 23 |
1751542 | 1751542 | 2021-09-24 | Bayfield | Wisconsin | 55007 | 1480 | 23 |
1739776 | 1739776 | 2021-09-21 | East Carroll | Louisiana | 22035 | 1480 | 30 |
1736527 | 1736527 | 2021-09-20 | East Carroll | Louisiana | 22035 | 1480 | 30 |
1688248 | 1688248 | 2021-09-05 | Ripley | Missouri | 29181 | 1480 | 19 |
1671741 | 1671741 | 2021-08-31 | Aitkin | Minnesota | 27001 | 1480 | 37 |
1672656 | 1672656 | 2021-08-31 | Hood River | Oregon | 41027 | 1480 | 35 |
1657319 | 1657319 | 2021-08-26 | Taylor | West Virginia | 54091 | 1480 | 26 |
1626467 | 1626467 | 2021-08-17 | Dent | Missouri | 29065 | 1480 | 23 |
1628097 | 1628097 | 2021-08-17 | Buffalo | Wisconsin | 55011 | 1480 | 7 |
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);