ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
707 rows where cases = 421 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 47
- Virginia 60
- Nebraska 55
- Texas 46
- Georgia 35
- Puerto Rico 32
- Kansas 29
- Kentucky 27
- Montana 26
- Minnesota 24
- Missouri 24
- New Mexico 24
- South Dakota 23
- Mississippi 21
- North Dakota 19
- Illinois 16
- Louisiana 16
- Oklahoma 15
- North Carolina 14
- Tennessee 14
- Pennsylvania 12
- West Virginia 12
- Indiana 11
- Iowa 11
- Ohio 11
- South Carolina 11
- Alabama 10
- Arkansas 10
- Colorado 10
- Michigan 10
- Oregon 10
- Wisconsin 10
- New York 9
- California 7
- Washington 7
- Maryland 6
- Idaho 4
- New Hampshire 4
- Wyoming 4
- Alaska 3
- Delaware 3
- Hawaii 3
- Massachusetts 3
- Florida 2
- Connecticut 1
- Maine 1
- Nevada 1
- Virgin Islands 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491505 | 2491505 | 2022-05-10 | Franklin | Nebraska | 31061 | 421 | 12 |
2491541 | 2491541 | 2022-05-10 | Pawnee | Nebraska | 31133 | 421 | 4 |
2488247 | 2488247 | 2022-05-09 | Franklin | Nebraska | 31061 | 421 | 12 |
2488283 | 2488283 | 2022-05-09 | Pawnee | Nebraska | 31133 | 421 | 4 |
2484990 | 2484990 | 2022-05-08 | Franklin | Nebraska | 31061 | 421 | 12 |
2481732 | 2481732 | 2022-05-07 | Franklin | Nebraska | 31061 | 421 | 12 |
2478474 | 2478474 | 2022-05-06 | Franklin | Nebraska | 31061 | 421 | 12 |
2475216 | 2475216 | 2022-05-05 | Franklin | Nebraska | 31061 | 421 | 12 |
2471959 | 2471959 | 2022-05-04 | Franklin | Nebraska | 31061 | 421 | 12 |
2465483 | 2465483 | 2022-05-02 | Pawnee | Nebraska | 31133 | 421 | 4 |
2462228 | 2462228 | 2022-05-01 | Pawnee | Nebraska | 31133 | 421 | 4 |
2458972 | 2458972 | 2022-04-30 | Pawnee | Nebraska | 31133 | 421 | 4 |
2455716 | 2455716 | 2022-04-29 | Pawnee | Nebraska | 31133 | 421 | 4 |
2452460 | 2452460 | 2022-04-28 | Pawnee | Nebraska | 31133 | 421 | 4 |
2452540 | 2452540 | 2022-04-28 | Catron | New Mexico | 35003 | 421 | 14 |
2449204 | 2449204 | 2022-04-27 | Pawnee | Nebraska | 31133 | 421 | 4 |
2449284 | 2449284 | 2022-04-27 | Catron | New Mexico | 35003 | 421 | 14 |
2445947 | 2445947 | 2022-04-26 | Pawnee | Nebraska | 31133 | 421 | 4 |
2446027 | 2446027 | 2022-04-26 | Catron | New Mexico | 35003 | 421 | 14 |
2442772 | 2442772 | 2022-04-25 | Catron | New Mexico | 35003 | 421 | 14 |
2439516 | 2439516 | 2022-04-24 | Catron | New Mexico | 35003 | 421 | 13 |
2436260 | 2436260 | 2022-04-23 | Catron | New Mexico | 35003 | 421 | 13 |
2433004 | 2433004 | 2022-04-22 | Catron | New Mexico | 35003 | 421 | 13 |
2429748 | 2429748 | 2022-04-21 | Catron | New Mexico | 35003 | 421 | 13 |
2426492 | 2426492 | 2022-04-20 | Catron | New Mexico | 35003 | 421 | 13 |
2423236 | 2423236 | 2022-04-19 | Catron | New Mexico | 35003 | 421 | 13 |
2400329 | 2400329 | 2022-04-12 | Franklin | Nebraska | 31061 | 421 | 10 |
2397074 | 2397074 | 2022-04-11 | Franklin | Nebraska | 31061 | 421 | 10 |
2393819 | 2393819 | 2022-04-10 | Franklin | Nebraska | 31061 | 421 | 10 |
2390563 | 2390563 | 2022-04-09 | Franklin | Nebraska | 31061 | 421 | 10 |
2387307 | 2387307 | 2022-04-08 | Franklin | Nebraska | 31061 | 421 | 10 |
2384052 | 2384052 | 2022-04-07 | Franklin | Nebraska | 31061 | 421 | 10 |
2380797 | 2380797 | 2022-04-06 | Franklin | Nebraska | 31061 | 421 | 10 |
2377542 | 2377542 | 2022-04-05 | Franklin | Nebraska | 31061 | 421 | 10 |
2374289 | 2374289 | 2022-04-04 | Franklin | Nebraska | 31061 | 421 | 10 |
2371037 | 2371037 | 2022-04-03 | Franklin | Nebraska | 31061 | 421 | 10 |
2367784 | 2367784 | 2022-04-02 | Franklin | Nebraska | 31061 | 421 | 10 |
2364531 | 2364531 | 2022-04-01 | Franklin | Nebraska | 31061 | 421 | 10 |
2361277 | 2361277 | 2022-03-31 | Franklin | Nebraska | 31061 | 421 | 10 |
2328745 | 2328745 | 2022-03-21 | Franklin | Nebraska | 31061 | 421 | 10 |
2325493 | 2325493 | 2022-03-20 | Franklin | Nebraska | 31061 | 421 | 10 |
2322239 | 2322239 | 2022-03-19 | Franklin | Nebraska | 31061 | 421 | 10 |
2271188 | 2271188 | 2022-03-03 | Dickens | Texas | 48125 | 421 | 16 |
2267936 | 2267936 | 2022-03-02 | Dickens | Texas | 48125 | 421 | 16 |
2222241 | 2222241 | 2022-02-16 | McPherson | South Dakota | 46089 | 421 | 9 |
2179459 | 2179459 | 2022-02-03 | Burke | North Dakota | 38013 | 421 | 3 |
2180096 | 2180096 | 2022-02-03 | Briscoe | Texas | 48045 | 421 | 8 |
2176208 | 2176208 | 2022-02-02 | Burke | North Dakota | 38013 | 421 | 3 |
2176845 | 2176845 | 2022-02-02 | Briscoe | Texas | 48045 | 421 | 8 |
2172955 | 2172955 | 2022-02-01 | Burke | North Dakota | 38013 | 421 | 3 |
2173591 | 2173591 | 2022-02-01 | Briscoe | Texas | 48045 | 421 | 8 |
2157365 | 2157365 | 2022-01-27 | Edwards | Texas | 48137 | 421 | 10 |
2131133 | 2131133 | 2022-01-19 | Haakon | South Dakota | 46055 | 421 | 11 |
2131432 | 2131432 | 2022-01-19 | Menard | Texas | 48327 | 421 | 12 |
2123479 | 2123479 | 2022-01-17 | Cook | Minnesota | 27031 | 421 | 1 |
2120227 | 2120227 | 2022-01-16 | Cook | Minnesota | 27031 | 421 | 1 |
2120563 | 2120563 | 2022-01-16 | Brown | Nebraska | 31017 | 421 | 4 |
2116975 | 2116975 | 2022-01-15 | Cook | Minnesota | 27031 | 421 | 1 |
2117311 | 2117311 | 2022-01-15 | Brown | Nebraska | 31017 | 421 | 4 |
2113724 | 2113724 | 2022-01-14 | Cook | Minnesota | 27031 | 421 | 1 |
2114060 | 2114060 | 2022-01-14 | Brown | Nebraska | 31017 | 421 | 4 |
2114406 | 2114406 | 2022-01-14 | Grant | North Dakota | 38037 | 421 | 11 |
2111154 | 2111154 | 2022-01-13 | Grant | North Dakota | 38037 | 421 | 11 |
2086946 | 2086946 | 2022-01-06 | Custer | Idaho | 16037 | 421 | 7 |
2078352 | 2078352 | 2022-01-03 | Perkins | Nebraska | 31135 | 421 | 12 |
2075101 | 2075101 | 2022-01-02 | Perkins | Nebraska | 31135 | 421 | 12 |
2071850 | 2071850 | 2022-01-01 | Perkins | Nebraska | 31135 | 421 | 12 |
2068599 | 2068599 | 2021-12-31 | Perkins | Nebraska | 31135 | 421 | 12 |
2065348 | 2065348 | 2021-12-30 | Perkins | Nebraska | 31135 | 421 | 12 |
2038065 | 2038065 | 2021-12-22 | Glascock | Georgia | 13125 | 421 | 21 |
2034815 | 2034815 | 2021-12-21 | Glascock | Georgia | 13125 | 421 | 21 |
2031565 | 2031565 | 2021-12-20 | Glascock | Georgia | 13125 | 421 | 21 |
1988094 | 1988094 | 2021-12-06 | Hand | South Dakota | 46059 | 421 | 7 |
1983257 | 1983257 | 2021-12-05 | Chase | Kansas | 20017 | 421 | 4 |
1984844 | 1984844 | 2021-12-05 | Hand | South Dakota | 46059 | 421 | 7 |
1980007 | 1980007 | 2021-12-04 | Chase | Kansas | 20017 | 421 | 4 |
1981594 | 1981594 | 2021-12-04 | Hand | South Dakota | 46059 | 421 | 7 |
1976757 | 1976757 | 2021-12-03 | Chase | Kansas | 20017 | 421 | 4 |
1978344 | 1978344 | 2021-12-03 | Hand | South Dakota | 46059 | 421 | 7 |
1969674 | 1969674 | 2021-12-01 | Unknown | Delaware | 421 | 0 | |
1961286 | 1961286 | 2021-11-28 | Cherry | Nebraska | 31031 | 421 | 8 |
1958035 | 1958035 | 2021-11-27 | Cherry | Nebraska | 31031 | 421 | 8 |
1954784 | 1954784 | 2021-11-26 | Cherry | Nebraska | 31031 | 421 | 8 |
1951533 | 1951533 | 2021-11-25 | Cherry | Nebraska | 31031 | 421 | 8 |
1948282 | 1948282 | 2021-11-24 | Cherry | Nebraska | 31031 | 421 | 8 |
1937166 | 1937166 | 2021-11-21 | Unknown | Delaware | 421 | 0 | |
1925435 | 1925435 | 2021-11-17 | Schuyler | Missouri | 29197 | 421 | 9 |
1925849 | 1925849 | 2021-11-17 | Adams | North Dakota | 38001 | 421 | 5 |
1862424 | 1862424 | 2021-10-29 | Unknown | Delaware | 421 | 0 | |
1861382 | 1861382 | 2021-10-28 | Ziebach | South Dakota | 46137 | 421 | 10 |
1858133 | 1858133 | 2021-10-27 | Ziebach | South Dakota | 46137 | 421 | 10 |
1854884 | 1854884 | 2021-10-26 | Ziebach | South Dakota | 46137 | 421 | 9 |
1851635 | 1851635 | 2021-10-25 | Ziebach | South Dakota | 46137 | 421 | 9 |
1812622 | 1812622 | 2021-10-13 | Marshall | South Dakota | 46091 | 421 | 6 |
1809373 | 1809373 | 2021-10-12 | Marshall | South Dakota | 46091 | 421 | 6 |
1801276 | 1801276 | 2021-10-10 | Cheyenne | Kansas | 20023 | 421 | 13 |
1798027 | 1798027 | 2021-10-09 | Cheyenne | Kansas | 20023 | 421 | 13 |
1794778 | 1794778 | 2021-10-08 | Cheyenne | Kansas | 20023 | 421 | 13 |
1787060 | 1787060 | 2021-10-05 | Bath | Virginia | 51017 | 421 | 14 |
1773402 | 1773402 | 2021-10-01 | Cameron | Pennsylvania | 42023 | 421 | 10 |
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);