ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
235 rows where cases = 2051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 16
- Texas 16
- Missouri 14
- Mississippi 13
- Virginia 13
- Arkansas 11
- Georgia 10
- Louisiana 9
- Alabama 8
- Iowa 8
- Tennessee 8
- Minnesota 7
- North Carolina 7
- South Dakota 7
- Vermont 7
- Wisconsin 7
- Illinois 6
- Kansas 6
- Michigan 6
- Ohio 6
- Idaho 5
- Indiana 5
- Oklahoma 5
- Kentucky 4
- West Virginia 4
- Colorado 3
- Maryland 3
- North Dakota 3
- California 2
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499586 | 2499586 | 2022-05-13 | Choctaw | Alabama | 1023 | 2051 | 36 |
2242663 | 2242663 | 2022-02-23 | Searcy | Arkansas | 5129 | 2051 | 41 |
2240028 | 2240028 | 2022-02-22 | Warren | Indiana | 18171 | 2051 | 25 |
2222841 | 2222841 | 2022-02-16 | Doddridge | West Virginia | 54017 | 2051 | 17 |
2211403 | 2211403 | 2022-02-13 | Choctaw | Mississippi | 28019 | 2051 | 30 |
2208150 | 2208150 | 2022-02-12 | Choctaw | Mississippi | 28019 | 2051 | 30 |
2209432 | 2209432 | 2022-02-12 | Franklin | Texas | 48159 | 2051 | 38 |
2204897 | 2204897 | 2022-02-11 | Choctaw | Mississippi | 28019 | 2051 | 30 |
2190975 | 2190975 | 2022-02-07 | Stewart | Georgia | 13259 | 2051 | 31 |
2188173 | 2188173 | 2022-02-06 | Pawnee | Kansas | 20145 | 2051 | 23 |
2184920 | 2184920 | 2022-02-05 | Pawnee | Kansas | 20145 | 2051 | 23 |
2181668 | 2181668 | 2022-02-04 | Pawnee | Kansas | 20145 | 2051 | 23 |
2178610 | 2178610 | 2022-02-03 | Red River | Louisiana | 22081 | 2051 | 50 |
2178991 | 2178991 | 2022-02-03 | Iron | Missouri | 29093 | 2051 | 35 |
2173944 | 2173944 | 2022-02-01 | Lunenburg | Virginia | 51111 | 2051 | 24 |
2168323 | 2168323 | 2022-01-31 | Hamilton | Illinois | 17065 | 2051 | 31 |
2158498 | 2158498 | 2022-01-28 | Clearwater | Idaho | 16035 | 2051 | 29 |
2155134 | 2155134 | 2022-01-27 | Heard | Georgia | 13149 | 2051 | 43 |
2155176 | 2155176 | 2022-01-27 | Pulaski | Georgia | 13235 | 2051 | 68 |
2155245 | 2155245 | 2022-01-27 | Clearwater | Idaho | 16035 | 2051 | 29 |
2148338 | 2148338 | 2022-01-25 | Scott | Arkansas | 5127 | 2051 | 35 |
2130253 | 2130253 | 2022-01-19 | Wayne | Missouri | 29223 | 2051 | 38 |
2114734 | 2114734 | 2022-01-14 | Ciales | Puerto Rico | 72039 | 2051 | |
2105802 | 2105802 | 2022-01-11 | Forest | Wisconsin | 55041 | 2051 | 44 |
2080161 | 2080161 | 2022-01-04 | Prowers | Colorado | 8099 | 2051 | 43 |
2067040 | 2067040 | 2021-12-31 | Stone | Arkansas | 5137 | 2051 | 49 |
2053530 | 2053530 | 2021-12-26 | Orange | Vermont | 50017 | 2051 | 9 |
2050280 | 2050280 | 2021-12-25 | Orange | Vermont | 50017 | 2051 | 9 |
2047030 | 2047030 | 2021-12-24 | Orange | Vermont | 50017 | 2051 | 9 |
2043780 | 2043780 | 2021-12-23 | Orange | Vermont | 50017 | 2051 | 9 |
2037257 | 2037257 | 2021-12-21 | Morgan | Utah | 49029 | 2051 | 13 |
2031232 | 2031232 | 2021-12-20 | Chicot | Arkansas | 5017 | 2051 | 48 |
1984835 | 1984835 | 2021-12-05 | Dewey | South Dakota | 46041 | 2051 | 33 |
1981585 | 1981585 | 2021-12-04 | Dewey | South Dakota | 46041 | 2051 | 33 |
1978335 | 1978335 | 2021-12-03 | Dewey | South Dakota | 46041 | 2051 | 33 |
1967693 | 1967693 | 2021-11-30 | Ripley | Missouri | 29181 | 2051 | 49 |
1964948 | 1964948 | 2021-11-29 | Harrison | Ohio | 39067 | 2051 | 52 |
1961093 | 1961093 | 2021-11-28 | Webster | Mississippi | 28155 | 2051 | 48 |
1957842 | 1957842 | 2021-11-27 | Webster | Mississippi | 28155 | 2051 | 48 |
1958356 | 1958356 | 2021-11-27 | Barnes | North Dakota | 38003 | 2051 | 38 |
1954591 | 1954591 | 2021-11-26 | Webster | Mississippi | 28155 | 2051 | 48 |
1951340 | 1951340 | 2021-11-25 | Webster | Mississippi | 28155 | 2051 | 48 |
1948089 | 1948089 | 2021-11-24 | Webster | Mississippi | 28155 | 2051 | 48 |
1921191 | 1921191 | 2021-11-16 | Shoshone | Idaho | 16079 | 2051 | 63 |
1921778 | 1921778 | 2021-11-16 | West Carroll | Louisiana | 22123 | 2051 | 50 |
1903446 | 1903446 | 2021-11-10 | Cayey | Puerto Rico | 72035 | 2051 | |
1877221 | 1877221 | 2021-11-02 | Noble | Ohio | 39121 | 2051 | 47 |
1873194 | 1873194 | 2021-11-01 | Cottonwood | Minnesota | 27033 | 2051 | 29 |
1869276 | 1869276 | 2021-10-31 | Piatt | Illinois | 17147 | 2051 | 20 |
1869540 | 1869540 | 2021-10-31 | Jackson | Kansas | 20085 | 2051 | 19 |
1866027 | 1866027 | 2021-10-30 | Piatt | Illinois | 17147 | 2051 | 20 |
1866291 | 1866291 | 2021-10-30 | Jackson | Kansas | 20085 | 2051 | 19 |
1862778 | 1862778 | 2021-10-29 | Piatt | Illinois | 17147 | 2051 | 20 |
1863042 | 1863042 | 2021-10-29 | Jackson | Kansas | 20085 | 2051 | 19 |
1860431 | 1860431 | 2021-10-28 | Pemiscot | Missouri | 29155 | 2051 | 43 |
1857182 | 1857182 | 2021-10-27 | Pemiscot | Missouri | 29155 | 2051 | 43 |
1847275 | 1847275 | 2021-10-24 | Amite | Mississippi | 28005 | 2051 | 56 |
1844025 | 1844025 | 2021-10-23 | Amite | Mississippi | 28005 | 2051 | 56 |
1840775 | 1840775 | 2021-10-22 | Amite | Mississippi | 28005 | 2051 | 56 |
1837526 | 1837526 | 2021-10-21 | Amite | Mississippi | 28005 | 2051 | 55 |
1827759 | 1827759 | 2021-10-18 | Sibley | Minnesota | 27143 | 2051 | 12 |
1826242 | 1826242 | 2021-10-17 | Monroe | West Virginia | 54063 | 2051 | 25 |
1816295 | 1816295 | 2021-10-14 | Alleghany | Virginia | 51005 | 2051 | 64 |
1799236 | 1799236 | 2021-10-09 | Monroe | Ohio | 39111 | 2051 | 50 |
1800041 | 1800041 | 2021-10-09 | Windham | Vermont | 50025 | 2051 | 23 |
1792662 | 1792662 | 2021-10-07 | Ramsey | North Dakota | 38071 | 2051 | 33 |
1790564 | 1790564 | 2021-10-06 | Marquette | Wisconsin | 55077 | 2051 | 31 |
1759479 | 1759479 | 2021-09-27 | Fillmore | Minnesota | 27045 | 2051 | 10 |
1755381 | 1755381 | 2021-09-26 | Oglethorpe | Georgia | 13221 | 2051 | 36 |
1752133 | 1752133 | 2021-09-25 | Oglethorpe | Georgia | 13221 | 2051 | 36 |
1748884 | 1748884 | 2021-09-24 | Oglethorpe | Georgia | 13221 | 2051 | 36 |
1745290 | 1745290 | 2021-09-23 | Marion | Arkansas | 5089 | 2051 | 55 |
1746526 | 1746526 | 2021-09-23 | Redwood | Minnesota | 27127 | 2051 | 42 |
1741447 | 1741447 | 2021-09-21 | Pecos | Texas | 48371 | 2051 | 41 |
1736449 | 1736449 | 2021-09-20 | Knott | Kentucky | 21119 | 2051 | 29 |
1736824 | 1736824 | 2021-09-20 | Greene | Mississippi | 28041 | 2051 | 45 |
1723948 | 1723948 | 2021-09-16 | Macon | Missouri | 29121 | 2051 | 19 |
1715907 | 1715907 | 2021-09-14 | Cleburne | Alabama | 1029 | 2051 | 46 |
1713291 | 1713291 | 2021-09-13 | Johnson | Illinois | 17087 | 2051 | 27 |
1715854 | 1715854 | 2021-09-13 | Sawyer | Wisconsin | 55113 | 2051 | 29 |
1694717 | 1694717 | 2021-09-07 | Madison | Missouri | 29123 | 2051 | 18 |
1696034 | 1696034 | 2021-09-07 | Zapata | Texas | 48505 | 2051 | 39 |
1692786 | 1692786 | 2021-09-06 | Zapata | Texas | 48505 | 2051 | 39 |
1689537 | 1689537 | 2021-09-05 | Zapata | Texas | 48505 | 2051 | 39 |
1644225 | 1644225 | 2021-08-22 | Southampton | Virginia | 51175 | 2051 | 58 |
1639458 | 1639458 | 2021-08-21 | Dallas | Missouri | 29059 | 2051 | 37 |
1640975 | 1640975 | 2021-08-21 | Southampton | Virginia | 51175 | 2051 | 58 |
1637725 | 1637725 | 2021-08-20 | Southampton | Virginia | 51175 | 2051 | 58 |
1632778 | 1632778 | 2021-08-19 | Dodge | Minnesota | 27039 | 2051 | 3 |
1631317 | 1631317 | 2021-08-18 | Nicholas | West Virginia | 54067 | 2051 | 26 |
1623734 | 1623734 | 2021-08-16 | Richland | North Dakota | 38077 | 2051 | 17 |
1587849 | 1587849 | 2021-08-05 | Seneca | New York | 36099 | 2051 | 57 |
1575359 | 1575359 | 2021-08-01 | San Sebastian | Puerto Rico | 72131 | 2051 | |
1562303 | 1562303 | 2021-07-28 | Aguadilla | Puerto Rico | 72005 | 2051 | |
1555223 | 1555223 | 2021-07-26 | Seward | Nebraska | 31159 | 2051 | 34 |
1556388 | 1556388 | 2021-07-26 | Franklin | Vermont | 50011 | 2051 | 39 |
1556690 | 1556690 | 2021-07-26 | Vernon | Wisconsin | 55123 | 2051 | 43 |
1550262 | 1550262 | 2021-07-25 | Henry | Alabama | 1067 | 2051 | 45 |
1551976 | 1551976 | 2021-07-25 | Seward | Nebraska | 31159 | 2051 | 34 |
1542119 | 1542119 | 2021-07-22 | Hill | Montana | 30041 | 2051 | 46 |
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);