ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
472 rows where cases = 796 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 48
- Texas 37
- Georgia 25
- Montana 25
- South Dakota 24
- Illinois 23
- Nebraska 21
- Puerto Rico 18
- Kentucky 16
- Arkansas 15
- Iowa 15
- Minnesota 15
- Michigan 14
- Mississippi 14
- Wisconsin 14
- Tennessee 12
- Virginia 12
- Missouri 10
- West Virginia 9
- Oklahoma 8
- South Carolina 8
- Florida 7
- Indiana 6
- North Carolina 6
- Pennsylvania 6
- Wyoming 6
- Alabama 5
- Colorado 5
- Idaho 5
- Louisiana 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500577 | 2500577 | 2022-05-13 | Woodson | Kansas | 20207 | 796 | 15 |
2502087 | 2502087 | 2022-05-13 | Marshall | South Dakota | 46091 | 796 | 13 |
2497319 | 2497319 | 2022-05-12 | Woodson | Kansas | 20207 | 796 | 15 |
2498829 | 2498829 | 2022-05-12 | Marshall | South Dakota | 46091 | 796 | 13 |
2494061 | 2494061 | 2022-05-11 | Woodson | Kansas | 20207 | 796 | 15 |
2495571 | 2495571 | 2022-05-11 | Marshall | South Dakota | 46091 | 796 | 13 |
2490803 | 2490803 | 2022-05-10 | Woodson | Kansas | 20207 | 796 | 15 |
2487546 | 2487546 | 2022-05-09 | Woodson | Kansas | 20207 | 796 | 15 |
2484288 | 2484288 | 2022-05-08 | Woodson | Kansas | 20207 | 796 | 15 |
2481030 | 2481030 | 2022-05-07 | Woodson | Kansas | 20207 | 796 | 15 |
2477772 | 2477772 | 2022-05-06 | Woodson | Kansas | 20207 | 796 | 15 |
2474514 | 2474514 | 2022-05-05 | Woodson | Kansas | 20207 | 796 | 15 |
2471257 | 2471257 | 2022-05-04 | Woodson | Kansas | 20207 | 796 | 15 |
2468001 | 2468001 | 2022-05-03 | Woodson | Kansas | 20207 | 796 | 15 |
2464746 | 2464746 | 2022-05-02 | Woodson | Kansas | 20207 | 796 | 15 |
2461490 | 2461490 | 2022-05-01 | Woodson | Kansas | 20207 | 796 | 15 |
2458234 | 2458234 | 2022-04-30 | Woodson | Kansas | 20207 | 796 | 15 |
2454978 | 2454978 | 2022-04-29 | Woodson | Kansas | 20207 | 796 | 15 |
2451722 | 2451722 | 2022-04-28 | Woodson | Kansas | 20207 | 796 | 15 |
2448466 | 2448466 | 2022-04-27 | Woodson | Kansas | 20207 | 796 | 15 |
2445210 | 2445210 | 2022-04-26 | Woodson | Kansas | 20207 | 796 | 15 |
2441954 | 2441954 | 2022-04-25 | Woodson | Kansas | 20207 | 796 | 15 |
2438698 | 2438698 | 2022-04-24 | Woodson | Kansas | 20207 | 796 | 15 |
2435442 | 2435442 | 2022-04-23 | Woodson | Kansas | 20207 | 796 | 15 |
2432186 | 2432186 | 2022-04-22 | Woodson | Kansas | 20207 | 796 | 15 |
2292999 | 2292999 | 2022-03-10 | Nance | Nebraska | 31125 | 796 | 10 |
2289747 | 2289747 | 2022-03-09 | Nance | Nebraska | 31125 | 796 | 10 |
2279990 | 2279990 | 2022-03-06 | Nance | Nebraska | 31125 | 796 | 10 |
2276737 | 2276737 | 2022-03-05 | Nance | Nebraska | 31125 | 796 | 10 |
2273484 | 2273484 | 2022-03-04 | Nance | Nebraska | 31125 | 796 | 10 |
2216730 | 2216730 | 2022-02-15 | Baca | Colorado | 8009 | 796 | 8 |
2218496 | 2218496 | 2022-02-15 | Cavalier | North Dakota | 38019 | 796 | 7 |
2219119 | 2219119 | 2022-02-15 | Baylor | Texas | 48023 | 796 | 31 |
2215868 | 2215868 | 2022-02-14 | Baylor | Texas | 48023 | 796 | 31 |
2212617 | 2212617 | 2022-02-13 | Baylor | Texas | 48023 | 796 | 31 |
2198019 | 2198019 | 2022-02-09 | Hickman | Kentucky | 21105 | 796 | 22 |
2194690 | 2194690 | 2022-02-08 | Rush | Kansas | 20165 | 796 | 17 |
2191436 | 2191436 | 2022-02-07 | Rush | Kansas | 20165 | 796 | 17 |
2182725 | 2182725 | 2022-02-04 | Hettinger | North Dakota | 38041 | 796 | 7 |
2179473 | 2179473 | 2022-02-03 | Hettinger | North Dakota | 38041 | 796 | 7 |
2163999 | 2163999 | 2022-01-29 | Reagan | Texas | 48383 | 796 | 12 |
2160592 | 2160592 | 2022-01-28 | Cochran | Texas | 48079 | 796 | 21 |
2146689 | 2146689 | 2022-01-24 | Mineral | Nevada | 32021 | 796 | 14 |
2133285 | 2133285 | 2022-01-20 | Red Lake | Minnesota | 27125 | 796 | 11 |
2126325 | 2126325 | 2022-01-18 | Haskell | Kansas | 20081 | 796 | 9 |
2123073 | 2123073 | 2022-01-17 | Haskell | Kansas | 20081 | 796 | 9 |
2123783 | 2123783 | 2022-01-17 | Musselshell | Montana | 30065 | 796 | 26 |
2119821 | 2119821 | 2022-01-16 | Haskell | Kansas | 20081 | 796 | 9 |
2120531 | 2120531 | 2022-01-16 | Musselshell | Montana | 30065 | 796 | 26 |
2116569 | 2116569 | 2022-01-15 | Haskell | Kansas | 20081 | 796 | 9 |
2117279 | 2117279 | 2022-01-15 | Musselshell | Montana | 30065 | 796 | 26 |
2113318 | 2113318 | 2022-01-14 | Haskell | Kansas | 20081 | 796 | 9 |
2114028 | 2114028 | 2022-01-14 | Musselshell | Montana | 30065 | 796 | 26 |
2110776 | 2110776 | 2022-01-13 | Musselshell | Montana | 30065 | 796 | 26 |
2097434 | 2097434 | 2022-01-09 | Ontonagon | Michigan | 26131 | 796 | 28 |
2099082 | 2099082 | 2022-01-09 | Craig | Virginia | 51045 | 796 | 11 |
2094182 | 2094182 | 2022-01-08 | Ontonagon | Michigan | 26131 | 796 | 28 |
2095831 | 2095831 | 2022-01-08 | Craig | Virginia | 51045 | 796 | 11 |
2090930 | 2090930 | 2022-01-07 | Ontonagon | Michigan | 26131 | 796 | 28 |
2092579 | 2092579 | 2022-01-07 | Craig | Virginia | 51045 | 796 | 11 |
2086959 | 2086959 | 2022-01-06 | Lincoln | Idaho | 16063 | 796 | 14 |
2087006 | 2087006 | 2022-01-06 | Hardin | Illinois | 17069 | 796 | 17 |
2079287 | 2079287 | 2022-01-03 | Concho | Texas | 48095 | 796 | 10 |
2079788 | 2079788 | 2022-01-03 | Florence | Wisconsin | 55037 | 796 | 15 |
2076536 | 2076536 | 2022-01-02 | Florence | Wisconsin | 55037 | 796 | 15 |
2073285 | 2073285 | 2022-01-01 | Florence | Wisconsin | 55037 | 796 | 15 |
2070034 | 2070034 | 2021-12-31 | Florence | Wisconsin | 55037 | 796 | 15 |
2065932 | 2065932 | 2021-12-30 | Sullivan | Pennsylvania | 42113 | 796 | 28 |
2066783 | 2066783 | 2021-12-30 | Florence | Wisconsin | 55037 | 796 | 15 |
2039313 | 2039313 | 2021-12-22 | Fillmore | Nebraska | 31059 | 796 | 13 |
2037041 | 2037041 | 2021-12-21 | Crockett | Texas | 48105 | 796 | 17 |
2033791 | 2033791 | 2021-12-20 | Crockett | Texas | 48105 | 796 | 17 |
2030541 | 2030541 | 2021-12-19 | Crockett | Texas | 48105 | 796 | 17 |
2027290 | 2027290 | 2021-12-18 | Crockett | Texas | 48105 | 796 | 17 |
2024039 | 2024039 | 2021-12-17 | Crockett | Texas | 48105 | 796 | 17 |
2019864 | 2019864 | 2021-12-16 | Thayer | Nebraska | 31169 | 796 | 8 |
2020788 | 2020788 | 2021-12-16 | Crockett | Texas | 48105 | 796 | 17 |
2016614 | 2016614 | 2021-12-15 | Thayer | Nebraska | 31169 | 796 | 8 |
2017537 | 2017537 | 2021-12-15 | Crockett | Texas | 48105 | 796 | 17 |
1949941 | 1949941 | 2021-11-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 796 | 7 |
1946690 | 1946690 | 2021-11-24 | Yukon-Koyukuk Census Area | Alaska | 2290 | 796 | 7 |
1945363 | 1945363 | 2021-11-23 | Dunn | North Dakota | 38025 | 796 | 7 |
1941770 | 1941770 | 2021-11-22 | Boone | Nebraska | 31011 | 796 | 4 |
1924882 | 1924882 | 2021-11-17 | Fulton | Kentucky | 21075 | 796 | 17 |
1926232 | 1926232 | 2021-11-17 | Penuelas | Puerto Rico | 72111 | 796 | |
1922982 | 1922982 | 2021-11-16 | Penuelas | Puerto Rico | 72111 | 796 | |
1918995 | 1918995 | 2021-11-15 | Pondera | Montana | 30073 | 796 | 6 |
1919733 | 1919733 | 2021-11-15 | Penuelas | Puerto Rico | 72111 | 796 | |
1915845 | 1915845 | 2021-11-14 | Sheridan | Nebraska | 31161 | 796 | 23 |
1916483 | 1916483 | 2021-11-14 | Penuelas | Puerto Rico | 72111 | 796 | |
1912595 | 1912595 | 2021-11-13 | Sheridan | Nebraska | 31161 | 796 | 23 |
1913233 | 1913233 | 2021-11-13 | Penuelas | Puerto Rico | 72111 | 796 | |
1909345 | 1909345 | 2021-11-12 | Sheridan | Nebraska | 31161 | 796 | 23 |
1905306 | 1905306 | 2021-11-11 | Morris | Kansas | 20127 | 796 | 23 |
1902056 | 1902056 | 2021-11-10 | Morris | Kansas | 20127 | 796 | 23 |
1897562 | 1897562 | 2021-11-08 | Fairfax city | Virginia | 51600 | 796 | 30 |
1860222 | 1860222 | 2021-10-28 | Lincoln | Minnesota | 27081 | 796 | 5 |
1860684 | 1860684 | 2021-10-28 | Los Alamos | New Mexico | 35028 | 796 | 9 |
1856236 | 1856236 | 2021-10-27 | Gallatin | Illinois | 17059 | 796 | 10 |
1847175 | 1847175 | 2021-10-24 | Schoolcraft | Michigan | 26153 | 796 | 5 |
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);