ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where cases = 2041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 37
- Georgia 28
- Puerto Rico 21
- Texas 18
- Arkansas 14
- Virginia 14
- Indiana 13
- Tennessee 13
- West Virginia 12
- Kentucky 11
- Mississippi 11
- Iowa 10
- Michigan 9
- Wisconsin 9
- Oklahoma 8
- Louisiana 7
- Missouri 7
- New Mexico 7
- Alabama 6
- Colorado 6
- Montana 6
- Illinois 5
- Minnesota 5
- Pennsylvania 5
- Idaho 4
- New York 4
- Oregon 4
- Vermont 4
- Maryland 3
- North Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494905 | 2494905 | 2022-05-11 | Sierra | New Mexico | 35051 | 2041 | 73 |
2487924 | 2487924 | 2022-05-09 | Murray | Minnesota | 27101 | 2041 | 16 |
2484980 | 2484980 | 2022-05-08 | Custer | Nebraska | 31041 | 2041 | 30 |
2481722 | 2481722 | 2022-05-07 | Custer | Nebraska | 31041 | 2041 | 30 |
2478464 | 2478464 | 2022-05-06 | Custer | Nebraska | 31041 | 2041 | 30 |
2475206 | 2475206 | 2022-05-05 | Custer | Nebraska | 31041 | 2041 | 30 |
2452414 | 2452414 | 2022-04-28 | Custer | Nebraska | 31041 | 2041 | 30 |
2449158 | 2449158 | 2022-04-27 | Custer | Nebraska | 31041 | 2041 | 30 |
2445901 | 2445901 | 2022-04-26 | Custer | Nebraska | 31041 | 2041 | 30 |
2442646 | 2442646 | 2022-04-25 | Custer | Nebraska | 31041 | 2041 | 30 |
2438221 | 2438221 | 2022-04-24 | Terrell | Georgia | 13273 | 2041 | 66 |
2439390 | 2439390 | 2022-04-24 | Custer | Nebraska | 31041 | 2041 | 30 |
2434965 | 2434965 | 2022-04-23 | Terrell | Georgia | 13273 | 2041 | 66 |
2436134 | 2436134 | 2022-04-23 | Custer | Nebraska | 31041 | 2041 | 30 |
2431709 | 2431709 | 2022-04-22 | Terrell | Georgia | 13273 | 2041 | 66 |
2432878 | 2432878 | 2022-04-22 | Custer | Nebraska | 31041 | 2041 | 30 |
2428453 | 2428453 | 2022-04-21 | Terrell | Georgia | 13273 | 2041 | 66 |
2429774 | 2429774 | 2022-04-21 | Sierra | New Mexico | 35051 | 2041 | 70 |
2425197 | 2425197 | 2022-04-20 | Terrell | Georgia | 13273 | 2041 | 66 |
2426518 | 2426518 | 2022-04-20 | Sierra | New Mexico | 35051 | 2041 | 70 |
2421941 | 2421941 | 2022-04-19 | Terrell | Georgia | 13273 | 2041 | 65 |
2418685 | 2418685 | 2022-04-18 | Terrell | Georgia | 13273 | 2041 | 65 |
2415429 | 2415429 | 2022-04-17 | Terrell | Georgia | 13273 | 2041 | 65 |
2412173 | 2412173 | 2022-04-16 | Terrell | Georgia | 13273 | 2041 | 65 |
2408917 | 2408917 | 2022-04-15 | Terrell | Georgia | 13273 | 2041 | 65 |
2405661 | 2405661 | 2022-04-14 | Terrell | Georgia | 13273 | 2041 | 65 |
2402406 | 2402406 | 2022-04-13 | Terrell | Georgia | 13273 | 2041 | 64 |
2399151 | 2399151 | 2022-04-12 | Terrell | Georgia | 13273 | 2041 | 64 |
2395896 | 2395896 | 2022-04-11 | Terrell | Georgia | 13273 | 2041 | 64 |
2361195 | 2361195 | 2022-03-31 | Carbon | Montana | 30009 | 2041 | 28 |
2357941 | 2357941 | 2022-03-30 | Carbon | Montana | 30009 | 2041 | 28 |
2354688 | 2354688 | 2022-03-29 | Carbon | Montana | 30009 | 2041 | 28 |
2301032 | 2301032 | 2022-03-13 | Choctaw | Alabama | 1023 | 2041 | 35 |
2301589 | 2301589 | 2022-03-13 | Boundary | Idaho | 16021 | 2041 | 58 |
2297780 | 2297780 | 2022-03-12 | Choctaw | Alabama | 1023 | 2041 | 35 |
2298337 | 2298337 | 2022-03-12 | Boundary | Idaho | 16021 | 2041 | 58 |
2294528 | 2294528 | 2022-03-11 | Choctaw | Alabama | 1023 | 2041 | 35 |
2295085 | 2295085 | 2022-03-11 | Boundary | Idaho | 16021 | 2041 | 58 |
2284175 | 2284175 | 2022-03-07 | Clay | Texas | 48077 | 2041 | 32 |
2280923 | 2280923 | 2022-03-06 | Clay | Texas | 48077 | 2041 | 32 |
2277670 | 2277670 | 2022-03-05 | Clay | Texas | 48077 | 2041 | 32 |
2266617 | 2266617 | 2022-03-02 | Marshall | Minnesota | 27089 | 2041 | 23 |
2261881 | 2261881 | 2022-02-28 | Pleasants | West Virginia | 54073 | 2041 | 34 |
2241609 | 2241609 | 2022-02-22 | Jayuya | Puerto Rico | 72073 | 2041 | |
2238358 | 2238358 | 2022-02-21 | Jayuya | Puerto Rico | 72073 | 2041 | |
2232910 | 2232910 | 2022-02-20 | Searcy | Arkansas | 5129 | 2041 | 41 |
2235107 | 2235107 | 2022-02-20 | Jayuya | Puerto Rico | 72073 | 2041 | |
2220522 | 2220522 | 2022-02-16 | Warren | Indiana | 18171 | 2041 | 25 |
2216892 | 2216892 | 2022-02-15 | Candler | Georgia | 13043 | 2041 | 91 |
2217795 | 2217795 | 2022-02-15 | Presque Isle | Michigan | 26141 | 2041 | 55 |
2219590 | 2219590 | 2022-02-15 | Doddridge | West Virginia | 54017 | 2041 | 17 |
2214544 | 2214544 | 2022-02-14 | Presque Isle | Michigan | 26141 | 2041 | 55 |
2211008 | 2211008 | 2022-02-13 | Cumberland | Kentucky | 21057 | 2041 | 24 |
2207755 | 2207755 | 2022-02-12 | Cumberland | Kentucky | 21057 | 2041 | 24 |
2204502 | 2204502 | 2022-02-11 | Cumberland | Kentucky | 21057 | 2041 | 24 |
2201232 | 2201232 | 2022-02-10 | Bracken | Kentucky | 21023 | 2041 | 23 |
2186582 | 2186582 | 2022-02-05 | Archer | Texas | 48009 | 2041 | 25 |
2173335 | 2173335 | 2022-02-01 | Rincon | Puerto Rico | 72117 | 2041 | |
2169139 | 2169139 | 2022-01-31 | Kemper | Mississippi | 28069 | 2041 | 43 |
2160746 | 2160746 | 2022-01-28 | Red River | Texas | 48387 | 2041 | 59 |
2154182 | 2154182 | 2022-01-26 | La Salle | Texas | 48283 | 2041 | 41 |
2148288 | 2148288 | 2022-01-25 | Cleveland | Arkansas | 5025 | 2041 | 33 |
2142102 | 2142102 | 2022-01-23 | Evans | Georgia | 13109 | 2041 | 58 |
2138847 | 2138847 | 2022-01-22 | Evans | Georgia | 13109 | 2041 | 58 |
2135591 | 2135591 | 2022-01-21 | Evans | Georgia | 13109 | 2041 | 58 |
2129708 | 2129708 | 2022-01-19 | Lee | Kentucky | 21129 | 2041 | 44 |
2128366 | 2128366 | 2022-01-18 | Galax city | Virginia | 51640 | 2041 | 70 |
2110408 | 2110408 | 2022-01-13 | Iron | Michigan | 26071 | 2041 | 74 |
2107157 | 2107157 | 2022-01-12 | Iron | Michigan | 26071 | 2041 | 74 |
2103481 | 2103481 | 2022-01-11 | Louisa | Iowa | 19115 | 2041 | 55 |
2100230 | 2100230 | 2022-01-10 | Louisa | Iowa | 19115 | 2041 | 55 |
2096979 | 2096979 | 2022-01-09 | Louisa | Iowa | 19115 | 2041 | 55 |
2093727 | 2093727 | 2022-01-08 | Louisa | Iowa | 19115 | 2041 | 55 |
2090475 | 2090475 | 2022-01-07 | Louisa | Iowa | 19115 | 2041 | 55 |
2087224 | 2087224 | 2022-01-06 | Louisa | Iowa | 19115 | 2041 | 55 |
2083972 | 2083972 | 2022-01-05 | Louisa | Iowa | 19115 | 2041 | 55 |
2085355 | 2085355 | 2022-01-05 | Curry | Oregon | 41015 | 2041 | 40 |
2070243 | 2070243 | 2022-01-01 | Desha | Arkansas | 5041 | 2041 | 36 |
2063789 | 2063789 | 2021-12-30 | Stone | Arkansas | 5137 | 2041 | 48 |
2059364 | 2059364 | 2021-12-28 | Morrow | Oregon | 41049 | 2041 | 25 |
2030207 | 2030207 | 2021-12-19 | Cabo Rojo | Puerto Rico | 72023 | 2041 | |
2020687 | 2020687 | 2021-12-16 | Lake | Tennessee | 47095 | 2041 | 32 |
2017436 | 2017436 | 2021-12-15 | Lake | Tennessee | 47095 | 2041 | 32 |
2008473 | 2008473 | 2021-12-13 | Bradley | Arkansas | 5011 | 2041 | 42 |
2005222 | 2005222 | 2021-12-12 | Bradley | Arkansas | 5011 | 2041 | 42 |
1977757 | 1977757 | 2021-12-03 | Yates | New York | 36123 | 2041 | 34 |
1963929 | 1963929 | 2021-11-29 | Martin | Kentucky | 21159 | 2041 | 36 |
1955105 | 1955105 | 2021-11-26 | Barnes | North Dakota | 38003 | 2041 | 38 |
1946002 | 1946002 | 2021-11-23 | Camp | Texas | 48063 | 2041 | 67 |
1915278 | 1915278 | 2021-11-14 | West Carroll | Louisiana | 22123 | 2041 | 50 |
1912028 | 1912028 | 2021-11-13 | West Carroll | Louisiana | 22123 | 2041 | 50 |
1908779 | 1908779 | 2021-11-12 | West Carroll | Louisiana | 22123 | 2041 | 50 |
1900824 | 1900824 | 2021-11-09 | Goochland | Virginia | 51075 | 2041 | 30 |
1896089 | 1896089 | 2021-11-08 | Webster | Mississippi | 28155 | 2041 | 48 |
1892839 | 1892839 | 2021-11-07 | Webster | Mississippi | 28155 | 2041 | 48 |
1889589 | 1889589 | 2021-11-06 | Webster | Mississippi | 28155 | 2041 | 48 |
1886339 | 1886339 | 2021-11-05 | Webster | Mississippi | 28155 | 2041 | 48 |
1883854 | 1883854 | 2021-11-04 | Tillamook | Oregon | 41057 | 2041 | 37 |
1880697 | 1880697 | 2021-11-03 | Cayey | Puerto Rico | 72035 | 2041 | |
1877448 | 1877448 | 2021-11-02 | Cayey | Puerto Rico | 72035 | 2041 |
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);