ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 4502 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 11
- California 10
- Oklahoma 8
- Wyoming 7
- Mississippi 6
- Texas 6
- Illinois 5
- Missouri 5
- Arkansas 4
- Indiana 4
- Kansas 3
- Ohio 3
- Puerto Rico 3
- Alabama 2
- Florida 2
- Iowa 2
- Michigan 2
- New York 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- Tennessee 2
- Wisconsin 2
- Georgia 1
- Kentucky 1
- Nevada 1
- New Mexico 1
- North Carolina 1
- South Dakota 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358684 | 2358684 | 2022-03-30 | Fajardo | Puerto Rico | 72053 | 4502 | |
2332611 | 2332611 | 2022-03-22 | Montour | Pennsylvania | 42093 | 4502 | 92 |
2265446 | 2265446 | 2022-03-02 | Inyo | California | 6027 | 4502 | 56 |
2262195 | 2262195 | 2022-03-01 | Inyo | California | 6027 | 4502 | 56 |
2258944 | 2258944 | 2022-02-28 | Inyo | California | 6027 | 4502 | 56 |
2261107 | 2261107 | 2022-02-28 | Guayama | Puerto Rico | 72057 | 4502 | |
2251815 | 2251815 | 2022-02-25 | Robertson | Texas | 48395 | 4502 | 73 |
2219493 | 2219493 | 2022-02-15 | New Kent | Virginia | 51127 | 4502 | 30 |
2210155 | 2210155 | 2022-02-13 | Sharp | Arkansas | 5135 | 4502 | 91 |
2186772 | 2186772 | 2022-02-05 | Reeves | Texas | 48389 | 4502 | 69 |
2169188 | 2169188 | 2022-01-31 | Andrew | Missouri | 29003 | 4502 | 45 |
2124904 | 2124904 | 2022-01-17 | Lampasas | Texas | 48281 | 4502 | 72 |
2121932 | 2121932 | 2022-01-16 | Staunton city | Virginia | 51790 | 4502 | 89 |
2118680 | 2118680 | 2022-01-15 | Staunton city | Virginia | 51790 | 4502 | 89 |
2115428 | 2115428 | 2022-01-14 | Staunton city | Virginia | 51790 | 4502 | 89 |
2012356 | 2012356 | 2021-12-14 | LaGrange | Indiana | 18087 | 4502 | 94 |
2010592 | 2010592 | 2021-12-13 | Columbia | Oregon | 41009 | 4502 | 59 |
1973909 | 1973909 | 2021-12-02 | Oceana | Michigan | 26127 | 4502 | 75 |
1970660 | 1970660 | 2021-12-01 | Oceana | Michigan | 26127 | 4502 | 75 |
1924575 | 1924575 | 2021-11-17 | Greene | Indiana | 18055 | 4502 | 102 |
1898043 | 1898043 | 2021-11-09 | Glenn | California | 6021 | 4502 | 46 |
1896075 | 1896075 | 2021-11-08 | Simpson | Mississippi | 28127 | 4502 | 116 |
1876962 | 1876962 | 2021-11-02 | Franklin | New York | 36033 | 4502 | 24 |
1873280 | 1873280 | 2021-11-01 | Copiah | Mississippi | 28029 | 4502 | 92 |
1836174 | 1836174 | 2021-10-21 | Winston | Alabama | 1133 | 4502 | 103 |
1822143 | 1822143 | 2021-10-16 | Clarion | Pennsylvania | 42031 | 4502 | 118 |
1794016 | 1794016 | 2021-10-08 | Johnson | Arkansas | 5071 | 4502 | 57 |
1789140 | 1789140 | 2021-10-06 | Douglas | Nevada | 32005 | 4502 | 51 |
1779069 | 1779069 | 2021-10-03 | Itawamba | Mississippi | 28057 | 4502 | 102 |
1775819 | 1775819 | 2021-10-02 | Itawamba | Mississippi | 28057 | 4502 | 102 |
1772569 | 1772569 | 2021-10-01 | Itawamba | Mississippi | 28057 | 4502 | 102 |
1764813 | 1764813 | 2021-09-29 | Yell | Arkansas | 5149 | 4502 | 76 |
1758123 | 1758123 | 2021-09-26 | Sheridan | Wyoming | 56033 | 4502 | 39 |
1754035 | 1754035 | 2021-09-25 | Trujillo Alto | Puerto Rico | 72139 | 4502 | |
1754875 | 1754875 | 2021-09-25 | Sheridan | Wyoming | 56033 | 4502 | 39 |
1751627 | 1751627 | 2021-09-24 | Sheridan | Wyoming | 56033 | 4502 | 39 |
1732010 | 1732010 | 2021-09-18 | Logan | West Virginia | 54045 | 4502 | 112 |
1727729 | 1727729 | 2021-09-17 | Guernsey | Ohio | 39059 | 4502 | 61 |
1709565 | 1709565 | 2021-09-12 | Poinsett | Arkansas | 5111 | 4502 | 94 |
1693154 | 1693154 | 2021-09-06 | Teton | Wyoming | 56039 | 4502 | 11 |
1689905 | 1689905 | 2021-09-05 | Teton | Wyoming | 56039 | 4502 | 11 |
1686655 | 1686655 | 2021-09-04 | Teton | Wyoming | 56039 | 4502 | 11 |
1683405 | 1683405 | 2021-09-03 | Teton | Wyoming | 56039 | 4502 | 11 |
1678864 | 1678864 | 2021-09-02 | Jackson | North Carolina | 37099 | 4502 | 59 |
1664574 | 1664574 | 2021-08-29 | Logan | Illinois | 17107 | 4502 | 81 |
1666922 | 1666922 | 2021-08-29 | Manassas city | Virginia | 51683 | 4502 | 49 |
1661326 | 1661326 | 2021-08-28 | Logan | Illinois | 17107 | 4502 | 81 |
1663674 | 1663674 | 2021-08-28 | Manassas city | Virginia | 51683 | 4502 | 49 |
1658078 | 1658078 | 2021-08-27 | Logan | Illinois | 17107 | 4502 | 81 |
1660426 | 1660426 | 2021-08-27 | Manassas city | Virginia | 51683 | 4502 | 49 |
1633893 | 1633893 | 2021-08-19 | Williamsburg | South Carolina | 45089 | 4502 | 107 |
1604283 | 1604283 | 2021-08-10 | Defiance | Ohio | 39039 | 4502 | 99 |
1584818 | 1584818 | 2021-08-04 | Madison | Ohio | 39097 | 4502 | 66 |
1540506 | 1540506 | 2021-07-22 | Covington | Alabama | 1039 | 4502 | 125 |
1530953 | 1530953 | 2021-07-19 | Mendocino | California | 6045 | 4502 | 50 |
1527706 | 1527706 | 2021-07-18 | Mendocino | California | 6045 | 4502 | 50 |
1524459 | 1524459 | 2021-07-17 | Mendocino | California | 6045 | 4502 | 50 |
1521211 | 1521211 | 2021-07-16 | Mendocino | California | 6045 | 4502 | 50 |
1514218 | 1514218 | 2021-07-13 | Danville city | Virginia | 51590 | 4502 | 142 |
1497987 | 1497987 | 2021-07-08 | Danville city | Virginia | 51590 | 4502 | 141 |
1494740 | 1494740 | 2021-07-07 | Danville city | Virginia | 51590 | 4502 | 141 |
1341099 | 1341099 | 2021-05-21 | Madison | New York | 36053 | 4502 | 88 |
1320802 | 1320802 | 2021-05-15 | Hopkins | Kentucky | 21107 | 4502 | 147 |
1315985 | 1315985 | 2021-05-13 | Hill | Texas | 48217 | 4502 | 108 |
1312739 | 1312739 | 2021-05-12 | Hill | Texas | 48217 | 4502 | 108 |
1309492 | 1309492 | 2021-05-11 | Hill | Texas | 48217 | 4502 | 108 |
1281614 | 1281614 | 2021-05-03 | Des Moines | Iowa | 19057 | 4502 | 66 |
1283775 | 1283775 | 2021-05-03 | Henry | Virginia | 51089 | 4502 | 121 |
1271444 | 1271444 | 2021-04-30 | Baldwin | Georgia | 13009 | 4502 | 128 |
1244301 | 1244301 | 2021-04-21 | Codington | South Dakota | 46029 | 4502 | 81 |
1241172 | 1241172 | 2021-04-20 | Obion | Tennessee | 47131 | 4502 | 96 |
1237925 | 1237925 | 2021-04-19 | Obion | Tennessee | 47131 | 4502 | 96 |
1197221 | 1197221 | 2021-04-07 | Muscatine | Iowa | 19139 | 4502 | 96 |
1177526 | 1177526 | 2021-04-01 | Macoupin | Illinois | 17117 | 4502 | 110 |
1172546 | 1172546 | 2021-03-30 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1169299 | 1169299 | 2021-03-29 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1166051 | 1166051 | 2021-03-28 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1162803 | 1162803 | 2021-03-27 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1159554 | 1159554 | 2021-03-26 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1156307 | 1156307 | 2021-03-25 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1157337 | 1157337 | 2021-03-25 | Pierce | Wisconsin | 55093 | 4502 | 41 |
1153060 | 1153060 | 2021-03-24 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1149111 | 1149111 | 2021-03-23 | Oktibbeha | Mississippi | 28105 | 4502 | 97 |
1090716 | 1090716 | 2021-03-05 | Callaway | Missouri | 29027 | 4502 | 45 |
1086586 | 1086586 | 2021-03-04 | Effingham | Illinois | 17049 | 4502 | 80 |
1087471 | 1087471 | 2021-03-04 | Callaway | Missouri | 29027 | 4502 | 45 |
1073892 | 1073892 | 2021-02-28 | Crawford | Kansas | 20037 | 4502 | 80 |
1070646 | 1070646 | 2021-02-27 | Crawford | Kansas | 20037 | 4502 | 80 |
1067401 | 1067401 | 2021-02-26 | Crawford | Kansas | 20037 | 4502 | 80 |
1040185 | 1040185 | 2021-02-17 | Chittenden | Vermont | 50007 | 4502 | 82 |
1023270 | 1023270 | 2021-02-12 | Washington | Oklahoma | 40147 | 4502 | 79 |
1019408 | 1019408 | 2021-02-11 | Taney | Missouri | 29213 | 4502 | 77 |
1008806 | 1008806 | 2021-02-08 | Jackson | Indiana | 18071 | 4502 | 60 |
903403 | 903403 | 2021-01-06 | Greenwood | South Carolina | 45047 | 4502 | 98 |
872110 | 872110 | 2020-12-28 | Jackson | Florida | 12063 | 4502 | 115 |
835875 | 835875 | 2020-12-16 | Chelan | Washington | 53007 | 4502 | 33 |
810330 | 810330 | 2020-12-09 | Sutter | California | 6101 | 4502 | 30 |
811607 | 811607 | 2020-12-09 | Cass | Missouri | 29037 | 4502 | 43 |
792877 | 792877 | 2020-12-03 | Umatilla | Oregon | 41059 | 4502 | 50 |
767821 | 767821 | 2020-11-25 | Chippewa | Wisconsin | 55017 | 4502 | 50 |
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);