ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 4074 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Virginia 9
- Illinois 8
- Iowa 8
- Oklahoma 8
- Georgia 7
- North Carolina 6
- Minnesota 5
- Tennessee 5
- Indiana 4
- Kentucky 4
- Washington 4
- Maine 3
- Missouri 3
- Pennsylvania 3
- Puerto Rico 3
- Arkansas 2
- Colorado 2
- Michigan 2
- Mississippi 2
- New Hampshire 2
- North Dakota 2
- Ohio 2
- Oregon 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Alaska 1
- California 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502562 | 2502562 | 2022-05-13 | Greene | Virginia | 51079 | 4074 | 62 |
2493726 | 2493726 | 2022-05-11 | Mercer | Illinois | 17131 | 4074 | 47 |
2438367 | 2438367 | 2022-04-24 | Moultrie | Illinois | 17139 | 4074 | 52 |
2435111 | 2435111 | 2022-04-23 | Moultrie | Illinois | 17139 | 4074 | 52 |
2431855 | 2431855 | 2022-04-22 | Moultrie | Illinois | 17139 | 4074 | 52 |
2430577 | 2430577 | 2022-04-21 | Bosque | Texas | 48035 | 4074 | 70 |
2368434 | 2368434 | 2022-04-02 | Catano | Puerto Rico | 72033 | 4074 | |
2331125 | 2331125 | 2022-03-22 | Fayette | Iowa | 19065 | 4074 | 71 |
2327873 | 2327873 | 2022-03-21 | Fayette | Iowa | 19065 | 4074 | 71 |
2324620 | 2324620 | 2022-03-20 | Fayette | Iowa | 19065 | 4074 | 71 |
2321366 | 2321366 | 2022-03-19 | Fayette | Iowa | 19065 | 4074 | 71 |
2318112 | 2318112 | 2022-03-18 | Fayette | Iowa | 19065 | 4074 | 71 |
2319916 | 2319916 | 2022-03-18 | Aransas | Texas | 48007 | 4074 | 80 |
2314859 | 2314859 | 2022-03-17 | Fayette | Iowa | 19065 | 4074 | 71 |
2316662 | 2316662 | 2022-03-17 | Aransas | Texas | 48007 | 4074 | 80 |
2311606 | 2311606 | 2022-03-16 | Fayette | Iowa | 19065 | 4074 | 71 |
2262162 | 2262162 | 2022-03-01 | Polk | Arkansas | 5113 | 4074 | 135 |
2214585 | 2214585 | 2022-02-14 | Houston | Minnesota | 27055 | 4074 | 18 |
2197574 | 2197574 | 2022-02-09 | Carroll | Illinois | 17015 | 4074 | 47 |
2180133 | 2180133 | 2022-02-03 | Deaf Smith | Texas | 48117 | 4074 | 105 |
2170139 | 2170139 | 2022-01-31 | Lee | South Carolina | 45061 | 4074 | 86 |
2153533 | 2153533 | 2022-01-26 | Meigs | Ohio | 39105 | 4074 | 74 |
2142147 | 2142147 | 2022-01-23 | Meriwether | Georgia | 13199 | 4074 | 124 |
2138892 | 2138892 | 2022-01-22 | Meriwether | Georgia | 13199 | 4074 | 124 |
2135636 | 2135636 | 2022-01-21 | Meriwether | Georgia | 13199 | 4074 | 124 |
2123337 | 2123337 | 2022-01-17 | Waldo | Maine | 23027 | 4074 | 47 |
2120085 | 2120085 | 2022-01-16 | Waldo | Maine | 23027 | 4074 | 47 |
2116833 | 2116833 | 2022-01-15 | Waldo | Maine | 23027 | 4074 | 47 |
2108982 | 2108982 | 2022-01-12 | Brooke | West Virginia | 54009 | 4074 | 87 |
2099487 | 2099487 | 2022-01-10 | Arkansas | Arkansas | 5001 | 4074 | 65 |
2099898 | 2099898 | 2022-01-10 | Tattnall | Georgia | 13267 | 4074 | 120 |
2097472 | 2097472 | 2022-01-09 | Dodge | Minnesota | 27039 | 4074 | 14 |
2094220 | 2094220 | 2022-01-08 | Dodge | Minnesota | 27039 | 4074 | 14 |
2090968 | 2090968 | 2022-01-07 | Dodge | Minnesota | 27039 | 4074 | 14 |
2085368 | 2085368 | 2022-01-05 | Lincoln | Oregon | 41041 | 4074 | 58 |
2059704 | 2059704 | 2021-12-28 | Morgan | Tennessee | 47129 | 4074 | 57 |
2055348 | 2055348 | 2021-12-27 | Tishomingo | Mississippi | 28141 | 4074 | 97 |
2053608 | 2053608 | 2021-12-26 | Lee | Virginia | 51105 | 4074 | 62 |
2050358 | 2050358 | 2021-12-25 | Lee | Virginia | 51105 | 4074 | 62 |
2047108 | 2047108 | 2021-12-24 | Lee | Virginia | 51105 | 4074 | 62 |
2014027 | 2014027 | 2021-12-14 | Abbeville | South Carolina | 45001 | 4074 | 53 |
1848885 | 1848885 | 2021-10-24 | Pulaski | Virginia | 51155 | 4074 | 85 |
1845635 | 1845635 | 2021-10-23 | Pulaski | Virginia | 51155 | 4074 | 85 |
1842385 | 1842385 | 2021-10-22 | Pulaski | Virginia | 51155 | 4074 | 85 |
1789695 | 1789695 | 2021-10-06 | Tioga | Pennsylvania | 42117 | 4074 | 122 |
1786732 | 1786732 | 2021-10-05 | Smith | Tennessee | 47159 | 4074 | 48 |
1769928 | 1769928 | 2021-09-30 | Stutsman | North Dakota | 38093 | 4074 | 82 |
1759906 | 1759906 | 2021-09-27 | Nye | Nevada | 32023 | 4074 | 130 |
1748273 | 1748273 | 2021-09-23 | Preston | West Virginia | 54077 | 4074 | 57 |
1713063 | 1713063 | 2021-09-13 | Chattooga | Georgia | 13055 | 4074 | 79 |
1702460 | 1702460 | 2021-09-09 | Palo Pinto | Texas | 48363 | 4074 | 91 |
1693124 | 1693124 | 2021-09-06 | Trempealeau | Wisconsin | 55121 | 4074 | 49 |
1664624 | 1664624 | 2021-08-29 | Adams | Indiana | 18001 | 4074 | 62 |
1661376 | 1661376 | 2021-08-28 | Adams | Indiana | 18001 | 4074 | 62 |
1658128 | 1658128 | 2021-08-27 | Adams | Indiana | 18001 | 4074 | 62 |
1623645 | 1623645 | 2021-08-16 | Jackson | North Carolina | 37099 | 4074 | 56 |
1605522 | 1605522 | 2021-08-11 | Bethel Census Area | Alaska | 2050 | 4074 | 22 |
1565934 | 1565934 | 2021-07-29 | Grimes | Texas | 48185 | 4074 | 74 |
1543436 | 1543436 | 2021-07-22 | Charlottesville city | Virginia | 51540 | 4074 | 58 |
1535448 | 1535448 | 2021-07-20 | Lincoln | Mississippi | 28085 | 4074 | 115 |
1520070 | 1520070 | 2021-07-15 | Pike | Pennsylvania | 42103 | 4074 | 54 |
1417407 | 1417407 | 2021-06-14 | La Plata | Colorado | 8067 | 4074 | 41 |
1414161 | 1414161 | 2021-06-13 | La Plata | Colorado | 8067 | 4074 | 41 |
1367588 | 1367588 | 2021-05-29 | Ponce | Puerto Rico | 72113 | 4074 | |
1363229 | 1363229 | 2021-05-28 | Huron | Michigan | 26063 | 4074 | 79 |
1358431 | 1358431 | 2021-05-26 | Franklin | Virginia | 51067 | 4074 | 78 |
1347727 | 1347727 | 2021-05-23 | Yadkin | North Carolina | 37197 | 4074 | 50 |
1344257 | 1344257 | 2021-05-22 | Belknap | New Hampshire | 33001 | 4074 | 100 |
1344479 | 1344479 | 2021-05-22 | Yadkin | North Carolina | 37197 | 4074 | 50 |
1341231 | 1341231 | 2021-05-21 | Yadkin | North Carolina | 37197 | 4074 | 50 |
1331655 | 1331655 | 2021-05-18 | Custer | Oklahoma | 40039 | 4074 | 98 |
1328408 | 1328408 | 2021-05-17 | Custer | Oklahoma | 40039 | 4074 | 98 |
1325162 | 1325162 | 2021-05-16 | Custer | Oklahoma | 40039 | 4074 | 98 |
1321916 | 1321916 | 2021-05-15 | Custer | Oklahoma | 40039 | 4074 | 98 |
1318670 | 1318670 | 2021-05-14 | Custer | Oklahoma | 40039 | 4074 | 98 |
1315187 | 1315187 | 2021-05-13 | Davie | North Carolina | 37059 | 4074 | 37 |
1315422 | 1315422 | 2021-05-13 | Custer | Oklahoma | 40039 | 4074 | 98 |
1311386 | 1311386 | 2021-05-12 | Nobles | Minnesota | 27105 | 4074 | 48 |
1312176 | 1312176 | 2021-05-12 | Custer | Oklahoma | 40039 | 4074 | 98 |
1303049 | 1303049 | 2021-05-09 | Matagorda | Texas | 48321 | 4074 | 109 |
1269313 | 1269313 | 2021-04-29 | Camden | Missouri | 29029 | 4074 | 87 |
1270422 | 1270422 | 2021-04-29 | Weakley | Tennessee | 47183 | 4074 | 64 |
1262819 | 1262819 | 2021-04-27 | Camden | Missouri | 29029 | 4074 | 87 |
1235181 | 1235181 | 2021-04-18 | Whitman | Washington | 53075 | 4074 | 47 |
1231933 | 1231933 | 2021-04-17 | Whitman | Washington | 53075 | 4074 | 47 |
1227852 | 1227852 | 2021-04-16 | Yamhill | Oregon | 41071 | 4074 | 74 |
1228685 | 1228685 | 2021-04-16 | Whitman | Washington | 53075 | 4074 | 47 |
1213277 | 1213277 | 2021-04-12 | Randolph | Illinois | 17157 | 4074 | 90 |
1215677 | 1215677 | 2021-04-12 | Lewis | Washington | 53041 | 4074 | 58 |
1210029 | 1210029 | 2021-04-11 | Randolph | Illinois | 17157 | 4074 | 90 |
1207144 | 1207144 | 2021-04-10 | Graves | Kentucky | 21083 | 4074 | 90 |
1198757 | 1198757 | 2021-04-07 | Toa Baja | Puerto Rico | 72137 | 4074 | |
1147144 | 1147144 | 2021-03-22 | Jim Wells | Texas | 48249 | 4074 | 92 |
1143897 | 1143897 | 2021-03-21 | Jim Wells | Texas | 48249 | 4074 | 92 |
1120614 | 1120614 | 2021-03-14 | Logan | Oklahoma | 40083 | 4074 | 31 |
1110785 | 1110785 | 2021-03-11 | Knox | Ohio | 39083 | 4074 | 106 |
1103471 | 1103471 | 2021-03-09 | Isabella | Michigan | 26073 | 4074 | 73 |
1064813 | 1064813 | 2021-02-25 | Newton | Missouri | 29145 | 4074 | 66 |
1033363 | 1033363 | 2021-02-15 | Lincoln | Tennessee | 47103 | 4074 | 60 |
1005571 | 1005571 | 2021-02-07 | Lawrence | Indiana | 18093 | 4074 | 110 |
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);