ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 3698 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 13
- South Carolina 11
- Louisiana 9
- Missouri 9
- Ohio 9
- Oklahoma 8
- Arkansas 5
- Georgia 5
- Maryland 5
- Virginia 5
- Illinois 4
- Indiana 4
- Pennsylvania 4
- West Virginia 4
- Wisconsin 4
- Minnesota 3
- Mississippi 3
- Alabama 2
- Colorado 2
- Idaho 2
- Iowa 2
- Kansas 2
- Nebraska 2
- North Carolina 2
- Oregon 2
- Vermont 2
- Alaska 1
- Florida 1
- Kentucky 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501824 | 2501824 | 2022-05-13 | Hood River | Oregon | 41027 | 3698 | 44 |
2502253 | 2502253 | 2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 |
2498995 | 2498995 | 2022-05-12 | Comanche | Texas | 48093 | 3698 | 78 |
2495737 | 2495737 | 2022-05-11 | Comanche | Texas | 48093 | 3698 | 78 |
2496086 | 2496086 | 2022-05-11 | Patrick | Virginia | 51141 | 3698 | 98 |
2470192 | 2470192 | 2022-05-03 | Lafayette | Wisconsin | 55065 | 3698 | 24 |
2313550 | 2313550 | 2022-03-16 | Leon | Texas | 48289 | 3698 | 91 |
2313559 | 2313559 | 2022-03-16 | Madison | Texas | 48313 | 3698 | 53 |
2310297 | 2310297 | 2022-03-15 | Leon | Texas | 48289 | 3698 | 91 |
2310306 | 2310306 | 2022-03-15 | Madison | Texas | 48313 | 3698 | 53 |
2237491 | 2237491 | 2022-02-21 | Bates | Missouri | 29013 | 3698 | 80 |
2234240 | 2234240 | 2022-02-20 | Bates | Missouri | 29013 | 3698 | 80 |
2230989 | 2230989 | 2022-02-19 | Bates | Missouri | 29013 | 3698 | 80 |
2227738 | 2227738 | 2022-02-18 | Bates | Missouri | 29013 | 3698 | 80 |
2190186 | 2190186 | 2022-02-06 | Greene | Virginia | 51079 | 3698 | 52 |
2186933 | 2186933 | 2022-02-05 | Greene | Virginia | 51079 | 3698 | 52 |
2183680 | 2183680 | 2022-02-04 | Greene | Virginia | 51079 | 3698 | 52 |
2180186 | 2180186 | 2022-02-03 | Houston | Texas | 48225 | 3698 | 98 |
2164093 | 2164093 | 2022-01-29 | Addison | Vermont | 50001 | 3698 | 13 |
2150614 | 2150614 | 2022-01-25 | Lee | South Carolina | 45061 | 3698 | 85 |
2147362 | 2147362 | 2022-01-24 | Lee | South Carolina | 45061 | 3698 | 85 |
2144108 | 2144108 | 2022-01-23 | Lee | South Carolina | 45061 | 3698 | 85 |
2140853 | 2140853 | 2022-01-22 | Lee | South Carolina | 45061 | 3698 | 85 |
2137597 | 2137597 | 2022-01-21 | Lee | South Carolina | 45061 | 3698 | 85 |
2104234 | 2104234 | 2022-01-11 | Texas | Missouri | 29215 | 3698 | 76 |
2092743 | 2092743 | 2022-01-07 | Lincoln | West Virginia | 54043 | 3698 | 58 |
2080542 | 2080542 | 2022-01-04 | Pike | Illinois | 17149 | 3698 | 61 |
2037578 | 2037578 | 2021-12-21 | Taylor | Wisconsin | 55119 | 3698 | 60 |
2033996 | 2033996 | 2021-12-20 | Carbon | Utah | 49007 | 3698 | 41 |
2034120 | 2034120 | 2021-12-20 | Mecklenburg | Virginia | 51117 | 3698 | 94 |
1981174 | 1981174 | 2021-12-04 | Carroll | Ohio | 39019 | 3698 | 78 |
1960725 | 1960725 | 2021-11-28 | Assumption | Louisiana | 22007 | 3698 | 57 |
1957474 | 1957474 | 2021-11-27 | Assumption | Louisiana | 22007 | 3698 | 57 |
1954223 | 1954223 | 2021-11-26 | Assumption | Louisiana | 22007 | 3698 | 57 |
1950972 | 1950972 | 2021-11-25 | Assumption | Louisiana | 22007 | 3698 | 57 |
1947721 | 1947721 | 2021-11-24 | Assumption | Louisiana | 22007 | 3698 | 57 |
1944470 | 1944470 | 2021-11-23 | Assumption | Louisiana | 22007 | 3698 | 57 |
1942914 | 1942914 | 2021-11-22 | Reeves | Texas | 48389 | 3698 | 57 |
1939664 | 1939664 | 2021-11-21 | Reeves | Texas | 48389 | 3698 | 57 |
1936414 | 1936414 | 2021-11-20 | Reeves | Texas | 48389 | 3698 | 57 |
1909119 | 1909119 | 2021-11-12 | Crawford | Missouri | 29055 | 3698 | 61 |
1791199 | 1791199 | 2021-10-07 | Elmore | Idaho | 16039 | 3698 | 38 |
1787780 | 1787780 | 2021-10-06 | Burke | Georgia | 13033 | 3698 | 76 |
1768620 | 1768620 | 2021-09-30 | Jennings | Indiana | 18079 | 3698 | 59 |
1769964 | 1769964 | 2021-09-30 | Gallia | Ohio | 39053 | 3698 | 58 |
1765131 | 1765131 | 2021-09-29 | Pike | Georgia | 13231 | 3698 | 63 |
1764491 | 1764491 | 2021-09-28 | Hancock | West Virginia | 54029 | 3698 | 97 |
1756025 | 1756025 | 2021-09-26 | Grant | Louisiana | 22043 | 3698 | 76 |
1752777 | 1752777 | 2021-09-25 | Grant | Louisiana | 22043 | 3698 | 76 |
1749528 | 1749528 | 2021-09-24 | Grant | Louisiana | 22043 | 3698 | 76 |
1734581 | 1734581 | 2021-09-19 | Jasper | South Carolina | 45053 | 3698 | 64 |
1731331 | 1731331 | 2021-09-18 | Jasper | South Carolina | 45053 | 3698 | 64 |
1728081 | 1728081 | 2021-09-17 | Jasper | South Carolina | 45053 | 3698 | 64 |
1722268 | 1722268 | 2021-09-15 | Mingo | West Virginia | 54059 | 3698 | 50 |
1717277 | 1717277 | 2021-09-14 | Pine | Minnesota | 27115 | 3698 | 26 |
1645865 | 1645865 | 2021-08-23 | George | Mississippi | 28039 | 3698 | 58 |
1641300 | 1641300 | 2021-08-22 | Carroll | Arkansas | 5015 | 3698 | 56 |
1643254 | 1643254 | 2021-08-22 | Champaign | Ohio | 39021 | 3698 | 60 |
1631998 | 1631998 | 2021-08-19 | Bonner | Idaho | 16017 | 3698 | 47 |
1610847 | 1610847 | 2021-08-12 | Williams | Ohio | 39171 | 3698 | 78 |
1604652 | 1604652 | 2021-08-10 | Marlboro | South Carolina | 45069 | 3698 | 61 |
1566071 | 1566071 | 2021-07-29 | Upshur | Texas | 48459 | 3698 | 78 |
1536310 | 1536310 | 2021-07-20 | Snyder | Pennsylvania | 42109 | 3698 | 86 |
1516405 | 1516405 | 2021-07-14 | Warren | New York | 36113 | 3698 | 59 |
1476776 | 1476776 | 2021-07-02 | Worcester | Maryland | 24047 | 3698 | 106 |
1473530 | 1473530 | 2021-07-01 | Worcester | Maryland | 24047 | 3698 | 106 |
1470284 | 1470284 | 2021-06-30 | Worcester | Maryland | 24047 | 3698 | 106 |
1470610 | 1470610 | 2021-06-30 | Lawrence | Missouri | 29109 | 3698 | 87 |
1467039 | 1467039 | 2021-06-29 | Worcester | Maryland | 24047 | 3698 | 106 |
1463794 | 1463794 | 2021-06-28 | Worcester | Maryland | 24047 | 3698 | 106 |
1452748 | 1452748 | 2021-06-24 | Clark | Wisconsin | 55019 | 3698 | 65 |
1448770 | 1448770 | 2021-06-23 | Colleton | South Carolina | 45029 | 3698 | 131 |
1403181 | 1403181 | 2021-06-09 | Clinton | Pennsylvania | 42035 | 3698 | 66 |
1365607 | 1365607 | 2021-05-29 | Bryan | Georgia | 13029 | 3698 | 41 |
1334855 | 1334855 | 2021-05-19 | Ottawa | Ohio | 39123 | 3698 | 81 |
1294079 | 1294079 | 2021-05-07 | Summit | Colorado | 8117 | 3698 | 7 |
1286110 | 1286110 | 2021-05-04 | Clinton | Ohio | 39027 | 3698 | 61 |
1255468 | 1255468 | 2021-04-25 | Logan | Illinois | 17107 | 3698 | 69 |
1240784 | 1240784 | 2021-04-20 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1237537 | 1237537 | 2021-04-19 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1234290 | 1234290 | 2021-04-18 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1231042 | 1231042 | 2021-04-17 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1227717 | 1227717 | 2021-04-16 | Preble | Ohio | 39135 | 3698 | 98 |
1227794 | 1227794 | 2021-04-16 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1224546 | 1224546 | 2021-04-15 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1221299 | 1221299 | 2021-04-14 | Okmulgee | Oklahoma | 40111 | 3698 | 77 |
1211076 | 1211076 | 2021-04-11 | Lincoln | Nebraska | 31111 | 3698 | 53 |
1203608 | 1203608 | 2021-04-09 | Miami | Indiana | 18103 | 3698 | 66 |
1190596 | 1190596 | 2021-04-05 | Huntington | Indiana | 18069 | 3698 | 82 |
1187983 | 1187983 | 2021-04-04 | McLeod | Minnesota | 27085 | 3698 | 54 |
1184736 | 1184736 | 2021-04-03 | McLeod | Minnesota | 27085 | 3698 | 54 |
1131552 | 1131552 | 2021-03-18 | Independence | Arkansas | 5063 | 3698 | 120 |
1121785 | 1121785 | 2021-03-15 | Boone | Arkansas | 5009 | 3698 | 78 |
1118538 | 1118538 | 2021-03-14 | Boone | Arkansas | 5009 | 3698 | 78 |
1115291 | 1115291 | 2021-03-13 | Boone | Arkansas | 5009 | 3698 | 78 |
1118308 | 1118308 | 2021-03-13 | Ohio | West Virginia | 54069 | 3698 | 75 |
1109605 | 1109605 | 2021-03-11 | Ellis | Kansas | 20051 | 3698 | 61 |
1106359 | 1106359 | 2021-03-10 | Ellis | Kansas | 20051 | 3698 | 61 |
1107440 | 1107440 | 2021-03-10 | Yadkin | North Carolina | 37197 | 3698 | 46 |
1103062 | 1103062 | 2021-03-09 | Plymouth | Iowa | 19149 | 3698 | 78 |
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);