ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 3867 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 9
- Minnesota 9
- Kentucky 8
- Texas 8
- Tennessee 7
- Georgia 5
- Indiana 5
- Iowa 5
- North Carolina 5
- Pennsylvania 5
- Utah 5
- Virginia 5
- Arkansas 4
- Nebraska 4
- Kansas 3
- Mississippi 3
- Oregon 3
- Louisiana 2
- Missouri 2
- New York 2
- Ohio 2
- South Carolina 2
- Alabama 1
- California 1
- Colorado 1
- Florida 1
- Idaho 1
- Maryland 1
- Montana 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2438715 | 2438715 | 2022-04-24 | Butler | Kentucky | 21031 | 3867 | 54 |
2435459 | 2435459 | 2022-04-23 | Butler | Kentucky | 21031 | 3867 | 54 |
2432203 | 2432203 | 2022-04-22 | Butler | Kentucky | 21031 | 3867 | 54 |
2428947 | 2428947 | 2022-04-21 | Butler | Kentucky | 21031 | 3867 | 54 |
2430640 | 2430640 | 2022-04-21 | Freestone | Texas | 48161 | 3867 | 82 |
2425691 | 2425691 | 2022-04-20 | Butler | Kentucky | 21031 | 3867 | 54 |
2422435 | 2422435 | 2022-04-19 | Butler | Kentucky | 21031 | 3867 | 54 |
2419179 | 2419179 | 2022-04-18 | Butler | Kentucky | 21031 | 3867 | 54 |
2268653 | 2268653 | 2022-03-03 | Madison | Arkansas | 5087 | 3867 | 59 |
2256432 | 2256432 | 2022-02-27 | Jackson | Kansas | 20085 | 3867 | 27 |
2253181 | 2253181 | 2022-02-26 | Jackson | Kansas | 20085 | 3867 | 27 |
2249930 | 2249930 | 2022-02-25 | Jackson | Kansas | 20085 | 3867 | 27 |
2244826 | 2244826 | 2022-02-23 | Aguas Buenas | Puerto Rico | 72007 | 3867 | |
2236383 | 2236383 | 2022-02-21 | Banks | Georgia | 13011 | 3867 | 79 |
2194355 | 2194355 | 2022-02-08 | Jo Daviess | Illinois | 17085 | 3867 | 36 |
2166433 | 2166433 | 2022-01-30 | Warren | North Carolina | 37185 | 3867 | 37 |
2163178 | 2163178 | 2022-01-29 | Warren | North Carolina | 37185 | 3867 | 37 |
2159923 | 2159923 | 2022-01-28 | Warren | North Carolina | 37185 | 3867 | 37 |
2076052 | 2076052 | 2022-01-02 | Dimmit | Texas | 48127 | 3867 | 47 |
2072801 | 2072801 | 2022-01-01 | Dimmit | Texas | 48127 | 3867 | 47 |
2069550 | 2069550 | 2021-12-31 | Dimmit | Texas | 48127 | 3867 | 47 |
2066299 | 2066299 | 2021-12-30 | Dimmit | Texas | 48127 | 3867 | 47 |
2035800 | 2035800 | 2021-12-21 | Grenada | Mississippi | 28043 | 3867 | 111 |
2003928 | 2003928 | 2021-12-11 | Carroll | Ohio | 39019 | 3867 | 80 |
1997909 | 1997909 | 2021-12-09 | Fentress | Tennessee | 47049 | 3867 | 72 |
1994658 | 1994658 | 2021-12-08 | Fentress | Tennessee | 47049 | 3867 | 72 |
1943091 | 1943091 | 2021-11-22 | Lee | Virginia | 51105 | 3867 | 62 |
1926743 | 1926743 | 2021-11-17 | Sevier | Utah | 49041 | 3867 | 18 |
1923160 | 1923160 | 2021-11-16 | Haywood | Tennessee | 47075 | 3867 | 77 |
1923493 | 1923493 | 2021-11-16 | Sevier | Utah | 49041 | 3867 | 18 |
1919938 | 1919938 | 2021-11-15 | Morgan | Tennessee | 47129 | 3867 | 49 |
1914757 | 1914757 | 2021-11-14 | McDonough | Illinois | 17109 | 3867 | 78 |
1911507 | 1911507 | 2021-11-13 | McDonough | Illinois | 17109 | 3867 | 78 |
1908258 | 1908258 | 2021-11-12 | McDonough | Illinois | 17109 | 3867 | 78 |
1910516 | 1910516 | 2021-11-12 | Washington | Vermont | 50023 | 3867 | 28 |
1887169 | 1887169 | 2021-11-05 | Susquehanna | Pennsylvania | 42115 | 3867 | 68 |
1878075 | 1878075 | 2021-11-02 | Gloucester | Virginia | 51073 | 3867 | 76 |
1850328 | 1850328 | 2021-10-25 | Queen Anne's | Maryland | 24035 | 3867 | 71 |
1846033 | 1846033 | 2021-10-24 | Sevier | Arkansas | 5133 | 3867 | 50 |
1832032 | 1832032 | 2021-10-19 | Barnwell | South Carolina | 45011 | 3867 | 82 |
1827999 | 1827999 | 2021-10-18 | Lake | Montana | 30047 | 3867 | 58 |
1823689 | 1823689 | 2021-10-17 | Elmore | Idaho | 16039 | 3867 | 42 |
1788710 | 1788710 | 2021-10-06 | Cass | Minnesota | 27021 | 3867 | 41 |
1789815 | 1789815 | 2021-10-06 | Jasper | South Carolina | 45053 | 3867 | 73 |
1790299 | 1790299 | 2021-10-06 | Accomack | Virginia | 51001 | 3867 | 73 |
1784573 | 1784573 | 2021-10-05 | Franklin | Georgia | 13119 | 3867 | 75 |
1782479 | 1782479 | 2021-10-04 | Stone | Missouri | 29209 | 3867 | 81 |
1739362 | 1739362 | 2021-09-21 | Fayette | Indiana | 18041 | 3867 | 80 |
1682920 | 1682920 | 2021-09-03 | Kleberg | Texas | 48273 | 3867 | 106 |
1670532 | 1670532 | 2021-08-31 | Carroll | Arkansas | 5015 | 3867 | 59 |
1657478 | 1657478 | 2021-08-27 | Pike | Alabama | 1109 | 3867 | 84 |
1655609 | 1655609 | 2021-08-26 | George | Mississippi | 28039 | 3867 | 59 |
1643412 | 1643412 | 2021-08-22 | Benton | Oregon | 41003 | 3867 | 22 |
1640162 | 1640162 | 2021-08-21 | Benton | Oregon | 41003 | 3867 | 22 |
1636912 | 1636912 | 2021-08-20 | Benton | Oregon | 41003 | 3867 | 22 |
1634556 | 1634556 | 2021-08-19 | Marshall | West Virginia | 54051 | 3867 | 81 |
1598559 | 1598559 | 2021-08-08 | Upshur | Texas | 48459 | 3867 | 78 |
1584621 | 1584621 | 2021-08-04 | Bladen | North Carolina | 37017 | 3867 | 58 |
1572027 | 1572027 | 2021-07-31 | Perry | Pennsylvania | 42099 | 3867 | 101 |
1568779 | 1568779 | 2021-07-30 | Perry | Pennsylvania | 42099 | 3867 | 101 |
1537984 | 1537984 | 2021-07-21 | Knox | Indiana | 18083 | 3867 | 91 |
1508625 | 1508625 | 2021-07-12 | Christian | Illinois | 17021 | 3867 | 93 |
1503072 | 1503072 | 2021-07-10 | Laclede | Missouri | 29105 | 3867 | 75 |
1461449 | 1461449 | 2021-06-27 | Preble | Ohio | 39135 | 3867 | 106 |
1447670 | 1447670 | 2021-06-23 | Becker | Minnesota | 27005 | 3867 | 55 |
1444425 | 1444425 | 2021-06-22 | Becker | Minnesota | 27005 | 3867 | 55 |
1441180 | 1441180 | 2021-06-21 | Becker | Minnesota | 27005 | 3867 | 55 |
1437934 | 1437934 | 2021-06-20 | Becker | Minnesota | 27005 | 3867 | 55 |
1434687 | 1434687 | 2021-06-19 | Becker | Minnesota | 27005 | 3867 | 55 |
1431440 | 1431440 | 2021-06-18 | Becker | Minnesota | 27005 | 3867 | 55 |
1379965 | 1379965 | 2021-06-02 | Cheshire | New Hampshire | 33005 | 3867 | 34 |
1355113 | 1355113 | 2021-05-25 | Sanpete | Utah | 49039 | 3867 | 22 |
1351867 | 1351867 | 2021-05-24 | Sanpete | Utah | 49039 | 3867 | 22 |
1348621 | 1348621 | 2021-05-23 | Sanpete | Utah | 49039 | 3867 | 22 |
1337125 | 1337125 | 2021-05-20 | Iberville | Louisiana | 22047 | 3867 | 100 |
1319520 | 1319520 | 2021-05-14 | Petersburg city | Virginia | 51730 | 3867 | 86 |
1314653 | 1314653 | 2021-05-13 | Steele | Minnesota | 27147 | 3867 | 15 |
1259917 | 1259917 | 2021-04-26 | Columbia | New York | 36021 | 3867 | 100 |
1260842 | 1260842 | 2021-04-26 | Matagorda | Texas | 48321 | 3867 | 104 |
1232564 | 1232564 | 2021-04-18 | Liberty | Georgia | 13179 | 3867 | 62 |
1216128 | 1216128 | 2021-04-13 | Logan | Colorado | 8075 | 3867 | 65 |
1206753 | 1206753 | 2021-04-10 | Lee | Illinois | 17103 | 3867 | 88 |
1197814 | 1197814 | 2021-04-07 | Lincoln | Mississippi | 28085 | 3867 | 107 |
1177740 | 1177740 | 2021-04-01 | Plymouth | Iowa | 19149 | 3867 | 79 |
1147016 | 1147016 | 2021-03-22 | Weakley | Tennessee | 47183 | 3867 | 60 |
1147475 | 1147475 | 2021-03-22 | Lewis | Washington | 53041 | 3867 | 50 |
1108893 | 1108893 | 2021-03-11 | Mendocino | California | 6045 | 3867 | 44 |
1110840 | 1110840 | 2021-03-11 | Caddo | Oklahoma | 40015 | 3867 | 61 |
1096543 | 1096543 | 2021-03-07 | Jasper | Iowa | 19099 | 3867 | 67 |
1093297 | 1093297 | 2021-03-06 | Jasper | Iowa | 19099 | 3867 | 67 |
1090051 | 1090051 | 2021-03-05 | Jasper | Iowa | 19099 | 3867 | 67 |
1074669 | 1074669 | 2021-02-28 | Dakota | Nebraska | 31043 | 3867 | 67 |
1075966 | 1075966 | 2021-02-28 | James City | Virginia | 51095 | 3867 | 52 |
1071423 | 1071423 | 2021-02-27 | Dakota | Nebraska | 31043 | 3867 | 67 |
1068178 | 1068178 | 2021-02-26 | Dakota | Nebraska | 31043 | 3867 | 67 |
1046348 | 1046348 | 2021-02-19 | Marshall | Tennessee | 47117 | 3867 | 54 |
1037254 | 1037254 | 2021-02-16 | Albany | Wyoming | 56001 | 3867 | 11 |
1032133 | 1032133 | 2021-02-15 | Douglas | Minnesota | 27041 | 3867 | 68 |
1028720 | 1028720 | 2021-02-14 | Webster | Louisiana | 22119 | 3867 | 92 |
1025336 | 1025336 | 2021-02-13 | Graves | Kentucky | 21083 | 3867 | 69 |
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);