ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4807 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 10
- Kansas 9
- Georgia 7
- Mississippi 7
- Virginia 7
- Ohio 6
- Arkansas 5
- Colorado 5
- New York 5
- Texas 4
- West Virginia 4
- Alabama 3
- Indiana 3
- Missouri 3
- Pennsylvania 3
- Wisconsin 3
- California 2
- Idaho 2
- Illinois 2
- Louisiana 2
- Michigan 2
- Tennessee 2
- Florida 1
- New Hampshire 1
- New Mexico 1
- North Carolina 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497235 | 2497235 | 2022-05-12 | Dickinson | Kansas | 20041 | 4807 | 78 |
2493977 | 2493977 | 2022-05-11 | Dickinson | Kansas | 20041 | 4807 | 78 |
2490719 | 2490719 | 2022-05-10 | Dickinson | Kansas | 20041 | 4807 | 78 |
2487462 | 2487462 | 2022-05-09 | Dickinson | Kansas | 20041 | 4807 | 78 |
2484204 | 2484204 | 2022-05-08 | Dickinson | Kansas | 20041 | 4807 | 78 |
2484341 | 2484341 | 2022-05-08 | Henry | Kentucky | 21103 | 4807 | 52 |
2480946 | 2480946 | 2022-05-07 | Dickinson | Kansas | 20041 | 4807 | 78 |
2481083 | 2481083 | 2022-05-07 | Henry | Kentucky | 21103 | 4807 | 52 |
2477688 | 2477688 | 2022-05-06 | Dickinson | Kansas | 20041 | 4807 | 78 |
2477825 | 2477825 | 2022-05-06 | Henry | Kentucky | 21103 | 4807 | 52 |
2474567 | 2474567 | 2022-05-05 | Henry | Kentucky | 21103 | 4807 | 52 |
2471310 | 2471310 | 2022-05-04 | Henry | Kentucky | 21103 | 4807 | 52 |
2468054 | 2468054 | 2022-05-03 | Henry | Kentucky | 21103 | 4807 | 52 |
2464799 | 2464799 | 2022-05-02 | Henry | Kentucky | 21103 | 4807 | 52 |
2427363 | 2427363 | 2022-04-20 | Deaf Smith | Texas | 48117 | 4807 | 112 |
2424107 | 2424107 | 2022-04-19 | Deaf Smith | Texas | 48117 | 4807 | 112 |
2392420 | 2392420 | 2022-04-10 | Teller | Colorado | 8119 | 4807 | 57 |
2389164 | 2389164 | 2022-04-09 | Teller | Colorado | 8119 | 4807 | 57 |
2385909 | 2385909 | 2022-04-08 | Teller | Colorado | 8119 | 4807 | 57 |
2314159 | 2314159 | 2022-03-17 | Cross | Arkansas | 5037 | 4807 | 79 |
2310906 | 2310906 | 2022-03-16 | Cross | Arkansas | 5037 | 4807 | 79 |
2294185 | 2294185 | 2022-03-10 | Orange | Vermont | 50017 | 4807 | 14 |
2255968 | 2255968 | 2022-02-27 | Lamar | Georgia | 13171 | 4807 | 110 |
2252717 | 2252717 | 2022-02-26 | Lamar | Georgia | 13171 | 4807 | 110 |
2249466 | 2249466 | 2022-02-25 | Lamar | Georgia | 13171 | 4807 | 110 |
2245520 | 2245520 | 2022-02-23 | Radford city | Virginia | 51750 | 4807 | 46 |
2240816 | 2240816 | 2022-02-22 | Perry | Missouri | 29157 | 4807 | 44 |
2220474 | 2220474 | 2022-02-16 | Jay | Indiana | 18075 | 4807 | 76 |
2190326 | 2190326 | 2022-02-06 | Lewis | West Virginia | 54041 | 4807 | 75 |
2177596 | 2177596 | 2022-02-03 | Lawrence | Arkansas | 5075 | 4807 | 66 |
2122900 | 2122900 | 2022-01-17 | Owen | Indiana | 18119 | 4807 | 101 |
2110250 | 2110250 | 2022-01-13 | Woodford | Kentucky | 21239 | 4807 | 38 |
2076874 | 2076874 | 2022-01-03 | Delta | Colorado | 8029 | 4807 | 123 |
2006590 | 2006590 | 2021-12-12 | Tate | Mississippi | 28137 | 4807 | 118 |
2003339 | 2003339 | 2021-12-11 | Tate | Mississippi | 28137 | 4807 | 118 |
2000089 | 2000089 | 2021-12-10 | Tate | Mississippi | 28137 | 4807 | 118 |
1971942 | 1971942 | 2021-12-01 | McNairy | Tennessee | 47109 | 4807 | 73 |
1967894 | 1967894 | 2021-11-30 | Sullivan | New Hampshire | 33019 | 4807 | 40 |
1946535 | 1946535 | 2021-11-23 | Lincoln | Wisconsin | 55069 | 4807 | 113 |
1940546 | 1940546 | 2021-11-22 | Gilmer | Georgia | 13123 | 4807 | 137 |
1918481 | 1918481 | 2021-11-15 | De Soto | Louisiana | 22031 | 4807 | 112 |
1878631 | 1878631 | 2021-11-03 | Logan | Colorado | 8075 | 4807 | 84 |
1880667 | 1880667 | 2021-11-03 | Snyder | Pennsylvania | 42109 | 4807 | 104 |
1859371 | 1859371 | 2021-10-28 | Stephens | Georgia | 13257 | 4807 | 109 |
1852534 | 1852534 | 2021-10-26 | St. Francis | Arkansas | 5123 | 4807 | 67 |
1849285 | 1849285 | 2021-10-25 | St. Francis | Arkansas | 5123 | 4807 | 67 |
1839219 | 1839219 | 2021-10-21 | Greenbrier | West Virginia | 54025 | 4807 | 90 |
1831733 | 1831733 | 2021-10-19 | Ottawa | Ohio | 39123 | 4807 | 86 |
1826906 | 1826906 | 2021-10-18 | White | Georgia | 13311 | 4807 | 122 |
1826163 | 1826163 | 2021-10-17 | Warren | Virginia | 51187 | 4807 | 79 |
1822914 | 1822914 | 2021-10-16 | Warren | Virginia | 51187 | 4807 | 79 |
1819665 | 1819665 | 2021-10-15 | Warren | Virginia | 51187 | 4807 | 79 |
1802265 | 1802265 | 2021-10-10 | Tioga | New York | 36107 | 4807 | 70 |
1797142 | 1797142 | 2021-10-09 | Dallas | Alabama | 1047 | 4807 | 195 |
1779060 | 1779060 | 2021-10-03 | George | Mississippi | 28039 | 4807 | 76 |
1775810 | 1775810 | 2021-10-02 | George | Mississippi | 28039 | 4807 | 76 |
1772560 | 1772560 | 2021-10-01 | George | Mississippi | 28039 | 4807 | 76 |
1770480 | 1770480 | 2021-09-30 | Scott | Tennessee | 47151 | 4807 | 54 |
1722189 | 1722189 | 2021-09-15 | Tazewell | Virginia | 51185 | 4807 | 83 |
1676918 | 1676918 | 2021-09-02 | Chambers | Alabama | 1017 | 4807 | 127 |
1672890 | 1672890 | 2021-08-31 | Codington | South Dakota | 46029 | 4807 | 82 |
1649577 | 1649577 | 2021-08-24 | Tompkins | New York | 36109 | 4807 | 55 |
1601222 | 1601222 | 2021-08-09 | Bedford | Pennsylvania | 42009 | 4807 | 142 |
1535502 | 1535502 | 2021-07-20 | Camden | Missouri | 29029 | 4807 | 97 |
1498145 | 1498145 | 2021-07-08 | Jefferson | West Virginia | 54037 | 4807 | 59 |
1491651 | 1491651 | 2021-07-06 | Jefferson | West Virginia | 54037 | 4807 | 59 |
1464829 | 1464829 | 2021-06-28 | Yamhill | Oregon | 41071 | 4807 | 79 |
1385781 | 1385781 | 2021-06-04 | Shelby | Kentucky | 21211 | 4807 | 78 |
1376485 | 1376485 | 2021-06-01 | Johnson | Missouri | 29101 | 4807 | 56 |
1362171 | 1362171 | 2021-05-28 | Nevada | California | 6057 | 4807 | 75 |
1341628 | 1341628 | 2021-05-21 | Toa Baja | Puerto Rico | 72137 | 4807 | |
1330906 | 1330906 | 2021-05-18 | Bolivar | Mississippi | 28011 | 4807 | 132 |
1324848 | 1324848 | 2021-05-16 | Clinton | New York | 36019 | 4807 | 33 |
1274319 | 1274319 | 2021-05-01 | Dale | Alabama | 1045 | 4807 | 111 |
1270527 | 1270527 | 2021-04-29 | Harrison | Texas | 48203 | 4807 | 107 |
1248882 | 1248882 | 2021-04-23 | Bingham | Idaho | 16011 | 4807 | 73 |
1245635 | 1245635 | 2021-04-22 | Bingham | Idaho | 16011 | 4807 | 73 |
1239684 | 1239684 | 2021-04-20 | Scott | Kentucky | 21209 | 4807 | 32 |
1193635 | 1193635 | 2021-04-06 | Tift | Georgia | 13277 | 4807 | 123 |
1189780 | 1189780 | 2021-04-04 | Dunn | Wisconsin | 55033 | 4807 | 31 |
1123803 | 1123803 | 2021-03-15 | Seneca | Ohio | 39147 | 4807 | 114 |
1110828 | 1110828 | 2021-03-11 | Washington | Ohio | 39167 | 4807 | 97 |
1081568 | 1081568 | 2021-03-02 | Huron | Ohio | 39077 | 4807 | 107 |
1069412 | 1069412 | 2021-02-26 | Albemarle | Virginia | 51003 | 4807 | 54 |
1054765 | 1054765 | 2021-02-22 | Chippewa | Michigan | 26033 | 4807 | 42 |
1036295 | 1036295 | 2021-02-16 | Armstrong | Pennsylvania | 42005 | 4807 | 115 |
1032852 | 1032852 | 2021-02-15 | Belmont | Ohio | 39013 | 4807 | 83 |
1019748 | 1019748 | 2021-02-11 | Halifax | North Carolina | 37083 | 4807 | 91 |
1008699 | 1008699 | 2021-02-08 | Grundy | Illinois | 17063 | 4807 | 62 |
1000958 | 1000958 | 2021-02-05 | Atascosa | Texas | 48013 | 4807 | 116 |
994770 | 994770 | 2021-02-03 | Augusta | Virginia | 51015 | 4807 | 48 |
986015 | 986015 | 2021-02-01 | Ogle | Illinois | 17141 | 4807 | 75 |
984202 | 984202 | 2021-01-31 | Lawrence | Ohio | 39087 | 4807 | 61 |
919043 | 919043 | 2021-01-11 | Chautauqua | New York | 36013 | 4807 | 38 |
898429 | 898429 | 2021-01-05 | Boone | Indiana | 18011 | 4807 | 68 |
876278 | 876278 | 2020-12-29 | Ionia | Michigan | 26067 | 4807 | 46 |
845710 | 845710 | 2020-12-19 | Calumet | Wisconsin | 55015 | 4807 | 32 |
807770 | 807770 | 2020-12-08 | Ford | Kansas | 20057 | 4807 | 10 |
804525 | 804525 | 2020-12-07 | Ford | Kansas | 20057 | 4807 | 10 |
750268 | 750268 | 2020-11-20 | San Juan | New Mexico | 35045 | 4807 | 211 |
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);