ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
469 rows where cases = 1120 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 46
- North Carolina 34
- Virginia 32
- Tennessee 27
- Georgia 23
- Kansas 23
- Minnesota 20
- Illinois 17
- Kentucky 17
- Texas 17
- Montana 16
- Arkansas 15
- Puerto Rico 15
- Colorado 14
- Oklahoma 14
- Louisiana 13
- Indiana 10
- West Virginia 10
- Missouri 9
- Wisconsin 9
- Michigan 8
- Mississippi 8
- Ohio 6
- Utah 6
- Idaho 5
- Iowa 5
- Oregon 5
- Florida 4
- Guam 4
- North Dakota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442658 | 2442658 | 2022-04-25 | Furnas | Nebraska | 31065 | 1120 | 8 |
2439402 | 2439402 | 2022-04-24 | Furnas | Nebraska | 31065 | 1120 | 8 |
2440659 | 2440659 | 2022-04-24 | Craig | Virginia | 51045 | 1120 | 18 |
2436146 | 2436146 | 2022-04-23 | Furnas | Nebraska | 31065 | 1120 | 8 |
2437403 | 2437403 | 2022-04-23 | Craig | Virginia | 51045 | 1120 | 18 |
2432890 | 2432890 | 2022-04-22 | Furnas | Nebraska | 31065 | 1120 | 8 |
2434147 | 2434147 | 2022-04-22 | Craig | Virginia | 51045 | 1120 | 18 |
2429634 | 2429634 | 2022-04-21 | Furnas | Nebraska | 31065 | 1120 | 8 |
2430891 | 2430891 | 2022-04-21 | Craig | Virginia | 51045 | 1120 | 18 |
2426378 | 2426378 | 2022-04-20 | Furnas | Nebraska | 31065 | 1120 | 8 |
2423122 | 2423122 | 2022-04-19 | Furnas | Nebraska | 31065 | 1120 | 8 |
2419865 | 2419865 | 2022-04-18 | Furnas | Nebraska | 31065 | 1120 | 8 |
2421160 | 2421160 | 2022-04-18 | King and Queen | Virginia | 51097 | 1120 | 12 |
2416610 | 2416610 | 2022-04-17 | Furnas | Nebraska | 31065 | 1120 | 8 |
2417904 | 2417904 | 2022-04-17 | King and Queen | Virginia | 51097 | 1120 | 12 |
2413354 | 2413354 | 2022-04-16 | Furnas | Nebraska | 31065 | 1120 | 8 |
2414648 | 2414648 | 2022-04-16 | King and Queen | Virginia | 51097 | 1120 | 12 |
2410098 | 2410098 | 2022-04-15 | Furnas | Nebraska | 31065 | 1120 | 8 |
2411392 | 2411392 | 2022-04-15 | King and Queen | Virginia | 51097 | 1120 | 12 |
2406842 | 2406842 | 2022-04-14 | Furnas | Nebraska | 31065 | 1120 | 8 |
2408136 | 2408136 | 2022-04-14 | King and Queen | Virginia | 51097 | 1120 | 12 |
2403586 | 2403586 | 2022-04-13 | Furnas | Nebraska | 31065 | 1120 | 8 |
2335254 | 2335254 | 2022-03-23 | Furnas | Nebraska | 31065 | 1120 | 6 |
2332000 | 2332000 | 2022-03-22 | Furnas | Nebraska | 31065 | 1120 | 6 |
2328747 | 2328747 | 2022-03-21 | Furnas | Nebraska | 31065 | 1120 | 6 |
2325495 | 2325495 | 2022-03-20 | Furnas | Nebraska | 31065 | 1120 | 6 |
2322241 | 2322241 | 2022-03-19 | Furnas | Nebraska | 31065 | 1120 | 6 |
2318987 | 2318987 | 2022-03-18 | Furnas | Nebraska | 31065 | 1120 | 6 |
2315734 | 2315734 | 2022-03-17 | Furnas | Nebraska | 31065 | 1120 | 6 |
2312481 | 2312481 | 2022-03-16 | Furnas | Nebraska | 31065 | 1120 | 6 |
2265925 | 2265925 | 2022-03-02 | Putnam | Illinois | 17155 | 1120 | 10 |
2262674 | 2262674 | 2022-03-01 | Putnam | Illinois | 17155 | 1120 | 10 |
2259423 | 2259423 | 2022-02-28 | Putnam | Illinois | 17155 | 1120 | 10 |
2258457 | 2258457 | 2022-02-27 | Emporia city | Virginia | 51595 | 1120 | 52 |
2255206 | 2255206 | 2022-02-26 | Emporia city | Virginia | 51595 | 1120 | 52 |
2251955 | 2251955 | 2022-02-25 | Emporia city | Virginia | 51595 | 1120 | 52 |
2247436 | 2247436 | 2022-02-24 | Dixon | Nebraska | 31051 | 1120 | 11 |
2248704 | 2248704 | 2022-02-24 | Emporia city | Virginia | 51595 | 1120 | 52 |
2244185 | 2244185 | 2022-02-23 | Dixon | Nebraska | 31051 | 1120 | 11 |
2240934 | 2240934 | 2022-02-22 | Dixon | Nebraska | 31051 | 1120 | 11 |
2233036 | 2233036 | 2022-02-20 | Saguache | Colorado | 8109 | 1120 | 12 |
2229785 | 2229785 | 2022-02-19 | Saguache | Colorado | 8109 | 1120 | 12 |
2226534 | 2226534 | 2022-02-18 | Saguache | Colorado | 8109 | 1120 | 12 |
2199917 | 2199917 | 2022-02-09 | Charles City | Virginia | 51036 | 1120 | 24 |
2196663 | 2196663 | 2022-02-08 | Charles City | Virginia | 51036 | 1120 | 24 |
2190977 | 2190977 | 2022-02-07 | Talbot | Georgia | 13263 | 1120 | 31 |
2193326 | 2193326 | 2022-02-07 | Wheeler | Texas | 48483 | 1120 | 18 |
2188921 | 2188921 | 2022-02-06 | Howard | Nebraska | 31093 | 1120 | 15 |
2189918 | 2189918 | 2022-02-06 | Goliad | Texas | 48175 | 1120 | 29 |
2185668 | 2185668 | 2022-02-05 | Howard | Nebraska | 31093 | 1120 | 15 |
2182416 | 2182416 | 2022-02-04 | Howard | Nebraska | 31093 | 1120 | 15 |
2173122 | 2173122 | 2022-02-01 | Greer | Oklahoma | 40055 | 1120 | 29 |
2169870 | 2169870 | 2022-01-31 | Greer | Oklahoma | 40055 | 1120 | 29 |
2166615 | 2166615 | 2022-01-30 | Greer | Oklahoma | 40055 | 1120 | 29 |
2163360 | 2163360 | 2022-01-29 | Greer | Oklahoma | 40055 | 1120 | 29 |
2160105 | 2160105 | 2022-01-28 | Greer | Oklahoma | 40055 | 1120 | 29 |
2156850 | 2156850 | 2022-01-27 | Greer | Oklahoma | 40055 | 1120 | 29 |
2152422 | 2152422 | 2022-01-26 | Ballard | Kentucky | 21007 | 1120 | 26 |
2153597 | 2153597 | 2022-01-26 | Greer | Oklahoma | 40055 | 1120 | 29 |
2134680 | 2134680 | 2022-01-20 | McCulloch | Texas | 48307 | 1120 | 41 |
2104008 | 2104008 | 2022-01-11 | Norman | Minnesota | 27107 | 1120 | 10 |
2074716 | 2074716 | 2022-01-02 | Grant | Minnesota | 27051 | 1120 | 12 |
2071465 | 2071465 | 2022-01-01 | Grant | Minnesota | 27051 | 1120 | 12 |
2068214 | 2068214 | 2021-12-31 | Grant | Minnesota | 27051 | 1120 | 12 |
2064963 | 2064963 | 2021-12-30 | Grant | Minnesota | 27051 | 1120 | 12 |
2051145 | 2051145 | 2021-12-26 | Twiggs | Georgia | 13289 | 1120 | 62 |
2047895 | 2047895 | 2021-12-25 | Twiggs | Georgia | 13289 | 1120 | 62 |
2044645 | 2044645 | 2021-12-24 | Twiggs | Georgia | 13289 | 1120 | 62 |
2023713 | 2023713 | 2021-12-17 | Ciales | Puerto Rico | 72039 | 1120 | |
2021105 | 2021105 | 2021-12-16 | Lancaster | Virginia | 51103 | 1120 | 24 |
2005784 | 2005784 | 2021-12-12 | Pulaski | Illinois | 17153 | 1120 | 13 |
2006827 | 2006827 | 2021-12-12 | Keith | Nebraska | 31101 | 1120 | 11 |
2008073 | 2008073 | 2021-12-12 | Fairfax city | Virginia | 51600 | 1120 | 35 |
2002533 | 2002533 | 2021-12-11 | Pulaski | Illinois | 17153 | 1120 | 13 |
2003576 | 2003576 | 2021-12-11 | Keith | Nebraska | 31101 | 1120 | 11 |
2004822 | 2004822 | 2021-12-11 | Fairfax city | Virginia | 51600 | 1120 | 35 |
1999283 | 1999283 | 2021-12-10 | Pulaski | Illinois | 17153 | 1120 | 13 |
2000326 | 2000326 | 2021-12-10 | Keith | Nebraska | 31101 | 1120 | 11 |
2001571 | 2001571 | 2021-12-10 | Fairfax city | Virginia | 51600 | 1120 | 35 |
1994595 | 1994595 | 2021-12-08 | Hamlin | South Dakota | 46057 | 1120 | 40 |
1973209 | 1973209 | 2021-12-02 | Brown | Illinois | 17009 | 1120 | 18 |
1963128 | 1963128 | 2021-11-29 | Kit Carson | Colorado | 8063 | 1120 | 21 |
1964379 | 1964379 | 2021-11-29 | Daviess | Missouri | 29061 | 1120 | 17 |
1964608 | 1964608 | 2021-11-29 | Thurston | Nebraska | 31173 | 1120 | 16 |
1961293 | 1961293 | 2021-11-28 | Dawes | Nebraska | 31045 | 1120 | 21 |
1958042 | 1958042 | 2021-11-27 | Dawes | Nebraska | 31045 | 1120 | 21 |
1954791 | 1954791 | 2021-11-26 | Dawes | Nebraska | 31045 | 1120 | 21 |
1951540 | 1951540 | 2021-11-25 | Dawes | Nebraska | 31045 | 1120 | 21 |
1948289 | 1948289 | 2021-11-24 | Dawes | Nebraska | 31045 | 1120 | 21 |
1949536 | 1949536 | 2021-11-24 | Bland | Virginia | 51021 | 1120 | 17 |
1943601 | 1943601 | 2021-11-23 | Conejos | Colorado | 8021 | 1120 | 42 |
1938130 | 1938130 | 2021-11-21 | Lake | Michigan | 26085 | 1120 | 24 |
1934880 | 1934880 | 2021-11-20 | Lake | Michigan | 26085 | 1120 | 24 |
1931630 | 1931630 | 2021-11-19 | Lake | Michigan | 26085 | 1120 | 24 |
1900981 | 1900981 | 2021-11-09 | Pendleton | West Virginia | 54071 | 1120 | 15 |
1896327 | 1896327 | 2021-11-08 | Merrick | Nebraska | 31121 | 1120 | 15 |
1897731 | 1897731 | 2021-11-08 | Pendleton | West Virginia | 54071 | 1120 | 15 |
1892131 | 1892131 | 2021-11-07 | Union | Indiana | 18161 | 1120 | 17 |
1893028 | 1893028 | 2021-11-07 | Butler | Nebraska | 31023 | 1120 | 12 |
1888881 | 1888881 | 2021-11-06 | Union | Indiana | 18161 | 1120 | 17 |
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);