ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where cases = 303 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 93
- Virginia 52
- Kansas 42
- Missouri 40
- South Dakota 35
- Georgia 30
- Utah 30
- New York 29
- North Dakota 29
- Kentucky 23
- Nebraska 23
- Indiana 20
- Puerto Rico 20
- Alabama 19
- Mississippi 19
- Michigan 18
- Pennsylvania 18
- Arkansas 17
- Colorado 17
- Illinois 17
- North Carolina 16
- Oklahoma 16
- Idaho 15
- Nevada 15
- Ohio 15
- Washington 15
- Montana 12
- Louisiana 11
- Minnesota 11
- Oregon 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2316928 | 2316928 | 2022-03-17 | Piute | Utah | 49031 | 303 | 6 |
2313675 | 2313675 | 2022-03-16 | Piute | Utah | 49031 | 303 | 6 |
2310422 | 2310422 | 2022-03-15 | Piute | Utah | 49031 | 303 | 6 |
2307169 | 2307169 | 2022-03-14 | Piute | Utah | 49031 | 303 | 6 |
2303918 | 2303918 | 2022-03-13 | Piute | Utah | 49031 | 303 | 6 |
2300666 | 2300666 | 2022-03-12 | Piute | Utah | 49031 | 303 | 6 |
2297414 | 2297414 | 2022-03-11 | Piute | Utah | 49031 | 303 | 6 |
2294162 | 2294162 | 2022-03-10 | Piute | Utah | 49031 | 303 | 6 |
2290910 | 2290910 | 2022-03-09 | Piute | Utah | 49031 | 303 | 6 |
2287658 | 2287658 | 2022-03-08 | Piute | Utah | 49031 | 303 | 6 |
2284406 | 2284406 | 2022-03-07 | Piute | Utah | 49031 | 303 | 6 |
2281154 | 2281154 | 2022-03-06 | Piute | Utah | 49031 | 303 | 6 |
2277901 | 2277901 | 2022-03-05 | Piute | Utah | 49031 | 303 | 6 |
2274648 | 2274648 | 2022-03-04 | Piute | Utah | 49031 | 303 | 6 |
2271395 | 2271395 | 2022-03-03 | Piute | Utah | 49031 | 303 | 6 |
2268143 | 2268143 | 2022-03-02 | Piute | Utah | 49031 | 303 | 6 |
2264890 | 2264890 | 2022-03-01 | Piute | Utah | 49031 | 303 | 6 |
2260515 | 2260515 | 2022-02-28 | Eureka | Nevada | 32011 | 303 | 1 |
2261640 | 2261640 | 2022-02-28 | Piute | Utah | 49031 | 303 | 6 |
2258389 | 2258389 | 2022-02-27 | Piute | Utah | 49031 | 303 | 6 |
2255138 | 2255138 | 2022-02-26 | Piute | Utah | 49031 | 303 | 6 |
2251887 | 2251887 | 2022-02-25 | Piute | Utah | 49031 | 303 | 6 |
2248636 | 2248636 | 2022-02-24 | Piute | Utah | 49031 | 303 | 6 |
2245385 | 2245385 | 2022-02-23 | Piute | Utah | 49031 | 303 | 6 |
2242134 | 2242134 | 2022-02-22 | Piute | Utah | 49031 | 303 | 6 |
2222230 | 2222230 | 2022-02-16 | Hyde | South Dakota | 46069 | 303 | 7 |
2215488 | 2215488 | 2022-02-14 | Sherman | Oregon | 41055 | 303 | 3 |
2215728 | 2215728 | 2022-02-14 | Hyde | South Dakota | 46069 | 303 | 6 |
2212477 | 2212477 | 2022-02-13 | Hyde | South Dakota | 46069 | 303 | 6 |
2209224 | 2209224 | 2022-02-12 | Hyde | South Dakota | 46069 | 303 | 6 |
2205971 | 2205971 | 2022-02-11 | Hyde | South Dakota | 46069 | 303 | 6 |
2190711 | 2190711 | 2022-02-07 | Cheyenne | Colorado | 8017 | 303 | 9 |
2192152 | 2192152 | 2022-02-07 | Deuel | Nebraska | 31049 | 303 | 2 |
2187458 | 2187458 | 2022-02-06 | Cheyenne | Colorado | 8017 | 303 | 9 |
2184205 | 2184205 | 2022-02-05 | Cheyenne | Colorado | 8017 | 303 | 9 |
2180953 | 2180953 | 2022-02-04 | Cheyenne | Colorado | 8017 | 303 | 9 |
2154260 | 2154260 | 2022-01-26 | Stonewall | Texas | 48433 | 303 | 7 |
2151008 | 2151008 | 2022-01-25 | Stonewall | Texas | 48433 | 303 | 7 |
2151155 | 2151155 | 2022-01-25 | Highland | Virginia | 51091 | 303 | 5 |
2141934 | 2141934 | 2022-01-23 | Kiowa | Colorado | 8061 | 303 | 4 |
2143363 | 2143363 | 2022-01-23 | Garden | Nebraska | 31069 | 303 | 1 |
2138679 | 2138679 | 2022-01-22 | Kiowa | Colorado | 8061 | 303 | 4 |
2140108 | 2140108 | 2022-01-22 | Garden | Nebraska | 31069 | 303 | 1 |
2135423 | 2135423 | 2022-01-21 | Kiowa | Colorado | 8061 | 303 | 4 |
2136852 | 2136852 | 2022-01-21 | Garden | Nebraska | 31069 | 303 | 1 |
2123776 | 2123776 | 2022-01-17 | Liberty | Montana | 30051 | 303 | 2 |
2120524 | 2120524 | 2022-01-16 | Liberty | Montana | 30051 | 303 | 2 |
2117272 | 2117272 | 2022-01-15 | Liberty | Montana | 30051 | 303 | 2 |
2114021 | 2114021 | 2022-01-14 | Liberty | Montana | 30051 | 303 | 2 |
2110828 | 2110828 | 2022-01-13 | Dundy | Nebraska | 31057 | 303 | 6 |
2075414 | 2075414 | 2022-01-02 | Steele | North Dakota | 38091 | 303 | 2 |
2072163 | 2072163 | 2022-01-01 | Steele | North Dakota | 38091 | 303 | 2 |
2068912 | 2068912 | 2021-12-31 | Steele | North Dakota | 38091 | 303 | 2 |
2066518 | 2066518 | 2021-12-30 | Wayne | Utah | 49055 | 303 | 0 |
2063268 | 2063268 | 2021-12-29 | Wayne | Utah | 49055 | 303 | 0 |
2058336 | 2058336 | 2021-12-28 | Unknown | Maryland | 303 | 169 | |
2029925 | 2029925 | 2021-12-19 | Unknown | Northern Mariana Islands | 303 | 2 | |
2016537 | 2016537 | 2021-12-15 | Boyd | Nebraska | 31015 | 303 | 5 |
2013286 | 2013286 | 2021-12-14 | Boyd | Nebraska | 31015 | 303 | 5 |
2003468 | 2003468 | 2021-12-11 | Worth | Missouri | 29227 | 303 | 2 |
1975697 | 1975697 | 2021-12-02 | Wahkiakum | Washington | 53069 | 303 | 5 |
1970977 | 1970977 | 2021-12-01 | Daniels | Montana | 30019 | 303 | 9 |
1967727 | 1967727 | 2021-11-30 | Daniels | Montana | 30019 | 303 | 9 |
1964475 | 1964475 | 2021-11-29 | Daniels | Montana | 30019 | 303 | 9 |
1965688 | 1965688 | 2021-11-29 | Sherman | Texas | 48421 | 303 | 16 |
1929592 | 1929592 | 2021-11-18 | Jerauld | South Dakota | 46073 | 303 | 17 |
1926342 | 1926342 | 2021-11-17 | Jerauld | South Dakota | 46073 | 303 | 17 |
1921584 | 1921584 | 2021-11-16 | Stanton | Kansas | 20187 | 303 | 6 |
1918334 | 1918334 | 2021-11-15 | Stanton | Kansas | 20187 | 303 | 6 |
1902808 | 1902808 | 2021-11-10 | Harlan | Nebraska | 31083 | 303 | 0 |
1898844 | 1898844 | 2021-11-09 | Wichita | Kansas | 20203 | 303 | 6 |
1899558 | 1899558 | 2021-11-09 | Harlan | Nebraska | 31083 | 303 | 0 |
1895594 | 1895594 | 2021-11-08 | Wichita | Kansas | 20203 | 303 | 6 |
1896308 | 1896308 | 2021-11-08 | Harlan | Nebraska | 31083 | 303 | 0 |
1876020 | 1876020 | 2021-11-02 | Elk | Kansas | 20049 | 303 | 6 |
1872771 | 1872771 | 2021-11-01 | Elk | Kansas | 20049 | 303 | 6 |
1809955 | 1809955 | 2021-10-12 | San Juan | Washington | 53055 | 303 | 0 |
1789881 | 1789881 | 2021-10-06 | Mellette | South Dakota | 46095 | 303 | 2 |
1786633 | 1786633 | 2021-10-05 | Mellette | South Dakota | 46095 | 303 | 2 |
1781444 | 1781444 | 2021-10-04 | Butte | Idaho | 16023 | 303 | 3 |
1764886 | 1764886 | 2021-09-29 | Custer | Colorado | 8027 | 303 | 6 |
1762319 | 1762319 | 2021-09-28 | Jewell | Kansas | 20089 | 303 | 6 |
1763400 | 1763400 | 2021-09-28 | Golden Valley | North Dakota | 38033 | 303 | 4 |
1759071 | 1759071 | 2021-09-27 | Jewell | Kansas | 20089 | 303 | 6 |
1760158 | 1760158 | 2021-09-27 | Logan | North Dakota | 38047 | 303 | 10 |
1761195 | 1761195 | 2021-09-27 | Columbia | Washington | 53013 | 303 | 6 |
1756910 | 1756910 | 2021-09-26 | Logan | North Dakota | 38047 | 303 | 10 |
1758120 | 1758120 | 2021-09-26 | Niobrara | Wyoming | 56027 | 303 | 4 |
1754872 | 1754872 | 2021-09-25 | Niobrara | Wyoming | 56027 | 303 | 4 |
1751300 | 1751300 | 2021-09-24 | Grand Isle | Vermont | 50013 | 303 | 2 |
1751624 | 1751624 | 2021-09-24 | Niobrara | Wyoming | 56027 | 303 | 4 |
1746055 | 1746055 | 2021-09-23 | Edwards | Kansas | 20047 | 303 | 12 |
1748051 | 1748051 | 2021-09-23 | Grand Isle | Vermont | 50013 | 303 | 2 |
1742806 | 1742806 | 2021-09-22 | Edwards | Kansas | 20047 | 303 | 12 |
1732714 | 1732714 | 2021-09-19 | Custer | Idaho | 16037 | 303 | 3 |
1734627 | 1734627 | 2021-09-19 | Haakon | South Dakota | 46055 | 303 | 11 |
1729464 | 1729464 | 2021-09-18 | Custer | Idaho | 16037 | 303 | 3 |
1731377 | 1731377 | 2021-09-18 | Haakon | South Dakota | 46055 | 303 | 11 |
1728127 | 1728127 | 2021-09-17 | Haakon | South Dakota | 46055 | 303 | 11 |
1722646 | 1722646 | 2021-09-16 | Costilla | Colorado | 8023 | 303 | 6 |
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);