ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 5300 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Arkansas 10
- Texas 8
- Mississippi 6
- North Carolina 6
- Tennessee 6
- Minnesota 5
- Missouri 5
- Indiana 4
- Ohio 3
- Wisconsin 3
- Colorado 2
- Georgia 2
- Michigan 2
- New York 2
- North Dakota 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Virginia 2
- Alabama 1
- Florida 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- New Jersey 1
- Oregon 1
- South Dakota 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437844 | 2437844 | 2022-04-24 | Lawrence | Arkansas | 5075 | 5300 | 77 |
2434588 | 2434588 | 2022-04-23 | Lawrence | Arkansas | 5075 | 5300 | 77 |
2431332 | 2431332 | 2022-04-22 | Lawrence | Arkansas | 5075 | 5300 | 77 |
2428076 | 2428076 | 2022-04-21 | Lawrence | Arkansas | 5075 | 5300 | 77 |
2340177 | 2340177 | 2022-03-25 | Clark | Arkansas | 5019 | 5300 | 79 |
2336924 | 2336924 | 2022-03-24 | Clark | Arkansas | 5019 | 5300 | 78 |
2333670 | 2333670 | 2022-03-23 | Clark | Arkansas | 5019 | 5300 | 78 |
2330416 | 2330416 | 2022-03-22 | Clark | Arkansas | 5019 | 5300 | 78 |
2287474 | 2287474 | 2022-03-08 | Gillespie | Texas | 48171 | 5300 | 106 |
2237038 | 2237038 | 2022-02-21 | Hart | Kentucky | 21099 | 5300 | 92 |
2211385 | 2211385 | 2022-02-13 | Wabasha | Minnesota | 27157 | 5300 | 16 |
2208132 | 2208132 | 2022-02-12 | Wabasha | Minnesota | 27157 | 5300 | 16 |
2204879 | 2204879 | 2022-02-11 | Wabasha | Minnesota | 27157 | 5300 | 16 |
2193505 | 2193505 | 2022-02-07 | Staunton city | Virginia | 51790 | 5300 | 98 |
2188628 | 2188628 | 2022-02-06 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2185375 | 2185375 | 2022-02-05 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2182123 | 2182123 | 2022-02-04 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2148096 | 2148096 | 2022-01-24 | Jackson | Wisconsin | 55053 | 5300 | 40 |
2112527 | 2112527 | 2022-01-14 | Johnson | Arkansas | 5071 | 5300 | 65 |
2078018 | 2078018 | 2022-01-03 | Todd | Minnesota | 27153 | 5300 | 52 |
2033544 | 2033544 | 2021-12-20 | Clarendon | South Carolina | 45027 | 5300 | 137 |
2011541 | 2011541 | 2021-12-13 | Juneau | Wisconsin | 55057 | 5300 | 46 |
1975606 | 1975606 | 2021-12-02 | Manassas city | Virginia | 51683 | 5300 | 54 |
1975667 | 1975667 | 2021-12-02 | Clallam | Washington | 53009 | 5300 | 73 |
1961183 | 1961183 | 2021-11-28 | Polk | Missouri | 29167 | 5300 | 80 |
1957932 | 1957932 | 2021-11-27 | Polk | Missouri | 29167 | 5300 | 80 |
1954681 | 1954681 | 2021-11-26 | Polk | Missouri | 29167 | 5300 | 80 |
1951430 | 1951430 | 2021-11-25 | Polk | Missouri | 29167 | 5300 | 80 |
1948179 | 1948179 | 2021-11-24 | Polk | Missouri | 29167 | 5300 | 80 |
1880473 | 1880473 | 2021-11-03 | Perry | Ohio | 39127 | 5300 | 70 |
1864740 | 1864740 | 2021-10-29 | Bee | Texas | 48025 | 5300 | 127 |
1858242 | 1858242 | 2021-10-27 | Bee | Texas | 48025 | 5300 | 127 |
1818514 | 1818514 | 2021-10-15 | Warren | New York | 36113 | 5300 | 81 |
1813978 | 1813978 | 2021-10-14 | Christian | Illinois | 17021 | 5300 | 100 |
1809344 | 1809344 | 2021-10-12 | Codington | South Dakota | 46029 | 5300 | 83 |
1809409 | 1809409 | 2021-10-12 | Claiborne | Tennessee | 47025 | 5300 | 95 |
1732318 | 1732318 | 2021-09-19 | Union | Arkansas | 5139 | 5300 | 126 |
1734722 | 1734722 | 2021-09-19 | Marion | Tennessee | 47115 | 5300 | 52 |
1731472 | 1731472 | 2021-09-18 | Marion | Tennessee | 47115 | 5300 | 52 |
1728222 | 1728222 | 2021-09-17 | Marion | Tennessee | 47115 | 5300 | 52 |
1720488 | 1720488 | 2021-09-15 | Douglas | Minnesota | 27041 | 5300 | 84 |
1695221 | 1695221 | 2021-09-07 | Ashland | Ohio | 39005 | 5300 | 107 |
1692642 | 1692642 | 2021-09-06 | Hill | Texas | 48217 | 5300 | 125 |
1692774 | 1692774 | 2021-09-06 | Wharton | Texas | 48481 | 5300 | 131 |
1649729 | 1649729 | 2021-08-24 | Stark | North Dakota | 38089 | 5300 | 52 |
1581910 | 1581910 | 2021-08-03 | Newberry | South Carolina | 45071 | 5300 | 108 |
1560496 | 1560496 | 2021-07-28 | Tift | Georgia | 13277 | 5300 | 133 |
1474664 | 1474664 | 2021-07-01 | Guaynabo | Puerto Rico | 72061 | 5300 | |
1419090 | 1419090 | 2021-06-14 | McDowell | North Carolina | 37111 | 5300 | 63 |
1415845 | 1415845 | 2021-06-13 | McDowell | North Carolina | 37111 | 5300 | 63 |
1412599 | 1412599 | 2021-06-12 | McDowell | North Carolina | 37111 | 5300 | 63 |
1409354 | 1409354 | 2021-06-11 | McDowell | North Carolina | 37111 | 5300 | 63 |
1406109 | 1406109 | 2021-06-10 | McDowell | North Carolina | 37111 | 5300 | 63 |
1354250 | 1354250 | 2021-05-25 | Morton | North Dakota | 38059 | 5300 | 100 |
1256304 | 1256304 | 2021-04-25 | Washington | Mississippi | 28151 | 5300 | 133 |
1253057 | 1253057 | 2021-04-24 | Washington | Mississippi | 28151 | 5300 | 133 |
1253646 | 1253646 | 2021-04-24 | Darke | Ohio | 39037 | 5300 | 121 |
1248703 | 1248703 | 2021-04-23 | Suwannee | Florida | 12121 | 5300 | 137 |
1249810 | 1249810 | 2021-04-23 | Washington | Mississippi | 28151 | 5300 | 133 |
1226012 | 1226012 | 2021-04-16 | Coffee | Georgia | 13069 | 5300 | 168 |
1197677 | 1197677 | 2021-04-07 | St. Joseph | Michigan | 26149 | 5300 | 91 |
1144664 | 1144664 | 2021-03-22 | Garfield | Colorado | 8045 | 5300 | 38 |
1135879 | 1135879 | 2021-03-19 | St. Mary's | Maryland | 24037 | 5300 | 118 |
1101509 | 1101509 | 2021-03-08 | Hawkins | Tennessee | 47073 | 5300 | 98 |
1059924 | 1059924 | 2021-02-23 | Grant | Wisconsin | 55043 | 5300 | 84 |
1028257 | 1028257 | 2021-02-14 | Dearborn | Indiana | 18029 | 5300 | 65 |
1019089 | 1019089 | 2021-02-11 | Lapeer | Michigan | 26087 | 5300 | 126 |
1020531 | 1020531 | 2021-02-11 | Henderson | Texas | 48213 | 5300 | 144 |
1017286 | 1017286 | 2021-02-10 | Henderson | Texas | 48213 | 5300 | 143 |
1008820 | 1008820 | 2021-02-08 | Marshall | Indiana | 18099 | 5300 | 99 |
1000208 | 1000208 | 2021-02-05 | Ontario | New York | 36069 | 5300 | 88 |
961680 | 961680 | 2021-01-24 | Lawrence | Pennsylvania | 42073 | 5300 | 159 |
955489 | 955489 | 2021-01-22 | Roane | Tennessee | 47145 | 5300 | 81 |
930881 | 930881 | 2021-01-15 | Boone | Indiana | 18011 | 5300 | 71 |
894536 | 894536 | 2021-01-04 | Talladega | Alabama | 1121 | 5300 | 76 |
861032 | 861032 | 2020-12-24 | Umatilla | Oregon | 41059 | 5300 | 56 |
838896 | 838896 | 2020-12-17 | Starr | Texas | 48427 | 5300 | 197 |
702106 | 702106 | 2020-11-05 | Bayamon | Puerto Rico | 72021 | 5300 | |
611266 | 611266 | 2020-10-08 | York | Pennsylvania | 42133 | 5300 | 176 |
565484 | 565484 | 2020-09-24 | Cumberland | North Carolina | 37051 | 5300 | 75 |
447863 | 447863 | 2020-08-19 | Elkhart | Indiana | 18039 | 5300 | 97 |
304603 | 304603 | 2020-07-05 | Burlington | New Jersey | 34005 | 5300 | 433 |
296781 | 296781 | 2020-07-03 | Arapahoe | Colorado | 8005 | 5300 | 345 |
99312 | 99312 | 2020-04-29 | Worcester | Massachusetts | 25027 | 5300 | 253 |
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);