ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where cases = 3336 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Texas 14
- Illinois 12
- Louisiana 11
- New York 11
- Kentucky 10
- Virginia 10
- Florida 9
- Kansas 9
- Tennessee 9
- Minnesota 7
- Indiana 6
- North Carolina 5
- Wisconsin 5
- Alabama 4
- Colorado 4
- Georgia 4
- Mississippi 4
- Missouri 4
- Puerto Rico 4
- New Mexico 3
- West Virginia 3
- Wyoming 3
- Arkansas 2
- Idaho 2
- Ohio 2
- Pennsylvania 2
- South Carolina 2
- Vermont 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497271 | 2497271 | 2022-05-12 | Marion | Kansas | 20115 | 3336 | 43 |
2494013 | 2494013 | 2022-05-11 | Marion | Kansas | 20115 | 3336 | 43 |
2490755 | 2490755 | 2022-05-10 | Marion | Kansas | 20115 | 3336 | 43 |
2487498 | 2487498 | 2022-05-09 | Marion | Kansas | 20115 | 3336 | 43 |
2484240 | 2484240 | 2022-05-08 | Marion | Kansas | 20115 | 3336 | 43 |
2480982 | 2480982 | 2022-05-07 | Marion | Kansas | 20115 | 3336 | 43 |
2477724 | 2477724 | 2022-05-06 | Marion | Kansas | 20115 | 3336 | 43 |
2467869 | 2467869 | 2022-05-03 | Page | Iowa | 19145 | 3336 | 45 |
2464614 | 2464614 | 2022-05-02 | Page | Iowa | 19145 | 3336 | 45 |
2461358 | 2461358 | 2022-05-01 | Page | Iowa | 19145 | 3336 | 45 |
2458102 | 2458102 | 2022-04-30 | Page | Iowa | 19145 | 3336 | 45 |
2454846 | 2454846 | 2022-04-29 | Page | Iowa | 19145 | 3336 | 45 |
2451590 | 2451590 | 2022-04-28 | Page | Iowa | 19145 | 3336 | 45 |
2448334 | 2448334 | 2022-04-27 | Page | Iowa | 19145 | 3336 | 45 |
2445078 | 2445078 | 2022-04-26 | Page | Iowa | 19145 | 3336 | 45 |
2441822 | 2441822 | 2022-04-25 | Page | Iowa | 19145 | 3336 | 45 |
2438566 | 2438566 | 2022-04-24 | Page | Iowa | 19145 | 3336 | 45 |
2435310 | 2435310 | 2022-04-23 | Page | Iowa | 19145 | 3336 | 45 |
2432054 | 2432054 | 2022-04-22 | Page | Iowa | 19145 | 3336 | 45 |
2428186 | 2428186 | 2022-04-21 | Crowley | Colorado | 8025 | 3336 | 28 |
2428798 | 2428798 | 2022-04-21 | Page | Iowa | 19145 | 3336 | 45 |
2425542 | 2425542 | 2022-04-20 | Page | Iowa | 19145 | 3336 | 45 |
2394526 | 2394526 | 2022-04-10 | Utuado | Puerto Rico | 72141 | 3336 | |
2395164 | 2395164 | 2022-04-10 | Southampton | Virginia | 51175 | 3336 | 89 |
2391908 | 2391908 | 2022-04-09 | Southampton | Virginia | 51175 | 3336 | 89 |
2388652 | 2388652 | 2022-04-08 | Southampton | Virginia | 51175 | 3336 | 89 |
2332203 | 2332203 | 2022-03-22 | Yates | New York | 36123 | 3336 | 39 |
2328950 | 2328950 | 2022-03-21 | Yates | New York | 36123 | 3336 | 39 |
2325698 | 2325698 | 2022-03-20 | Yates | New York | 36123 | 3336 | 39 |
2322445 | 2322445 | 2022-03-19 | Yates | New York | 36123 | 3336 | 39 |
2319191 | 2319191 | 2022-03-18 | Yates | New York | 36123 | 3336 | 39 |
2315937 | 2315937 | 2022-03-17 | Yates | New York | 36123 | 3336 | 39 |
2306009 | 2306009 | 2022-03-14 | Otoe | Nebraska | 31131 | 3336 | 17 |
2306329 | 2306329 | 2022-03-14 | Walsh | North Dakota | 38099 | 3336 | 34 |
2288415 | 2288415 | 2022-03-09 | Bleckley | Georgia | 13023 | 3336 | 93 |
2288632 | 2288632 | 2022-03-09 | Cumberland | Illinois | 17035 | 3336 | 49 |
2285381 | 2285381 | 2022-03-08 | Cumberland | Illinois | 17035 | 3336 | 49 |
2282129 | 2282129 | 2022-03-07 | Cumberland | Illinois | 17035 | 3336 | 49 |
2278876 | 2278876 | 2022-03-06 | Cumberland | Illinois | 17035 | 3336 | 49 |
2275623 | 2275623 | 2022-03-05 | Cumberland | Illinois | 17035 | 3336 | 49 |
2272370 | 2272370 | 2022-03-04 | Cumberland | Illinois | 17035 | 3336 | 49 |
2269118 | 2269118 | 2022-03-03 | Cumberland | Illinois | 17035 | 3336 | 49 |
2265865 | 2265865 | 2022-03-02 | Cumberland | Illinois | 17035 | 3336 | 49 |
2221623 | 2221623 | 2022-02-16 | Schuyler | New York | 36097 | 3336 | 24 |
2201316 | 2201316 | 2022-02-10 | Pendleton | Kentucky | 21191 | 3336 | 33 |
2192881 | 2192881 | 2022-02-07 | Bamberg | South Carolina | 45009 | 3336 | 70 |
2115533 | 2115533 | 2022-01-14 | Wetzel | West Virginia | 54103 | 3336 | 68 |
2106947 | 2106947 | 2022-01-12 | Lewis | Kentucky | 21135 | 3336 | 71 |
2083709 | 2083709 | 2022-01-05 | Minidoka | Idaho | 16067 | 3336 | 53 |
2040212 | 2040212 | 2021-12-22 | Polk | Tennessee | 47139 | 3336 | 39 |
2024284 | 2024284 | 2021-12-17 | Windham | Vermont | 50025 | 3336 | 29 |
2018616 | 2018616 | 2021-12-16 | Putnam | Georgia | 13237 | 3336 | 88 |
2018790 | 2018790 | 2021-12-16 | Richland | Illinois | 17159 | 3336 | 74 |
2008651 | 2008651 | 2021-12-13 | Pitkin | Colorado | 8097 | 3336 | 6 |
1997480 | 1997480 | 2021-12-09 | Paulding | Ohio | 39125 | 3336 | 51 |
1990440 | 1990440 | 2021-12-07 | Ray | Missouri | 29177 | 3336 | 61 |
1978245 | 1978245 | 2021-12-03 | Rio Grande | Puerto Rico | 72119 | 3336 | |
1974995 | 1974995 | 2021-12-02 | Rio Grande | Puerto Rico | 72119 | 3336 | |
1963954 | 1963954 | 2021-11-29 | Rockcastle | Kentucky | 21203 | 3336 | 37 |
1949775 | 1949775 | 2021-11-24 | Green Lake | Wisconsin | 55047 | 3336 | 36 |
1933697 | 1933697 | 2021-11-20 | La Paz | Arizona | 4012 | 3336 | 102 |
1919960 | 1919960 | 2021-11-15 | Union | Tennessee | 47173 | 3336 | 49 |
1914873 | 1914873 | 2021-11-14 | Starke | Indiana | 18149 | 3336 | 74 |
1911623 | 1911623 | 2021-11-13 | Starke | Indiana | 18149 | 3336 | 74 |
1908374 | 1908374 | 2021-11-12 | Starke | Indiana | 18149 | 3336 | 74 |
1904284 | 1904284 | 2021-11-10 | Langlade | Wisconsin | 55067 | 3336 | 57 |
1894467 | 1894467 | 2021-11-07 | Lincoln | West Virginia | 54043 | 3336 | 45 |
1887757 | 1887757 | 2021-11-05 | Bennington | Vermont | 50003 | 3336 | 27 |
1881646 | 1881646 | 2021-11-04 | Monroe | Alabama | 1099 | 3336 | 66 |
1883136 | 1883136 | 2021-11-04 | Henry | Missouri | 29083 | 3336 | 51 |
1876149 | 1876149 | 2021-11-02 | Harrison | Kentucky | 21097 | 3336 | 39 |
1797243 | 1797243 | 2021-10-09 | Columbia | Arkansas | 5027 | 3336 | 66 |
1777195 | 1777195 | 2021-10-02 | Reeves | Texas | 48389 | 3336 | 49 |
1757820 | 1757820 | 2021-09-26 | Botetourt | Virginia | 51023 | 3336 | 39 |
1754572 | 1754572 | 2021-09-25 | Botetourt | Virginia | 51023 | 3336 | 39 |
1751324 | 1751324 | 2021-09-24 | Botetourt | Virginia | 51023 | 3336 | 39 |
1741403 | 1741403 | 2021-09-21 | Lampasas | Texas | 48281 | 3336 | 52 |
1716152 | 1716152 | 2021-09-14 | Delta | Colorado | 8029 | 3336 | 78 |
1714577 | 1714577 | 2021-09-13 | Dare | North Carolina | 37055 | 3336 | 11 |
1678122 | 1678122 | 2021-09-02 | Dorchester | Maryland | 24019 | 3336 | 68 |
1671538 | 1671538 | 2021-08-31 | Assumption | Louisiana | 22007 | 3336 | 43 |
1668291 | 1668291 | 2021-08-30 | Assumption | Louisiana | 22007 | 3336 | 43 |
1665044 | 1665044 | 2021-08-29 | Assumption | Louisiana | 22007 | 3336 | 43 |
1665294 | 1665294 | 2021-08-29 | Mille Lacs | Minnesota | 27095 | 3336 | 58 |
1661796 | 1661796 | 2021-08-28 | Assumption | Louisiana | 22007 | 3336 | 43 |
1662046 | 1662046 | 2021-08-28 | Mille Lacs | Minnesota | 27095 | 3336 | 58 |
1658548 | 1658548 | 2021-08-27 | Assumption | Louisiana | 22007 | 3336 | 43 |
1658798 | 1658798 | 2021-08-27 | Mille Lacs | Minnesota | 27095 | 3336 | 58 |
1657415 | 1657415 | 2021-08-26 | Park | Wyoming | 56029 | 3336 | 37 |
1647877 | 1647877 | 2021-08-24 | Glenn | California | 6021 | 3336 | 27 |
1623119 | 1623119 | 2021-08-16 | Coahoma | Mississippi | 28027 | 3336 | 86 |
1608185 | 1608185 | 2021-08-11 | Hockley | Texas | 48219 | 3336 | 111 |
1603273 | 1603273 | 2021-08-10 | Logan | Kentucky | 21141 | 3336 | 74 |
1588499 | 1588499 | 2021-08-05 | Claiborne | Tennessee | 47025 | 3336 | 76 |
1575538 | 1575538 | 2021-08-01 | Lauderdale | Tennessee | 47097 | 3336 | 50 |
1572290 | 1572290 | 2021-07-31 | Lauderdale | Tennessee | 47097 | 3336 | 50 |
1569042 | 1569042 | 2021-07-30 | Lauderdale | Tennessee | 47097 | 3336 | 50 |
1563026 | 1563026 | 2021-07-28 | Wise | Virginia | 51195 | 3336 | 105 |
1557811 | 1557811 | 2021-07-27 | Muhlenberg | Kentucky | 21177 | 3336 | 70 |
1541608 | 1541608 | 2021-07-22 | Allen | Louisiana | 22003 | 3336 | 94 |
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);