ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where cases = 3882 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 12
- Georgia 9
- Ohio 9
- Oklahoma 9
- Florida 8
- Illinois 8
- Kentucky 8
- Minnesota 6
- Mississippi 6
- Wisconsin 6
- Missouri 5
- South Carolina 5
- Texas 5
- Alabama 4
- Louisiana 4
- North Carolina 4
- Virginia 4
- Indiana 3
- New York 3
- Pennsylvania 3
- Tennessee 3
- West Virginia 3
- Iowa 2
- Maryland 2
- Nevada 2
- Puerto Rico 2
- Alaska 1
- Arkansas 1
- California 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496360 | 2496360 | 2022-05-12 | Macon | Alabama | 1087 | 3882 | 85 |
2464406 | 2464406 | 2022-05-02 | Massac | Illinois | 17127 | 3882 | 71 |
2461150 | 2461150 | 2022-05-01 | Massac | Illinois | 17127 | 3882 | 71 |
2457894 | 2457894 | 2022-04-30 | Massac | Illinois | 17127 | 3882 | 71 |
2459633 | 2459633 | 2022-04-30 | Salinas | Puerto Rico | 72123 | 3882 | |
2454638 | 2454638 | 2022-04-29 | Massac | Illinois | 17127 | 3882 | 71 |
2451382 | 2451382 | 2022-04-28 | Massac | Illinois | 17127 | 3882 | 71 |
2448126 | 2448126 | 2022-04-27 | Massac | Illinois | 17127 | 3882 | 71 |
2440909 | 2440909 | 2022-04-24 | Richland | Wisconsin | 55103 | 3882 | 48 |
2437653 | 2437653 | 2022-04-23 | Richland | Wisconsin | 55103 | 3882 | 48 |
2434397 | 2434397 | 2022-04-22 | Richland | Wisconsin | 55103 | 3882 | 48 |
2406076 | 2406076 | 2022-04-14 | Jackson | Kansas | 20085 | 3882 | 29 |
2402820 | 2402820 | 2022-04-13 | Jackson | Kansas | 20085 | 3882 | 29 |
2399566 | 2399566 | 2022-04-12 | Jackson | Kansas | 20085 | 3882 | 29 |
2396310 | 2396310 | 2022-04-11 | Jackson | Kansas | 20085 | 3882 | 29 |
2393055 | 2393055 | 2022-04-10 | Jackson | Kansas | 20085 | 3882 | 29 |
2389799 | 2389799 | 2022-04-09 | Jackson | Kansas | 20085 | 3882 | 29 |
2386543 | 2386543 | 2022-04-08 | Jackson | Kansas | 20085 | 3882 | 29 |
2308185 | 2308185 | 2022-03-15 | Mason | Illinois | 17125 | 3882 | 61 |
2302139 | 2302139 | 2022-03-13 | Webster | Kentucky | 21233 | 3882 | 47 |
2298887 | 2298887 | 2022-03-12 | Webster | Kentucky | 21233 | 3882 | 47 |
2295635 | 2295635 | 2022-03-11 | Webster | Kentucky | 21233 | 3882 | 47 |
2292383 | 2292383 | 2022-03-10 | Webster | Kentucky | 21233 | 3882 | 47 |
2289131 | 2289131 | 2022-03-09 | Webster | Kentucky | 21233 | 3882 | 47 |
2285880 | 2285880 | 2022-03-08 | Webster | Kentucky | 21233 | 3882 | 47 |
2282628 | 2282628 | 2022-03-07 | Webster | Kentucky | 21233 | 3882 | 47 |
2265642 | 2265642 | 2022-03-02 | Banks | Georgia | 13011 | 3882 | 83 |
2262391 | 2262391 | 2022-03-01 | Banks | Georgia | 13011 | 3882 | 83 |
2246094 | 2246094 | 2022-02-24 | Jefferson | Florida | 12065 | 3882 | 39 |
2242843 | 2242843 | 2022-02-23 | Jefferson | Florida | 12065 | 3882 | 39 |
2239592 | 2239592 | 2022-02-22 | Jefferson | Florida | 12065 | 3882 | 39 |
2239694 | 2239694 | 2022-02-22 | Greene | Georgia | 13133 | 3882 | 80 |
2239708 | 2239708 | 2022-02-22 | Jeff Davis | Georgia | 13161 | 3882 | 66 |
2236341 | 2236341 | 2022-02-21 | Jefferson | Florida | 12065 | 3882 | 39 |
2233090 | 2233090 | 2022-02-20 | Jefferson | Florida | 12065 | 3882 | 39 |
2229839 | 2229839 | 2022-02-19 | Jefferson | Florida | 12065 | 3882 | 39 |
2226588 | 2226588 | 2022-02-18 | Jefferson | Florida | 12065 | 3882 | 39 |
2176966 | 2176966 | 2022-02-02 | Lee | Texas | 48287 | 3882 | 56 |
2173237 | 2173237 | 2022-02-01 | Fulton | Pennsylvania | 42057 | 3882 | 59 |
2170596 | 2170596 | 2022-01-31 | Unknown | Utah | 3882 | 65 | |
2167590 | 2167590 | 2022-01-30 | Wetzel | West Virginia | 54103 | 3882 | 71 |
2156194 | 2156194 | 2022-01-27 | Cooper | Missouri | 29053 | 3882 | 71 |
2151299 | 2151299 | 2022-01-25 | Morgan | West Virginia | 54065 | 3882 | 57 |
2133245 | 2133245 | 2022-01-20 | Fillmore | Minnesota | 27045 | 3882 | 19 |
2108903 | 2108903 | 2022-01-12 | Powhatan | Virginia | 51145 | 3882 | 32 |
2086159 | 2086159 | 2022-01-05 | Scott | Virginia | 51169 | 3882 | 92 |
2081614 | 2081614 | 2022-01-04 | Saunders | Nebraska | 31155 | 3882 | 23 |
2079434 | 2079434 | 2022-01-03 | Reeves | Texas | 48389 | 3882 | 60 |
2060510 | 2060510 | 2021-12-29 | Lincoln | Arkansas | 5079 | 3882 | 58 |
2059901 | 2059901 | 2021-12-28 | Milam | Texas | 48331 | 3882 | 91 |
2029401 | 2029401 | 2021-12-19 | Henry | Missouri | 29083 | 3882 | 65 |
2021327 | 2021327 | 2021-12-16 | Vernon | Wisconsin | 55123 | 3882 | 71 |
2014663 | 2014663 | 2021-12-14 | Waynesboro city | Virginia | 51820 | 3882 | 53 |
2010430 | 2010430 | 2021-12-13 | Carroll | Ohio | 39019 | 3882 | 80 |
1995816 | 1995816 | 2021-12-09 | Harris | Georgia | 13145 | 3882 | 96 |
1992564 | 1992564 | 2021-12-08 | Haralson | Georgia | 13143 | 3882 | 130 |
1973974 | 1973974 | 2021-12-02 | Martin | Minnesota | 27091 | 3882 | 44 |
1945445 | 1945445 | 2021-11-23 | Holmes | Ohio | 39075 | 3882 | 137 |
1899312 | 1899312 | 2021-11-09 | Newton | Mississippi | 28101 | 3882 | 81 |
1896062 | 1896062 | 2021-11-08 | Newton | Mississippi | 28101 | 3882 | 81 |
1853424 | 1853424 | 2021-10-26 | Letcher | Kentucky | 21133 | 3882 | 66 |
1848279 | 1848279 | 2021-10-24 | Barnwell | South Carolina | 45011 | 3882 | 83 |
1845029 | 1845029 | 2021-10-23 | Barnwell | South Carolina | 45011 | 3882 | 83 |
1841779 | 1841779 | 2021-10-22 | Barnwell | South Carolina | 45011 | 3882 | 83 |
1723725 | 1723725 | 2021-09-16 | Carlton | Minnesota | 27017 | 3882 | 59 |
1716667 | 1716667 | 2021-09-14 | Scott | Indiana | 18143 | 3882 | 65 |
1717347 | 1717347 | 2021-09-14 | Leake | Mississippi | 28079 | 3882 | 83 |
1718975 | 1718975 | 2021-09-14 | Okanogan | Washington | 53047 | 3882 | 48 |
1712509 | 1712509 | 2021-09-12 | Greenbrier | West Virginia | 54025 | 3882 | 69 |
1672605 | 1672605 | 2021-08-31 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1668668 | 1668668 | 2021-08-30 | Barry | Missouri | 29009 | 3882 | 55 |
1669357 | 1669357 | 2021-08-30 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1670342 | 1670342 | 2021-08-30 | Green | Wisconsin | 55045 | 3882 | 26 |
1666110 | 1666110 | 2021-08-29 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1662862 | 1662862 | 2021-08-28 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1659614 | 1659614 | 2021-08-27 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1656365 | 1656365 | 2021-08-26 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1653118 | 1653118 | 2021-08-25 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1641228 | 1641228 | 2021-08-22 | Marion | Alabama | 1093 | 3882 | 108 |
1627276 | 1627276 | 2021-08-17 | Arecibo | Puerto Rico | 72013 | 3882 | |
1607225 | 1607225 | 2021-08-11 | Lyon | Nevada | 32019 | 3882 | 69 |
1601575 | 1601575 | 2021-08-09 | White | Tennessee | 47185 | 3882 | 75 |
1601807 | 1601807 | 2021-08-09 | Upshur | Texas | 48459 | 3882 | 78 |
1554220 | 1554220 | 2021-07-26 | Knox | Indiana | 18083 | 3882 | 91 |
1515835 | 1515835 | 2021-07-14 | Becker | Minnesota | 27005 | 3882 | 56 |
1484169 | 1484169 | 2021-07-04 | Preble | Ohio | 39135 | 3882 | 106 |
1480923 | 1480923 | 2021-07-03 | Preble | Ohio | 39135 | 3882 | 106 |
1470226 | 1470226 | 2021-06-30 | St. John the Baptist | Louisiana | 22095 | 3882 | 141 |
1471162 | 1471162 | 2021-06-30 | Logan | Ohio | 39091 | 3882 | 79 |
1425607 | 1425607 | 2021-06-16 | Scotland | North Carolina | 37165 | 3882 | 88 |
1402683 | 1402683 | 2021-06-09 | Cheshire | New Hampshire | 33005 | 3882 | 35 |
1287354 | 1287354 | 2021-05-05 | Bethel Census Area | Alaska | 2050 | 3882 | 21 |
1269658 | 1269658 | 2021-04-29 | Columbia | New York | 36021 | 3882 | 100 |
1253635 | 1253635 | 2021-04-24 | Brown | Ohio | 39015 | 3882 | 56 |
1239895 | 1239895 | 2021-04-20 | Sanilac | Michigan | 26151 | 3882 | 98 |
1213250 | 1213250 | 2021-04-12 | Lee | Illinois | 17103 | 3882 | 88 |
1193170 | 1193170 | 2021-04-06 | Tallapoosa | Alabama | 1123 | 3882 | 147 |
1192415 | 1192415 | 2021-04-05 | Giles | Tennessee | 47055 | 3882 | 98 |
1180987 | 1180987 | 2021-04-02 | Plymouth | Iowa | 19149 | 3882 | 79 |
1142062 | 1142062 | 2021-03-21 | Cowley | Kansas | 20035 | 3882 | 9 |
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);