ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,443 rows where cases = 105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state 50
- Texas 169
- Nebraska 82
- Virginia 68
- Georgia 52
- Iowa 50
- Kentucky 49
- Illinois 48
- Colorado 47
- Indiana 45
- Kansas 43
- Puerto Rico 42
- California 41
- Minnesota 40
- South Dakota 38
- North Carolina 37
- Missouri 35
- Mississippi 34
- Montana 32
- New York 32
- North Dakota 32
- Ohio 31
- Tennessee 29
- Alaska 28
- West Virginia 28
- Wisconsin 24
- Michigan 23
- Idaho 22
- Pennsylvania 22
- Utah 21
- Arkansas 19
- Oklahoma 19
- Louisiana 17
- Oregon 16
- Vermont 15
- Alabama 13
- Washington 13
- Florida 11
- New Mexico 11
- South Carolina 11
- Wyoming 11
- Maine 10
- Nevada 8
- Maryland 7
- New Hampshire 7
- Delaware 4
- Arizona 2
- Massachusetts 2
- Hawaii 1
- New Jersey 1
- Rhode Island 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446267 | 2446267 | 2022-04-26 | Unknown | North Dakota | 105 | 78 | |
2400341 | 2400341 | 2022-04-12 | Hayes | Nebraska | 31085 | 105 | 0 |
2397086 | 2397086 | 2022-04-11 | Hayes | Nebraska | 31085 | 105 | 0 |
2393831 | 2393831 | 2022-04-10 | Hayes | Nebraska | 31085 | 105 | 0 |
2390575 | 2390575 | 2022-04-09 | Hayes | Nebraska | 31085 | 105 | 0 |
2386489 | 2386489 | 2022-04-08 | Unknown | Iowa | 105 | 0 | |
2387319 | 2387319 | 2022-04-08 | Hayes | Nebraska | 31085 | 105 | 0 |
2383235 | 2383235 | 2022-04-07 | Unknown | Iowa | 105 | 0 | |
2384064 | 2384064 | 2022-04-07 | Hayes | Nebraska | 31085 | 105 | 0 |
2380809 | 2380809 | 2022-04-06 | Hayes | Nebraska | 31085 | 105 | 0 |
2377554 | 2377554 | 2022-04-05 | Hayes | Nebraska | 31085 | 105 | 0 |
2374301 | 2374301 | 2022-04-04 | Hayes | Nebraska | 31085 | 105 | 0 |
2371049 | 2371049 | 2022-04-03 | Hayes | Nebraska | 31085 | 105 | 0 |
2367796 | 2367796 | 2022-04-02 | Hayes | Nebraska | 31085 | 105 | 0 |
2364543 | 2364543 | 2022-04-01 | Hayes | Nebraska | 31085 | 105 | 0 |
2361289 | 2361289 | 2022-03-31 | Hayes | Nebraska | 31085 | 105 | 0 |
2361633 | 2361633 | 2022-03-31 | Unknown | North Dakota | 105 | 47 | |
2348277 | 2348277 | 2022-03-27 | Hayes | Nebraska | 31085 | 105 | 0 |
2345024 | 2345024 | 2022-03-26 | Hayes | Nebraska | 31085 | 105 | 0 |
2341771 | 2341771 | 2022-03-25 | Hayes | Nebraska | 31085 | 105 | 0 |
2325505 | 2325505 | 2022-03-20 | Hayes | Nebraska | 31085 | 105 | 0 |
2322251 | 2322251 | 2022-03-19 | Hayes | Nebraska | 31085 | 105 | 0 |
2318997 | 2318997 | 2022-03-18 | Hayes | Nebraska | 31085 | 105 | 0 |
2315744 | 2315744 | 2022-03-17 | Hayes | Nebraska | 31085 | 105 | 0 |
2305986 | 2305986 | 2022-03-14 | Hayes | Nebraska | 31085 | 105 | 0 |
2292979 | 2292979 | 2022-03-10 | Hayes | Nebraska | 31085 | 105 | 0 |
2289727 | 2289727 | 2022-03-09 | Hayes | Nebraska | 31085 | 105 | 0 |
2270212 | 2270212 | 2022-03-03 | Hayes | Nebraska | 31085 | 105 | 0 |
2266959 | 2266959 | 2022-03-02 | Hayes | Nebraska | 31085 | 105 | 0 |
2263708 | 2263708 | 2022-03-01 | Hayes | Nebraska | 31085 | 105 | 0 |
2260457 | 2260457 | 2022-02-28 | Hayes | Nebraska | 31085 | 105 | 0 |
2257201 | 2257201 | 2022-02-27 | Grant | Nebraska | 31075 | 105 | 5 |
2257206 | 2257206 | 2022-02-27 | Hayes | Nebraska | 31085 | 105 | 0 |
2253950 | 2253950 | 2022-02-26 | Grant | Nebraska | 31075 | 105 | 5 |
2253955 | 2253955 | 2022-02-26 | Hayes | Nebraska | 31085 | 105 | 0 |
2250699 | 2250699 | 2022-02-25 | Grant | Nebraska | 31075 | 105 | 5 |
2250704 | 2250704 | 2022-02-25 | Hayes | Nebraska | 31085 | 105 | 0 |
2247448 | 2247448 | 2022-02-24 | Grant | Nebraska | 31075 | 105 | 5 |
2244197 | 2244197 | 2022-02-23 | Grant | Nebraska | 31075 | 105 | 5 |
2240946 | 2240946 | 2022-02-22 | Grant | Nebraska | 31075 | 105 | 5 |
2237695 | 2237695 | 2022-02-21 | Grant | Nebraska | 31075 | 105 | 5 |
2234444 | 2234444 | 2022-02-20 | Grant | Nebraska | 31075 | 105 | 5 |
2231193 | 2231193 | 2022-02-19 | Grant | Nebraska | 31075 | 105 | 5 |
2227942 | 2227942 | 2022-02-18 | Grant | Nebraska | 31075 | 105 | 5 |
2224691 | 2224691 | 2022-02-17 | Grant | Nebraska | 31075 | 105 | 5 |
2221440 | 2221440 | 2022-02-16 | Grant | Nebraska | 31075 | 105 | 5 |
2187778 | 2187778 | 2022-02-06 | Clark | Idaho | 16033 | 105 | 0 |
2184525 | 2184525 | 2022-02-05 | Clark | Idaho | 16033 | 105 | 0 |
2181273 | 2181273 | 2022-02-04 | Clark | Idaho | 16033 | 105 | 0 |
2178022 | 2178022 | 2022-02-03 | Clark | Idaho | 16033 | 105 | 0 |
2174769 | 2174769 | 2022-02-02 | Clark | Idaho | 16033 | 105 | 0 |
1985903 | 1985903 | 2021-12-06 | San Juan | Colorado | 8111 | 105 | 0 |
1982653 | 1982653 | 2021-12-05 | San Juan | Colorado | 8111 | 105 | 0 |
1979403 | 1979403 | 2021-12-04 | San Juan | Colorado | 8111 | 105 | 0 |
1976153 | 1976153 | 2021-12-03 | San Juan | Colorado | 8111 | 105 | 0 |
1969654 | 1969654 | 2021-12-01 | San Juan | Colorado | 8111 | 105 | 0 |
1943646 | 1943646 | 2021-11-23 | San Juan | Colorado | 8111 | 105 | 0 |
1942103 | 1942103 | 2021-11-22 | Billings | North Dakota | 38007 | 105 | 1 |
1937033 | 1937033 | 2021-11-21 | Alpine | California | 6003 | 105 | 0 |
1938853 | 1938853 | 2021-11-21 | Billings | North Dakota | 38007 | 105 | 1 |
1933783 | 1933783 | 2021-11-20 | Alpine | California | 6003 | 105 | 0 |
1935603 | 1935603 | 2021-11-20 | Billings | North Dakota | 38007 | 105 | 1 |
1930531 | 1930531 | 2021-11-19 | Alpine | California | 6003 | 105 | 0 |
1932353 | 1932353 | 2021-11-19 | Billings | North Dakota | 38007 | 105 | 1 |
1927281 | 1927281 | 2021-11-18 | Alpine | California | 6003 | 105 | 0 |
1924031 | 1924031 | 2021-11-17 | Alpine | California | 6003 | 105 | 0 |
1924144 | 1924144 | 2021-11-17 | San Juan | Colorado | 8111 | 105 | 0 |
1920782 | 1920782 | 2021-11-16 | Alpine | California | 6003 | 105 | 0 |
1920895 | 1920895 | 2021-11-16 | San Juan | Colorado | 8111 | 105 | 0 |
1917532 | 1917532 | 2021-11-15 | Alpine | California | 6003 | 105 | 0 |
1917645 | 1917645 | 2021-11-15 | San Juan | Colorado | 8111 | 105 | 0 |
1914282 | 1914282 | 2021-11-14 | Alpine | California | 6003 | 105 | 0 |
1914395 | 1914395 | 2021-11-14 | San Juan | Colorado | 8111 | 105 | 0 |
1911032 | 1911032 | 2021-11-13 | Alpine | California | 6003 | 105 | 0 |
1911145 | 1911145 | 2021-11-13 | San Juan | Colorado | 8111 | 105 | 0 |
1907783 | 1907783 | 2021-11-12 | Alpine | California | 6003 | 105 | 0 |
1907896 | 1907896 | 2021-11-12 | San Juan | Colorado | 8111 | 105 | 0 |
1904534 | 1904534 | 2021-11-11 | Alpine | California | 6003 | 105 | 0 |
1904647 | 1904647 | 2021-11-11 | San Juan | Colorado | 8111 | 105 | 0 |
1901284 | 1901284 | 2021-11-10 | Alpine | California | 6003 | 105 | 0 |
1898034 | 1898034 | 2021-11-09 | Alpine | California | 6003 | 105 | 0 |
1894784 | 1894784 | 2021-11-08 | Alpine | California | 6003 | 105 | 0 |
1891534 | 1891534 | 2021-11-07 | Alpine | California | 6003 | 105 | 0 |
1888284 | 1888284 | 2021-11-06 | Alpine | California | 6003 | 105 | 0 |
1885034 | 1885034 | 2021-11-05 | Alpine | California | 6003 | 105 | 0 |
1881785 | 1881785 | 2021-11-04 | Alpine | California | 6003 | 105 | 0 |
1878536 | 1878536 | 2021-11-03 | Alpine | California | 6003 | 105 | 0 |
1880611 | 1880611 | 2021-11-03 | Wheeler | Oregon | 41069 | 105 | 1 |
1875287 | 1875287 | 2021-11-02 | Alpine | California | 6003 | 105 | 0 |
1872038 | 1872038 | 2021-11-01 | Alpine | California | 6003 | 105 | 0 |
1868789 | 1868789 | 2021-10-31 | Alpine | California | 6003 | 105 | 0 |
1865540 | 1865540 | 2021-10-30 | Alpine | California | 6003 | 105 | 0 |
1862291 | 1862291 | 2021-10-29 | Alpine | California | 6003 | 105 | 0 |
1859042 | 1859042 | 2021-10-28 | Alpine | California | 6003 | 105 | 0 |
1855793 | 1855793 | 2021-10-27 | Alpine | California | 6003 | 105 | 0 |
1852544 | 1852544 | 2021-10-26 | Alpine | California | 6003 | 105 | 0 |
1849295 | 1849295 | 2021-10-25 | Alpine | California | 6003 | 105 | 0 |
1846045 | 1846045 | 2021-10-24 | Alpine | California | 6003 | 105 | 0 |
1842795 | 1842795 | 2021-10-23 | Alpine | California | 6003 | 105 | 0 |
1839545 | 1839545 | 2021-10-22 | Alpine | California | 6003 | 105 | 0 |
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);