ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
358 rows where cases = 1458 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 40
- Texas 25
- Kentucky 19
- Puerto Rico 17
- Missouri 16
- Wisconsin 14
- Minnesota 13
- Florida 12
- Iowa 12
- Oklahoma 12
- Kansas 11
- Virginia 11
- Alabama 10
- Arkansas 10
- Oregon 10
- West Virginia 10
- South Carolina 9
- Tennessee 9
- Mississippi 7
- North Dakota 7
- Michigan 6
- Nebraska 6
- Washington 6
- California 5
- Illinois 5
- Indiana 5
- Louisiana 4
- New York 4
- Ohio 4
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500337 | 2500337 | 2022-05-13 | Ohio | Indiana | 18115 | 1458 | 19 |
2387970 | 2387970 | 2022-04-08 | Guanica | Puerto Rico | 72055 | 1458 | |
2316811 | 2316811 | 2022-03-17 | Lynn | Texas | 48305 | 1458 | 38 |
2313558 | 2313558 | 2022-03-16 | Lynn | Texas | 48305 | 1458 | 38 |
2310305 | 2310305 | 2022-03-15 | Lynn | Texas | 48305 | 1458 | 38 |
2307052 | 2307052 | 2022-03-14 | Lynn | Texas | 48305 | 1458 | 38 |
2303801 | 2303801 | 2022-03-13 | Lynn | Texas | 48305 | 1458 | 38 |
2300549 | 2300549 | 2022-03-12 | Lynn | Texas | 48305 | 1458 | 38 |
2297297 | 2297297 | 2022-03-11 | Lynn | Texas | 48305 | 1458 | 38 |
2292256 | 2292256 | 2022-03-10 | Stevens | Kansas | 20189 | 1458 | 18 |
2289004 | 2289004 | 2022-03-09 | Stevens | Kansas | 20189 | 1458 | 18 |
2285753 | 2285753 | 2022-03-08 | Stevens | Kansas | 20189 | 1458 | 18 |
2282501 | 2282501 | 2022-03-07 | Stevens | Kansas | 20189 | 1458 | 18 |
2281439 | 2281439 | 2022-03-06 | Iron | Wisconsin | 55051 | 1458 | 47 |
2278186 | 2278186 | 2022-03-05 | Iron | Wisconsin | 55051 | 1458 | 47 |
2274933 | 2274933 | 2022-03-04 | Iron | Wisconsin | 55051 | 1458 | 47 |
2271680 | 2271680 | 2022-03-03 | Iron | Wisconsin | 55051 | 1458 | 46 |
2268428 | 2268428 | 2022-03-02 | Iron | Wisconsin | 55051 | 1458 | 46 |
2265175 | 2265175 | 2022-03-01 | Iron | Wisconsin | 55051 | 1458 | 46 |
2261925 | 2261925 | 2022-02-28 | Iron | Wisconsin | 55051 | 1458 | 46 |
2219226 | 2219226 | 2022-02-15 | Jack | Texas | 48237 | 1458 | 26 |
2194307 | 2194307 | 2022-02-08 | Power | Idaho | 16077 | 1458 | 18 |
2195158 | 2195158 | 2022-02-08 | Jefferson | Mississippi | 28063 | 1458 | 35 |
2195226 | 2195226 | 2022-02-08 | Carter | Missouri | 29035 | 1458 | 19 |
2190616 | 2190616 | 2022-02-07 | Montgomery | Arkansas | 5097 | 1458 | 53 |
2187363 | 2187363 | 2022-02-06 | Montgomery | Arkansas | 5097 | 1458 | 53 |
2177934 | 2177934 | 2022-02-03 | Marion | Georgia | 13197 | 1458 | 43 |
2152937 | 2152937 | 2022-01-26 | Clark | Missouri | 29045 | 1458 | 28 |
2141514 | 2141514 | 2022-01-22 | Calhoun | West Virginia | 54013 | 1458 | 10 |
2132425 | 2132425 | 2022-01-20 | Treutlen | Georgia | 13283 | 1458 | 55 |
2111050 | 2111050 | 2022-01-13 | Camden | North Carolina | 37029 | 1458 | 9 |
2106036 | 2106036 | 2022-01-12 | Monroe | Arkansas | 5095 | 1458 | 26 |
2096011 | 2096011 | 2022-01-08 | Pocahontas | West Virginia | 54075 | 1458 | 23 |
2084543 | 2084543 | 2022-01-05 | Choctaw | Mississippi | 28019 | 1458 | 27 |
2079244 | 2079244 | 2022-01-03 | Archer | Texas | 48009 | 1458 | 24 |
2058091 | 2058091 | 2021-12-28 | Russell | Kansas | 20167 | 1458 | 34 |
2059488 | 2059488 | 2021-12-28 | Luquillo | Puerto Rico | 72089 | 1458 | |
2059562 | 2059562 | 2021-12-28 | McCormick | South Carolina | 45065 | 1458 | 30 |
2054842 | 2054842 | 2021-12-27 | Russell | Kansas | 20167 | 1458 | 34 |
2056313 | 2056313 | 2021-12-27 | McCormick | South Carolina | 45065 | 1458 | 30 |
2050772 | 2050772 | 2021-12-26 | Nevada | Arkansas | 5099 | 1458 | 42 |
2050920 | 2050920 | 2021-12-26 | Yuma | Colorado | 8125 | 1458 | 21 |
2053064 | 2053064 | 2021-12-26 | McCormick | South Carolina | 45065 | 1458 | 30 |
2047670 | 2047670 | 2021-12-25 | Yuma | Colorado | 8125 | 1458 | 21 |
2049814 | 2049814 | 2021-12-25 | McCormick | South Carolina | 45065 | 1458 | 30 |
2044420 | 2044420 | 2021-12-24 | Yuma | Colorado | 8125 | 1458 | 21 |
2046564 | 2046564 | 2021-12-24 | McCormick | South Carolina | 45065 | 1458 | 30 |
2043314 | 2043314 | 2021-12-23 | McCormick | South Carolina | 45065 | 1458 | 30 |
2038978 | 2038978 | 2021-12-22 | Lake | Minnesota | 27075 | 1458 | 26 |
2039455 | 2039455 | 2021-12-22 | Sierra | New Mexico | 35051 | 1458 | 63 |
2036558 | 2036558 | 2021-12-21 | Major | Oklahoma | 40093 | 1458 | 34 |
2037023 | 2037023 | 2021-12-21 | Castro | Texas | 48069 | 1458 | 41 |
2033308 | 2033308 | 2021-12-20 | Major | Oklahoma | 40093 | 1458 | 34 |
2033773 | 2033773 | 2021-12-20 | Castro | Texas | 48069 | 1458 | 40 |
2030058 | 2030058 | 2021-12-19 | Major | Oklahoma | 40093 | 1458 | 34 |
2030523 | 2030523 | 2021-12-19 | Castro | Texas | 48069 | 1458 | 40 |
2026620 | 2026620 | 2021-12-18 | Benson | North Dakota | 38005 | 1458 | 21 |
2026807 | 2026807 | 2021-12-18 | Major | Oklahoma | 40093 | 1458 | 34 |
2026950 | 2026950 | 2021-12-18 | Anasco | Puerto Rico | 72011 | 1458 | |
2023556 | 2023556 | 2021-12-17 | Major | Oklahoma | 40093 | 1458 | 34 |
2020305 | 2020305 | 2021-12-16 | Major | Oklahoma | 40093 | 1458 | 34 |
2017054 | 2017054 | 2021-12-15 | Major | Oklahoma | 40093 | 1458 | 34 |
2010010 | 2010010 | 2021-12-13 | Powell | Montana | 30077 | 1458 | 25 |
1995697 | 1995697 | 2021-12-09 | Glades | Florida | 12043 | 1458 | 33 |
1992446 | 1992446 | 2021-12-08 | Glades | Florida | 12043 | 1458 | 33 |
1989195 | 1989195 | 2021-12-07 | Glades | Florida | 12043 | 1458 | 33 |
1990539 | 1990539 | 2021-12-07 | Cheyenne | Nebraska | 31033 | 1458 | 19 |
1985945 | 1985945 | 2021-12-06 | Glades | Florida | 12043 | 1458 | 33 |
1988710 | 1988710 | 2021-12-06 | Doddridge | West Virginia | 54017 | 1458 | 12 |
1982695 | 1982695 | 2021-12-05 | Glades | Florida | 12043 | 1458 | 33 |
1985460 | 1985460 | 2021-12-05 | Doddridge | West Virginia | 54017 | 1458 | 12 |
1979445 | 1979445 | 2021-12-04 | Glades | Florida | 12043 | 1458 | 33 |
1976195 | 1976195 | 2021-12-03 | Glades | Florida | 12043 | 1458 | 33 |
1972946 | 1972946 | 2021-12-02 | Glades | Florida | 12043 | 1458 | 33 |
1975081 | 1975081 | 2021-12-02 | Custer | South Dakota | 46033 | 1458 | 19 |
1969696 | 1969696 | 2021-12-01 | Glades | Florida | 12043 | 1458 | 33 |
1971832 | 1971832 | 2021-12-01 | Custer | South Dakota | 46033 | 1458 | 19 |
1966446 | 1966446 | 2021-11-30 | Glades | Florida | 12043 | 1458 | 33 |
1969213 | 1969213 | 2021-11-30 | Gilmer | West Virginia | 54021 | 1458 | 14 |
1965963 | 1965963 | 2021-11-29 | Gilmer | West Virginia | 54021 | 1458 | 14 |
1960067 | 1960067 | 2021-11-28 | Irwin | Georgia | 13155 | 1458 | 40 |
1961114 | 1961114 | 2021-11-28 | Carroll | Missouri | 29033 | 1458 | 39 |
1956816 | 1956816 | 2021-11-27 | Irwin | Georgia | 13155 | 1458 | 40 |
1957863 | 1957863 | 2021-11-27 | Carroll | Missouri | 29033 | 1458 | 39 |
1953565 | 1953565 | 2021-11-26 | Irwin | Georgia | 13155 | 1458 | 40 |
1954612 | 1954612 | 2021-11-26 | Carroll | Missouri | 29033 | 1458 | 39 |
1950314 | 1950314 | 2021-11-25 | Irwin | Georgia | 13155 | 1458 | 40 |
1951361 | 1951361 | 2021-11-25 | Carroll | Missouri | 29033 | 1458 | 39 |
1947063 | 1947063 | 2021-11-24 | Irwin | Georgia | 13155 | 1458 | 40 |
1948110 | 1948110 | 2021-11-24 | Carroll | Missouri | 29033 | 1458 | 39 |
1944268 | 1944268 | 2021-11-23 | Ellsworth | Kansas | 20053 | 1458 | 31 |
1946482 | 1946482 | 2021-11-23 | Pleasants | West Virginia | 54073 | 1458 | 30 |
1941018 | 1941018 | 2021-11-22 | Ellsworth | Kansas | 20053 | 1458 | 31 |
1937312 | 1937312 | 2021-11-21 | Irwin | Georgia | 13155 | 1458 | 40 |
1938388 | 1938388 | 2021-11-21 | Iron | Missouri | 29093 | 1458 | 26 |
1934062 | 1934062 | 2021-11-20 | Irwin | Georgia | 13155 | 1458 | 40 |
1930810 | 1930810 | 2021-11-19 | Irwin | Georgia | 13155 | 1458 | 40 |
1927560 | 1927560 | 2021-11-18 | Irwin | Georgia | 13155 | 1458 | 40 |
1924310 | 1924310 | 2021-11-17 | Irwin | Georgia | 13155 | 1458 | 40 |
1917336 | 1917336 | 2021-11-14 | Platte | Wyoming | 56031 | 1458 | 26 |
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);