ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 3149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Louisiana 11
- Indiana 10
- Alabama 8
- Arkansas 8
- Iowa 8
- Oklahoma 8
- Ohio 7
- Virginia 7
- Mississippi 6
- Puerto Rico 6
- Missouri 5
- Tennessee 5
- Texas 5
- Illinois 4
- Minnesota 4
- North Carolina 4
- California 3
- Colorado 2
- Florida 2
- Kansas 2
- Kentucky 2
- Maryland 2
- Nebraska 2
- New York 2
- Oregon 2
- South Carolina 2
- Vermont 2
- Wisconsin 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2311035 | 2311035 | 2022-03-16 | Crowley | Colorado | 8025 | 3149 | 28 |
2221307 | 2221307 | 2022-02-16 | Osage | Missouri | 29151 | 3149 | 39 |
2218605 | 2218605 | 2022-02-15 | Noble | Ohio | 39121 | 3149 | 53 |
2199372 | 2199372 | 2022-02-09 | Utuado | Puerto Rico | 72141 | 3149 | |
2172476 | 2172476 | 2022-02-01 | Gasconade | Missouri | 29073 | 3149 | 93 |
2169321 | 2169321 | 2022-01-31 | Glacier | Montana | 30035 | 3149 | 65 |
2170735 | 2170735 | 2022-01-31 | Southampton | Virginia | 51175 | 3149 | 75 |
2149009 | 2149009 | 2022-01-25 | Iowa | Iowa | 19095 | 3149 | 39 |
2145757 | 2145757 | 2022-01-24 | Iowa | Iowa | 19095 | 3149 | 39 |
2142502 | 2142502 | 2022-01-23 | Iowa | Iowa | 19095 | 3149 | 39 |
2139247 | 2139247 | 2022-01-22 | Iowa | Iowa | 19095 | 3149 | 39 |
2135991 | 2135991 | 2022-01-21 | Iowa | Iowa | 19095 | 3149 | 39 |
2132739 | 2132739 | 2022-01-20 | Iowa | Iowa | 19095 | 3149 | 39 |
2129486 | 2129486 | 2022-01-19 | Iowa | Iowa | 19095 | 3149 | 39 |
2115025 | 2115025 | 2022-01-14 | Bosque | Texas | 48035 | 3149 | 59 |
2109263 | 2109263 | 2022-01-13 | Franklin | Arkansas | 5047 | 3149 | 61 |
2109283 | 2109283 | 2022-01-13 | Madison | Arkansas | 5087 | 3149 | 47 |
2110275 | 2110275 | 2022-01-13 | Jackson | Louisiana | 22049 | 3149 | 65 |
2107024 | 2107024 | 2022-01-12 | Jackson | Louisiana | 22049 | 3149 | 65 |
2103773 | 2103773 | 2022-01-11 | Jackson | Louisiana | 22049 | 3149 | 65 |
2072462 | 2072462 | 2022-01-01 | Cayey | Puerto Rico | 72035 | 3149 | |
2069211 | 2069211 | 2021-12-31 | Cayey | Puerto Rico | 72035 | 3149 | |
2062759 | 2062759 | 2021-12-29 | San Sebastian | Puerto Rico | 72131 | 3149 | |
2060022 | 2060022 | 2021-12-28 | Caledonia | Vermont | 50005 | 3149 | 21 |
1994546 | 1994546 | 2021-12-08 | Hampton | South Carolina | 45049 | 3149 | 75 |
1966280 | 1966280 | 2021-11-30 | Sharp | Arkansas | 5135 | 3149 | 70 |
1965114 | 1965114 | 2021-11-29 | Wasco | Oregon | 41065 | 3149 | 46 |
1935182 | 1935182 | 2021-11-20 | Ray | Missouri | 29177 | 3149 | 60 |
1918691 | 1918691 | 2021-11-15 | Dodge | Minnesota | 27039 | 3149 | 11 |
1904378 | 1904378 | 2021-11-11 | Hale | Alabama | 1065 | 3149 | 88 |
1897878 | 1897878 | 2021-11-09 | Hale | Alabama | 1065 | 3149 | 88 |
1891538 | 1891538 | 2021-11-07 | Colusa | California | 6011 | 3149 | 19 |
1888288 | 1888288 | 2021-11-06 | Colusa | California | 6011 | 3149 | 19 |
1885038 | 1885038 | 2021-11-05 | Colusa | California | 6011 | 3149 | 19 |
1871883 | 1871883 | 2021-11-01 | Henry | Alabama | 1067 | 3149 | 66 |
1868634 | 1868634 | 2021-10-31 | Henry | Alabama | 1067 | 3149 | 66 |
1869031 | 1869031 | 2021-10-31 | Crisp | Georgia | 13081 | 3149 | 109 |
1865782 | 1865782 | 2021-10-30 | Crisp | Georgia | 13081 | 3149 | 109 |
1867100 | 1867100 | 2021-10-30 | Saunders | Nebraska | 31155 | 3149 | 20 |
1862533 | 1862533 | 2021-10-29 | Crisp | Georgia | 13081 | 3149 | 109 |
1863851 | 1863851 | 2021-10-29 | Saunders | Nebraska | 31155 | 3149 | 20 |
1860432 | 1860432 | 2021-10-28 | Perry | Missouri | 29157 | 3149 | 33 |
1850117 | 1850117 | 2021-10-25 | Bourbon | Kentucky | 21017 | 3149 | 35 |
1838721 | 1838721 | 2021-10-21 | Trousdale | Tennessee | 47169 | 3149 | 26 |
1835857 | 1835857 | 2021-10-20 | Louisa | Virginia | 51109 | 3149 | 44 |
1819975 | 1819975 | 2021-10-16 | Ashley | Arkansas | 5003 | 3149 | 48 |
1794034 | 1794034 | 2021-10-08 | Phillips | Arkansas | 5107 | 3149 | 71 |
1790742 | 1790742 | 2021-10-07 | Clark | Arkansas | 5019 | 3149 | 52 |
1778277 | 1778277 | 2021-10-03 | Lawrence | Illinois | 17101 | 3149 | 41 |
1778847 | 1778847 | 2021-10-03 | Somerset | Maryland | 24039 | 3149 | 47 |
1775027 | 1775027 | 2021-10-02 | Lawrence | Illinois | 17101 | 3149 | 41 |
1771777 | 1771777 | 2021-10-01 | Lawrence | Illinois | 17101 | 3149 | 41 |
1764703 | 1764703 | 2021-09-29 | Juneau City and Borough | Alaska | 2110 | 3149 | 7 |
1758529 | 1758529 | 2021-09-27 | Ben Hill | Georgia | 13017 | 3149 | 93 |
1757800 | 1757800 | 2021-09-26 | Rutland | Vermont | 50021 | 3149 | 25 |
1741892 | 1741892 | 2021-09-22 | Butler | Alabama | 1013 | 3149 | 88 |
1724485 | 1724485 | 2021-09-16 | Henry | Ohio | 39069 | 3149 | 68 |
1710817 | 1710817 | 2021-09-12 | Attala | Mississippi | 28007 | 3149 | 83 |
1707570 | 1707570 | 2021-09-11 | Attala | Mississippi | 28007 | 3149 | 83 |
1704323 | 1704323 | 2021-09-10 | Attala | Mississippi | 28007 | 3149 | 83 |
1699171 | 1699171 | 2021-09-08 | Lampasas | Texas | 48281 | 3149 | 46 |
1662756 | 1662756 | 2021-08-28 | Fayette | Ohio | 39047 | 3149 | 50 |
1663028 | 1663028 | 2021-08-28 | Dorado | Puerto Rico | 72051 | 3149 | |
1646958 | 1646958 | 2021-08-23 | Yankton | South Dakota | 46135 | 3149 | 33 |
1641907 | 1641907 | 2021-08-22 | Fayette | Indiana | 18041 | 3149 | 68 |
1638657 | 1638657 | 2021-08-21 | Fayette | Indiana | 18041 | 3149 | 68 |
1635407 | 1635407 | 2021-08-20 | Fayette | Indiana | 18041 | 3149 | 68 |
1616798 | 1616798 | 2021-08-14 | Stoddard | Missouri | 29207 | 3149 | 51 |
1606244 | 1606244 | 2021-08-11 | Wells | Indiana | 18179 | 3149 | 83 |
1608039 | 1608039 | 2021-08-11 | McNairy | Tennessee | 47109 | 3149 | 57 |
1585031 | 1585031 | 2021-08-04 | Tioga | Pennsylvania | 42117 | 3149 | 113 |
1577637 | 1577637 | 2021-08-02 | Coahoma | Mississippi | 28027 | 3149 | 85 |
1554848 | 1554848 | 2021-07-26 | Mille Lacs | Minnesota | 27095 | 3149 | 56 |
1536174 | 1536174 | 2021-07-20 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1532926 | 1532926 | 2021-07-19 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1529679 | 1529679 | 2021-07-18 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1526432 | 1526432 | 2021-07-17 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1523185 | 1523185 | 2021-07-16 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1519937 | 1519937 | 2021-07-15 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1516689 | 1516689 | 2021-07-14 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1517240 | 1517240 | 2021-07-14 | Hockley | Texas | 48219 | 3149 | 105 |
1513993 | 1513993 | 2021-07-13 | Hockley | Texas | 48219 | 3149 | 105 |
1498079 | 1498079 | 2021-07-08 | Warren | Virginia | 51187 | 3149 | 61 |
1485721 | 1485721 | 2021-07-05 | Dawson | Georgia | 13085 | 3149 | 50 |
1482475 | 1482475 | 2021-07-04 | Dawson | Georgia | 13085 | 3149 | 50 |
1479228 | 1479228 | 2021-07-03 | Dawson | Georgia | 13085 | 3149 | 50 |
1475982 | 1475982 | 2021-07-02 | Dawson | Georgia | 13085 | 3149 | 50 |
1472736 | 1472736 | 2021-07-01 | Dawson | Georgia | 13085 | 3149 | 50 |
1353396 | 1353396 | 2021-05-25 | Vernon | Louisiana | 22115 | 3149 | 103 |
1347824 | 1347824 | 2021-05-23 | Jackson | Ohio | 39079 | 3149 | 52 |
1337396 | 1337396 | 2021-05-20 | Alcorn | Mississippi | 28003 | 3149 | 71 |
1338414 | 1338414 | 2021-05-20 | Edgefield | South Carolina | 45037 | 3149 | 44 |
1333269 | 1333269 | 2021-05-19 | Unknown | Georgia | 3149 | 7 | |
1314048 | 1314048 | 2021-05-13 | White | Indiana | 18181 | 3149 | 55 |
1315856 | 1315856 | 2021-05-13 | Scott | Tennessee | 47151 | 3149 | 45 |
1288758 | 1288758 | 2021-05-05 | Scott | Mississippi | 28123 | 3149 | 73 |
1281937 | 1281937 | 2021-05-03 | Jefferson Davis | Louisiana | 22053 | 3149 | 96 |
1278690 | 1278690 | 2021-05-02 | Jefferson Davis | Louisiana | 22053 | 3149 | 96 |
1275443 | 1275443 | 2021-05-01 | Jefferson Davis | Louisiana | 22053 | 3149 | 96 |
1272196 | 1272196 | 2021-04-30 | Jefferson Davis | Louisiana | 22053 | 3149 | 96 |
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);