ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4586 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 14
- Puerto Rico 7
- Illinois 6
- Mississippi 6
- Tennessee 6
- Kansas 5
- Missouri 5
- New York 5
- Ohio 5
- Arkansas 4
- California 4
- Georgia 4
- Indiana 4
- Pennsylvania 4
- Virginia 4
- Minnesota 3
- Wisconsin 3
- Colorado 2
- Louisiana 2
- Michigan 2
- North Carolina 2
- South Carolina 2
- Florida 1
- Kentucky 1
- Nebraska 1
- New Mexico 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466061 | 2466061 | 2022-05-02 | Montour | Pennsylvania | 42093 | 4586 | 93 |
2424230 | 2424230 | 2022-04-19 | Panola | Texas | 48365 | 4586 | 129 |
2420974 | 2420974 | 2022-04-18 | Panola | Texas | 48365 | 4586 | 129 |
2391617 | 2391617 | 2022-04-09 | Jones | Texas | 48253 | 4586 | 92 |
2378206 | 2378206 | 2022-04-05 | Guayama | Puerto Rico | 72057 | 4586 | |
2292580 | 2292580 | 2022-03-10 | Roscommon | Michigan | 26143 | 4586 | 111 |
2288623 | 2288623 | 2022-03-09 | Cass | Illinois | 17017 | 4586 | 44 |
2289328 | 2289328 | 2022-03-09 | Roscommon | Michigan | 26143 | 4586 | 111 |
2290357 | 2290357 | 2022-03-09 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2284939 | 2284939 | 2022-03-08 | Sharp | Arkansas | 5135 | 4586 | 100 |
2287105 | 2287105 | 2022-03-08 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2283853 | 2283853 | 2022-03-07 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2280384 | 2280384 | 2022-03-06 | Paulding | Ohio | 39125 | 4586 | 73 |
2280601 | 2280601 | 2022-03-06 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2277348 | 2277348 | 2022-03-05 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2274095 | 2274095 | 2022-03-04 | Barranquitas | Puerto Rico | 72019 | 4586 | |
2264815 | 2264815 | 2022-03-01 | Reeves | Texas | 48389 | 4586 | 71 |
2237594 | 2237594 | 2022-02-21 | Texas | Missouri | 29215 | 4586 | 87 |
2234343 | 2234343 | 2022-02-20 | Texas | Missouri | 29215 | 4586 | 87 |
2231092 | 2231092 | 2022-02-19 | Texas | Missouri | 29215 | 4586 | 87 |
2227841 | 2227841 | 2022-02-18 | Texas | Missouri | 29215 | 4586 | 87 |
2196413 | 2196413 | 2022-02-08 | Fayette | Texas | 48149 | 4586 | 98 |
2111553 | 2111553 | 2022-01-13 | Barnwell | South Carolina | 45011 | 4586 | 88 |
2087862 | 2087862 | 2022-01-06 | Wayne | Mississippi | 28153 | 4586 | 73 |
2023231 | 2023231 | 2021-12-17 | Lewis | New York | 36049 | 4586 | 40 |
1997913 | 1997913 | 2021-12-09 | Grainger | Tennessee | 47057 | 4586 | 74 |
1994662 | 1994662 | 2021-12-08 | Grainger | Tennessee | 47057 | 4586 | 74 |
1990349 | 1990349 | 2021-12-07 | Yazoo | Mississippi | 28163 | 4586 | 92 |
1943085 | 1943085 | 2021-11-22 | Isle of Wight | Virginia | 51093 | 4586 | 91 |
1925938 | 1925938 | 2021-11-17 | Hardin | Ohio | 39065 | 4586 | 97 |
1923776 | 1923776 | 2021-11-16 | Juneau | Wisconsin | 55057 | 4586 | 37 |
1893212 | 1893212 | 2021-11-07 | Greene | New York | 36039 | 4586 | 87 |
1889959 | 1889959 | 2021-11-06 | Franklin | New York | 36033 | 4586 | 25 |
1882976 | 1882976 | 2021-11-04 | Nicollet | Minnesota | 27103 | 4586 | 57 |
1869523 | 1869523 | 2021-10-31 | Ellis | Kansas | 20051 | 4586 | 76 |
1866274 | 1866274 | 2021-10-30 | Ellis | Kansas | 20051 | 4586 | 76 |
1863025 | 1863025 | 2021-10-29 | Ellis | Kansas | 20051 | 4586 | 76 |
1854925 | 1854925 | 2021-10-26 | Hickman | Tennessee | 47081 | 4586 | 75 |
1849253 | 1849253 | 2021-10-25 | Johnson | Arkansas | 5071 | 4586 | 57 |
1837524 | 1837524 | 2021-10-21 | Adams | Mississippi | 28001 | 4586 | 119 |
1810652 | 1810652 | 2021-10-13 | Unknown | Georgia | 4586 | 7 | |
1783926 | 1783926 | 2021-10-04 | Warren | Virginia | 51187 | 4586 | 74 |
1779727 | 1779727 | 2021-10-03 | Jackson | Ohio | 39079 | 4586 | 67 |
1765162 | 1765162 | 2021-09-29 | Unknown | Georgia | 4586 | 7 | |
1762501 | 1762501 | 2021-09-28 | Allen | Louisiana | 22003 | 4586 | 105 |
1697017 | 1697017 | 2021-09-08 | Christian | Illinois | 17021 | 4586 | 96 |
1677564 | 1677564 | 2021-09-02 | Logan | Illinois | 17107 | 4586 | 81 |
1677868 | 1677868 | 2021-09-02 | Montgomery | Kansas | 20125 | 4586 | 92 |
1674621 | 1674621 | 2021-09-01 | Montgomery | Kansas | 20125 | 4586 | 92 |
1671830 | 1671830 | 2021-08-31 | Alcorn | Mississippi | 28003 | 4586 | 80 |
1634281 | 1634281 | 2021-08-19 | Titus | Texas | 48449 | 4586 | 85 |
1618625 | 1618625 | 2021-08-15 | Union | Arkansas | 5139 | 4586 | 117 |
1604072 | 1604072 | 2021-08-10 | Livingston | New York | 36051 | 4586 | 60 |
1601614 | 1601614 | 2021-08-09 | Cherokee | Texas | 48073 | 4586 | 149 |
1598366 | 1598366 | 2021-08-08 | Cherokee | Texas | 48073 | 4586 | 149 |
1595117 | 1595117 | 2021-08-07 | Cherokee | Texas | 48073 | 4586 | 149 |
1591868 | 1591868 | 2021-08-06 | Cherokee | Texas | 48073 | 4586 | 149 |
1586625 | 1586625 | 2021-08-05 | Monroe | Illinois | 17133 | 4586 | 95 |
1581891 | 1581891 | 2021-08-03 | Dillon | South Carolina | 45033 | 4586 | 85 |
1576943 | 1576943 | 2021-08-02 | Harrison | Indiana | 18061 | 4586 | 79 |
1534632 | 1534632 | 2021-07-20 | Jefferson | Illinois | 17081 | 4586 | 124 |
1526120 | 1526120 | 2021-07-17 | Madison | New York | 36053 | 4586 | 89 |
1520487 | 1520487 | 2021-07-15 | Hill | Texas | 48217 | 4586 | 111 |
1510116 | 1510116 | 2021-07-12 | Knox | Ohio | 39083 | 4586 | 112 |
1485486 | 1485486 | 2021-07-05 | Humboldt | California | 6023 | 4586 | 50 |
1482240 | 1482240 | 2021-07-04 | Humboldt | California | 6023 | 4586 | 50 |
1478993 | 1478993 | 2021-07-03 | Humboldt | California | 6023 | 4586 | 50 |
1475747 | 1475747 | 2021-07-02 | Humboldt | California | 6023 | 4586 | 50 |
1415240 | 1415240 | 2021-06-13 | Itasca | Minnesota | 27061 | 4586 | 63 |
1385070 | 1385070 | 2021-06-04 | Baldwin | Georgia | 13009 | 4586 | 133 |
1361505 | 1361505 | 2021-05-27 | Nacogdoches | Texas | 48347 | 4586 | 171 |
1303257 | 1303257 | 2021-05-09 | James City | Virginia | 51095 | 4586 | 72 |
1278919 | 1278919 | 2021-05-02 | Mower | Minnesota | 27099 | 4586 | 32 |
1258313 | 1258313 | 2021-04-26 | Broomfield | Colorado | 8014 | 4586 | 75 |
1255066 | 1255066 | 2021-04-25 | Broomfield | Colorado | 8014 | 4586 | 75 |
1246540 | 1246540 | 2021-04-22 | Oktibbeha | Mississippi | 28105 | 4586 | 98 |
1232432 | 1232432 | 2021-04-18 | Hendry | Florida | 12051 | 4586 | 79 |
1217017 | 1217017 | 2021-04-13 | St. Mary | Louisiana | 22101 | 4586 | 133 |
1201655 | 1201655 | 2021-04-08 | Stark | North Dakota | 38089 | 4586 | 50 |
1183254 | 1183254 | 2021-04-02 | Putnam | West Virginia | 54079 | 4586 | 93 |
1155886 | 1155886 | 2021-03-25 | Scotts Bluff | Nebraska | 31157 | 4586 | 95 |
1130082 | 1130082 | 2021-03-17 | Carteret | North Carolina | 37031 | 4586 | 45 |
1126981 | 1126981 | 2021-03-16 | Auglaize | Ohio | 39011 | 4586 | 85 |
1078529 | 1078529 | 2021-03-01 | Mifflin | Pennsylvania | 42087 | 4586 | 167 |
1074583 | 1074583 | 2021-02-28 | Taney | Missouri | 29213 | 4586 | 88 |
1072900 | 1072900 | 2021-02-27 | Dunn | Wisconsin | 55033 | 4586 | 28 |
1067578 | 1067578 | 2021-02-26 | Nelson | Kentucky | 21179 | 4586 | 38 |
1068767 | 1068767 | 2021-02-26 | Columbia | Pennsylvania | 42037 | 4586 | 123 |
1033002 | 1033002 | 2021-02-15 | Stephens | Oklahoma | 40137 | 4586 | 58 |
1028277 | 1028277 | 2021-02-14 | Jackson | Indiana | 18071 | 4586 | 61 |
1030089 | 1030089 | 2021-02-14 | Fayette | Tennessee | 47047 | 4586 | 71 |
1004961 | 1004961 | 2021-02-07 | Hot Spring | Arkansas | 5059 | 4586 | 68 |
995031 | 995031 | 2021-02-03 | Oconto | Wisconsin | 55083 | 4586 | 54 |
969748 | 969748 | 2021-01-27 | Grundy | Illinois | 17063 | 4586 | 55 |
958699 | 958699 | 2021-01-23 | Hawkins | Tennessee | 47073 | 4586 | 72 |
925683 | 925683 | 2021-01-13 | Wilkes | North Carolina | 37193 | 4586 | 80 |
901723 | 901723 | 2021-01-06 | Morgan | Indiana | 18109 | 4586 | 87 |
886558 | 886558 | 2021-01-01 | Eddy | New Mexico | 35015 | 4586 | 73 |
858073 | 858073 | 2020-12-23 | Coffee | Tennessee | 47031 | 4586 | 61 |
846529 | 846529 | 2020-12-20 | Hancock | Indiana | 18059 | 4586 | 80 |
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);