ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
674 rows where cases = 379 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 83
- Georgia 38
- South Dakota 35
- Kansas 34
- Nebraska 31
- Virginia 25
- Minnesota 24
- Montana 24
- Puerto Rico 23
- Indiana 21
- Oklahoma 21
- Missouri 20
- Colorado 19
- Kentucky 19
- Arkansas 18
- Idaho 17
- North Dakota 16
- Tennessee 15
- Ohio 13
- Washington 13
- Mississippi 12
- North Carolina 12
- Alabama 11
- New York 11
- Illinois 10
- New Mexico 10
- Nevada 9
- Iowa 8
- Michigan 8
- Pennsylvania 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491511 | 2491511 | 2022-05-10 | Gosper | Nebraska | 31073 | 379 | 7 |
2488253 | 2488253 | 2022-05-09 | Gosper | Nebraska | 31073 | 379 | 7 |
2452430 | 2452430 | 2022-04-28 | Gosper | Nebraska | 31073 | 379 | 7 |
2449174 | 2449174 | 2022-04-27 | Gosper | Nebraska | 31073 | 379 | 7 |
2445917 | 2445917 | 2022-04-26 | Gosper | Nebraska | 31073 | 379 | 7 |
2268570 | 2268570 | 2022-03-03 | Denali Borough | Alaska | 2068 | 379 | 1 |
2265317 | 2265317 | 2022-03-02 | Denali Borough | Alaska | 2068 | 379 | 1 |
2237611 | 2237611 | 2022-02-21 | Daniels | Montana | 30019 | 379 | 9 |
2234360 | 2234360 | 2022-02-20 | Daniels | Montana | 30019 | 379 | 9 |
2231109 | 2231109 | 2022-02-19 | Daniels | Montana | 30019 | 379 | 9 |
2227858 | 2227858 | 2022-02-18 | Daniels | Montana | 30019 | 379 | 9 |
2224607 | 2224607 | 2022-02-17 | Daniels | Montana | 30019 | 379 | 9 |
2221356 | 2221356 | 2022-02-16 | Daniels | Montana | 30019 | 379 | 9 |
2218105 | 2218105 | 2022-02-15 | Daniels | Montana | 30019 | 379 | 9 |
2218121 | 2218121 | 2022-02-15 | Liberty | Montana | 30051 | 379 | 3 |
2218193 | 2218193 | 2022-02-15 | Harlan | Nebraska | 31083 | 379 | 2 |
2215281 | 2215281 | 2022-02-14 | Steele | North Dakota | 38091 | 379 | 2 |
2211656 | 2211656 | 2022-02-13 | Boyd | Nebraska | 31015 | 379 | 6 |
2208403 | 2208403 | 2022-02-12 | Boyd | Nebraska | 31015 | 379 | 6 |
2205150 | 2205150 | 2022-02-11 | Boyd | Nebraska | 31015 | 379 | 6 |
2201862 | 2201862 | 2022-02-10 | McCone | Montana | 30055 | 379 | 9 |
2153118 | 2153118 | 2022-01-26 | Franklin | Nebraska | 31061 | 379 | 8 |
2153917 | 2153917 | 2022-01-26 | Jerauld | South Dakota | 46073 | 379 | 19 |
2150665 | 2150665 | 2022-01-25 | Jerauld | South Dakota | 46073 | 379 | 19 |
2132891 | 2132891 | 2022-01-20 | Wallace | Kansas | 20199 | 379 | 5 |
2129638 | 2129638 | 2022-01-19 | Wallace | Kansas | 20199 | 379 | 5 |
2124166 | 2124166 | 2022-01-17 | Logan | North Dakota | 38047 | 379 | 11 |
2110042 | 2110042 | 2022-01-13 | Comanche | Kansas | 20033 | 379 | 13 |
2106791 | 2106791 | 2022-01-12 | Comanche | Kansas | 20033 | 379 | 13 |
2105117 | 2105117 | 2022-01-11 | Haakon | South Dakota | 46055 | 379 | 11 |
2076195 | 2076195 | 2022-01-02 | Schleicher | Texas | 48413 | 379 | 9 |
2072944 | 2072944 | 2022-01-01 | Schleicher | Texas | 48413 | 379 | 9 |
2069693 | 2069693 | 2021-12-31 | Schleicher | Texas | 48413 | 379 | 9 |
2066442 | 2066442 | 2021-12-30 | Schleicher | Texas | 48413 | 379 | 9 |
2051006 | 2051006 | 2021-12-26 | Baker | Georgia | 13007 | 379 | 14 |
2047756 | 2047756 | 2021-12-25 | Baker | Georgia | 13007 | 379 | 14 |
2044506 | 2044506 | 2021-12-24 | Baker | Georgia | 13007 | 379 | 14 |
2041257 | 2041257 | 2021-12-23 | Baker | Georgia | 13007 | 379 | 14 |
2038007 | 2038007 | 2021-12-22 | Baker | Georgia | 13007 | 379 | 14 |
2040376 | 2040376 | 2021-12-22 | Knox | Texas | 48275 | 379 | 22 |
2036874 | 2036874 | 2021-12-21 | Miner | South Dakota | 46097 | 379 | 12 |
2037126 | 2037126 | 2021-12-21 | Knox | Texas | 48275 | 379 | 22 |
2033876 | 2033876 | 2021-12-20 | Knox | Texas | 48275 | 379 | 22 |
2030626 | 2030626 | 2021-12-19 | Knox | Texas | 48275 | 379 | 22 |
1968908 | 1968908 | 2021-11-30 | Oldham | Texas | 48359 | 379 | 6 |
1965657 | 1965657 | 2021-11-29 | Oldham | Texas | 48359 | 379 | 6 |
1960702 | 1960702 | 2021-11-28 | Robertson | Kentucky | 21201 | 379 | 16 |
1957451 | 1957451 | 2021-11-27 | Robertson | Kentucky | 21201 | 379 | 16 |
1954200 | 1954200 | 2021-11-26 | Robertson | Kentucky | 21201 | 379 | 16 |
1950949 | 1950949 | 2021-11-25 | Robertson | Kentucky | 21201 | 379 | 16 |
1947698 | 1947698 | 2021-11-24 | Robertson | Kentucky | 21201 | 379 | 16 |
1944447 | 1944447 | 2021-11-23 | Robertson | Kentucky | 21201 | 379 | 16 |
1940664 | 1940664 | 2021-11-22 | Butte | Idaho | 16023 | 379 | 4 |
1928772 | 1928772 | 2021-11-18 | Brown | Nebraska | 31017 | 379 | 4 |
1876932 | 1876932 | 2021-11-02 | Mora | New Mexico | 35033 | 379 | 11 |
1870303 | 1870303 | 2021-10-31 | Frontier | Nebraska | 31063 | 379 | 1 |
1867054 | 1867054 | 2021-10-30 | Frontier | Nebraska | 31063 | 379 | 1 |
1863805 | 1863805 | 2021-10-29 | Frontier | Nebraska | 31063 | 379 | 1 |
1859113 | 1859113 | 2021-10-28 | Custer | Colorado | 8027 | 379 | 7 |
1859799 | 1859799 | 2021-10-28 | Kiowa | Kansas | 20097 | 379 | 5 |
1856550 | 1856550 | 2021-10-27 | Kiowa | Kansas | 20097 | 379 | 5 |
1852346 | 1852346 | 2021-10-25 | Niobrara | Wyoming | 56027 | 379 | 5 |
1846114 | 1846114 | 2021-10-24 | Costilla | Colorado | 8023 | 379 | 10 |
1847491 | 1847491 | 2021-10-24 | Granite | Montana | 30039 | 379 | 3 |
1848354 | 1848354 | 2021-10-24 | Jackson | South Dakota | 46071 | 379 | 16 |
1842864 | 1842864 | 2021-10-23 | Costilla | Colorado | 8023 | 379 | 10 |
1844241 | 1844241 | 2021-10-23 | Granite | Montana | 30039 | 379 | 3 |
1844650 | 1844650 | 2021-10-23 | Renville | North Dakota | 38075 | 379 | 14 |
1845104 | 1845104 | 2021-10-23 | Jackson | South Dakota | 46071 | 379 | 16 |
1839614 | 1839614 | 2021-10-22 | Costilla | Colorado | 8023 | 379 | 10 |
1840991 | 1840991 | 2021-10-22 | Granite | Montana | 30039 | 379 | 3 |
1841363 | 1841363 | 2021-10-22 | Adams | North Dakota | 38001 | 379 | 4 |
1841854 | 1841854 | 2021-10-22 | Jackson | South Dakota | 46071 | 379 | 16 |
1836365 | 1836365 | 2021-10-21 | Costilla | Colorado | 8023 | 379 | 10 |
1838626 | 1838626 | 2021-10-21 | Sanborn | South Dakota | 46111 | 379 | 3 |
1831663 | 1831663 | 2021-10-19 | Towner | North Dakota | 38095 | 379 | 11 |
1829133 | 1829133 | 2021-10-18 | Lipscomb | Texas | 48295 | 379 | 12 |
1825884 | 1825884 | 2021-10-17 | Lipscomb | Texas | 48295 | 379 | 12 |
1822635 | 1822635 | 2021-10-16 | Lipscomb | Texas | 48295 | 379 | 12 |
1819386 | 1819386 | 2021-10-15 | Lipscomb | Texas | 48295 | 379 | 12 |
1814354 | 1814354 | 2021-10-14 | Smith | Kansas | 20183 | 379 | 3 |
1816137 | 1816137 | 2021-10-14 | Lipscomb | Texas | 48295 | 379 | 12 |
1811105 | 1811105 | 2021-10-13 | Smith | Kansas | 20183 | 379 | 3 |
1812889 | 1812889 | 2021-10-13 | Lipscomb | Texas | 48295 | 379 | 12 |
1785075 | 1785075 | 2021-10-05 | Logan | Kansas | 20109 | 379 | 8 |
1785097 | 1785097 | 2021-10-05 | Rawlins | Kansas | 20153 | 379 | 7 |
1781826 | 1781826 | 2021-10-04 | Logan | Kansas | 20109 | 379 | 8 |
1781848 | 1781848 | 2021-10-04 | Rawlins | Kansas | 20153 | 379 | 7 |
1778598 | 1778598 | 2021-10-03 | Rawlins | Kansas | 20153 | 379 | 7 |
1775348 | 1775348 | 2021-10-02 | Rawlins | Kansas | 20153 | 379 | 7 |
1772098 | 1772098 | 2021-10-01 | Rawlins | Kansas | 20153 | 379 | 7 |
1767155 | 1767155 | 2021-09-29 | Ziebach | South Dakota | 46137 | 379 | 9 |
1763906 | 1763906 | 2021-09-28 | Ziebach | South Dakota | 46137 | 379 | 9 |
1760657 | 1760657 | 2021-09-27 | Ziebach | South Dakota | 46137 | 379 | 9 |
1760962 | 1760962 | 2021-09-27 | Shackelford | Texas | 48417 | 379 | 5 |
1757409 | 1757409 | 2021-09-26 | Ziebach | South Dakota | 46137 | 379 | 9 |
1757714 | 1757714 | 2021-09-26 | Shackelford | Texas | 48417 | 379 | 5 |
1754161 | 1754161 | 2021-09-25 | Ziebach | South Dakota | 46137 | 379 | 9 |
1754466 | 1754466 | 2021-09-25 | Shackelford | Texas | 48417 | 379 | 5 |
1750913 | 1750913 | 2021-09-24 | Ziebach | South Dakota | 46137 | 379 | 9 |
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);