ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
440 rows where cases = 1072 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 35
- Iowa 31
- Georgia 30
- Texas 30
- Kentucky 25
- Tennessee 23
- Missouri 21
- Puerto Rico 19
- Mississippi 16
- North Carolina 14
- Michigan 13
- Virginia 13
- Indiana 12
- Alabama 11
- Kansas 10
- Montana 9
- Nebraska 9
- Illinois 8
- Louisiana 8
- South Dakota 8
- Oregon 7
- Arkansas 6
- Florida 6
- Idaho 6
- Pennsylvania 6
- South Carolina 6
- West Virginia 6
- Alaska 5
- California 5
- Colorado 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484309 | 2484309 | 2022-05-08 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2481051 | 2481051 | 2022-05-07 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2477793 | 2477793 | 2022-05-06 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2474535 | 2474535 | 2022-05-05 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2471278 | 2471278 | 2022-05-04 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2468022 | 2468022 | 2022-05-03 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2464767 | 2464767 | 2022-05-02 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2466071 | 2466071 | 2022-05-02 | Sullivan | Pennsylvania | 42113 | 1072 | 36 |
2462816 | 2462816 | 2022-05-01 | Sullivan | Pennsylvania | 42113 | 1072 | 36 |
2459560 | 2459560 | 2022-04-30 | Sullivan | Pennsylvania | 42113 | 1072 | 36 |
2312450 | 2312450 | 2022-03-16 | Antelope | Nebraska | 31003 | 1072 | 13 |
2313155 | 2313155 | 2022-03-16 | Las Marias | Puerto Rico | 72083 | 1072 | |
2292938 | 2292938 | 2022-03-10 | Antelope | Nebraska | 31003 | 1072 | 13 |
2287639 | 2287639 | 2022-03-08 | Yoakum | Texas | 48501 | 1072 | 41 |
2284387 | 2284387 | 2022-03-07 | Yoakum | Texas | 48501 | 1072 | 41 |
2281135 | 2281135 | 2022-03-06 | Yoakum | Texas | 48501 | 1072 | 41 |
2263822 | 2263822 | 2022-03-01 | Hidalgo | New Mexico | 35023 | 1072 | 13 |
2248789 | 2248789 | 2022-02-24 | Surry | Virginia | 51181 | 1072 | 17 |
2245538 | 2245538 | 2022-02-23 | Surry | Virginia | 51181 | 1072 | 17 |
2245663 | 2245663 | 2022-02-23 | Florence | Wisconsin | 55037 | 1072 | 15 |
2194587 | 2194587 | 2022-02-08 | Ringgold | Iowa | 19159 | 1072 | 33 |
2191333 | 2191333 | 2022-02-07 | Ringgold | Iowa | 19159 | 1072 | 33 |
2188080 | 2188080 | 2022-02-06 | Ringgold | Iowa | 19159 | 1072 | 33 |
2188904 | 2188904 | 2022-02-06 | Fillmore | Nebraska | 31059 | 1072 | 13 |
2184827 | 2184827 | 2022-02-05 | Ringgold | Iowa | 19159 | 1072 | 33 |
2185651 | 2185651 | 2022-02-05 | Fillmore | Nebraska | 31059 | 1072 | 13 |
2181575 | 2181575 | 2022-02-04 | Ringgold | Iowa | 19159 | 1072 | 33 |
2182399 | 2182399 | 2022-02-04 | Fillmore | Nebraska | 31059 | 1072 | 13 |
2178324 | 2178324 | 2022-02-03 | Ringgold | Iowa | 19159 | 1072 | 33 |
2175071 | 2175071 | 2022-02-02 | Ringgold | Iowa | 19159 | 1072 | 33 |
2173938 | 2173938 | 2022-02-01 | King and Queen | Virginia | 51097 | 1072 | 10 |
2170404 | 2170404 | 2022-01-31 | Goliad | Texas | 48175 | 1072 | 28 |
2155183 | 2155183 | 2022-01-27 | Schley | Georgia | 13249 | 1072 | 8 |
2154199 | 2154199 | 2022-01-26 | Martin | Texas | 48317 | 1072 | 24 |
2106117 | 2106117 | 2022-01-12 | Trinity | California | 6105 | 1072 | 19 |
2104153 | 2104153 | 2022-01-11 | Dade | Missouri | 29057 | 1072 | 38 |
2101903 | 2101903 | 2022-01-10 | Walworth | South Dakota | 46129 | 1072 | 20 |
2087059 | 2087059 | 2022-01-06 | Stark | Illinois | 17175 | 1072 | 30 |
2080749 | 2080749 | 2022-01-04 | Taylor | Iowa | 19173 | 1072 | 20 |
2082834 | 2082834 | 2022-01-04 | Falls Church city | Virginia | 51610 | 1072 | 14 |
2077497 | 2077497 | 2022-01-03 | Taylor | Iowa | 19173 | 1072 | 20 |
2074246 | 2074246 | 2022-01-02 | Taylor | Iowa | 19173 | 1072 | 20 |
2070995 | 2070995 | 2022-01-01 | Taylor | Iowa | 19173 | 1072 | 20 |
2067744 | 2067744 | 2021-12-31 | Taylor | Iowa | 19173 | 1072 | 20 |
2064493 | 2064493 | 2021-12-30 | Taylor | Iowa | 19173 | 1072 | 20 |
2061243 | 2061243 | 2021-12-29 | Taylor | Iowa | 19173 | 1072 | 20 |
2042904 | 2042904 | 2021-12-23 | Ransom | North Dakota | 38073 | 1072 | 23 |
2016240 | 2016240 | 2021-12-15 | Norman | Minnesota | 27107 | 1072 | 10 |
2016353 | 2016353 | 2021-12-15 | Wilkinson | Mississippi | 28157 | 1072 | 39 |
2013102 | 2013102 | 2021-12-14 | Wilkinson | Mississippi | 28157 | 1072 | 39 |
2008929 | 2008929 | 2021-12-13 | Caribou | Idaho | 16029 | 1072 | 23 |
2009851 | 2009851 | 2021-12-13 | Wilkinson | Mississippi | 28157 | 1072 | 39 |
2005678 | 2005678 | 2021-12-12 | Caribou | Idaho | 16029 | 1072 | 23 |
2002427 | 2002427 | 2021-12-11 | Caribou | Idaho | 16029 | 1072 | 23 |
1999177 | 1999177 | 2021-12-10 | Caribou | Idaho | 16029 | 1072 | 23 |
1995926 | 1995926 | 2021-12-09 | Caribou | Idaho | 16029 | 1072 | 23 |
1993787 | 1993787 | 2021-12-08 | Cedar | Nebraska | 31027 | 1072 | 11 |
1989785 | 1989785 | 2021-12-07 | Greenwood | Kansas | 20073 | 1072 | 18 |
1991190 | 1991190 | 2021-12-07 | Aibonito | Puerto Rico | 72009 | 1072 | |
1986535 | 1986535 | 2021-12-06 | Greenwood | Kansas | 20073 | 1072 | 18 |
1988281 | 1988281 | 2021-12-06 | Crosby | Texas | 48107 | 1072 | 39 |
1928613 | 1928613 | 2021-11-18 | Clark | Missouri | 29045 | 1072 | 27 |
1925318 | 1925318 | 2021-11-17 | Quitman | Mississippi | 28119 | 1072 | 28 |
1925371 | 1925371 | 2021-11-17 | Daviess | Missouri | 29061 | 1072 | 14 |
1926198 | 1926198 | 2021-11-17 | Comerio | Puerto Rico | 72045 | 1072 | |
1921880 | 1921880 | 2021-11-16 | Lake | Michigan | 26085 | 1072 | 24 |
1922069 | 1922069 | 2021-11-16 | Quitman | Mississippi | 28119 | 1072 | 28 |
1922834 | 1922834 | 2021-11-16 | Grant | Oregon | 41023 | 1072 | 14 |
1922948 | 1922948 | 2021-11-16 | Comerio | Puerto Rico | 72045 | 1072 | |
1918630 | 1918630 | 2021-11-15 | Lake | Michigan | 26085 | 1072 | 24 |
1919585 | 1919585 | 2021-11-15 | Grant | Oregon | 41023 | 1072 | 14 |
1919699 | 1919699 | 2021-11-15 | Comerio | Puerto Rico | 72045 | 1072 | |
1916335 | 1916335 | 2021-11-14 | Grant | Oregon | 41023 | 1072 | 14 |
1916449 | 1916449 | 2021-11-14 | Comerio | Puerto Rico | 72045 | 1072 | |
1913085 | 1913085 | 2021-11-13 | Grant | Oregon | 41023 | 1072 | 14 |
1913199 | 1913199 | 2021-11-13 | Comerio | Puerto Rico | 72045 | 1072 | |
1909835 | 1909835 | 2021-11-12 | Grant | Oregon | 41023 | 1072 | 14 |
1909949 | 1909949 | 2021-11-12 | Comerio | Puerto Rico | 72045 | 1072 | |
1905024 | 1905024 | 2021-11-11 | Pulaski | Illinois | 17153 | 1072 | 12 |
1906700 | 1906700 | 2021-11-11 | Comerio | Puerto Rico | 72045 | 1072 | |
1901774 | 1901774 | 2021-11-10 | Pulaski | Illinois | 17153 | 1072 | 12 |
1903451 | 1903451 | 2021-11-10 | Comerio | Puerto Rico | 72045 | 1072 | |
1897591 | 1897591 | 2021-11-08 | Lancaster | Virginia | 51103 | 1072 | 23 |
1882193 | 1882193 | 2021-11-04 | Power | Idaho | 16077 | 1072 | 15 |
1860536 | 1860536 | 2021-10-28 | Butler | Nebraska | 31023 | 1072 | 12 |
1857287 | 1857287 | 2021-10-27 | Butler | Nebraska | 31023 | 1072 | 12 |
1842023 | 1842023 | 2021-10-22 | Coleman | Texas | 48083 | 1072 | 53 |
1838459 | 1838459 | 2021-10-21 | Ciales | Puerto Rico | 72039 | 1072 | |
1830295 | 1830295 | 2021-10-19 | Schuyler | Illinois | 17169 | 1072 | 22 |
1816514 | 1816514 | 2021-10-14 | Webster | West Virginia | 54101 | 1072 | 16 |
1800255 | 1800255 | 2021-10-09 | Pocahontas | West Virginia | 54075 | 1072 | 17 |
1784213 | 1784213 | 2021-10-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1072 | 9 |
1784957 | 1784957 | 2021-10-05 | Greene | Iowa | 19073 | 1072 | 12 |
1781708 | 1781708 | 2021-10-04 | Greene | Iowa | 19073 | 1072 | 12 |
1778458 | 1778458 | 2021-10-03 | Greene | Iowa | 19073 | 1072 | 12 |
1775208 | 1775208 | 2021-10-02 | Greene | Iowa | 19073 | 1072 | 12 |
1771958 | 1771958 | 2021-10-01 | Greene | Iowa | 19073 | 1072 | 12 |
1768709 | 1768709 | 2021-09-30 | Greene | Iowa | 19073 | 1072 | 12 |
1765460 | 1765460 | 2021-09-29 | Greene | Iowa | 19073 | 1072 | 12 |
1761329 | 1761329 | 2021-09-27 | Pepin | Wisconsin | 55091 | 1072 | 7 |
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);