ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
348 rows where cases = 1448 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 36
- Georgia 24
- Virginia 20
- Louisiana 18
- Indiana 17
- Iowa 17
- Arkansas 15
- Oklahoma 15
- Missouri 14
- Puerto Rico 13
- Colorado 11
- Minnesota 11
- North Carolina 10
- California 9
- Ohio 8
- Tennessee 8
- Nebraska 7
- South Dakota 7
- Texas 7
- Alabama 6
- Florida 6
- Mississippi 6
- West Virginia 6
- Wisconsin 6
- Illinois 5
- Montana 5
- Pennsylvania 5
- Michigan 4
- New York 4
- North Dakota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483559 | 2483559 | 2022-05-08 | Huerfano | Colorado | 8055 | 1448 | 35 |
2480301 | 2480301 | 2022-05-07 | Huerfano | Colorado | 8055 | 1448 | 35 |
2477043 | 2477043 | 2022-05-06 | Huerfano | Colorado | 8055 | 1448 | 35 |
2473785 | 2473785 | 2022-05-05 | Huerfano | Colorado | 8055 | 1448 | 35 |
2470528 | 2470528 | 2022-05-04 | Huerfano | Colorado | 8055 | 1448 | 35 |
2467272 | 2467272 | 2022-05-03 | Huerfano | Colorado | 8055 | 1448 | 35 |
2467761 | 2467761 | 2022-05-03 | Ohio | Indiana | 18115 | 1448 | 19 |
2464017 | 2464017 | 2022-05-02 | Huerfano | Colorado | 8055 | 1448 | 33 |
2464506 | 2464506 | 2022-05-02 | Ohio | Indiana | 18115 | 1448 | 19 |
2460761 | 2460761 | 2022-05-01 | Huerfano | Colorado | 8055 | 1448 | 33 |
2461250 | 2461250 | 2022-05-01 | Ohio | Indiana | 18115 | 1448 | 19 |
2457505 | 2457505 | 2022-04-30 | Huerfano | Colorado | 8055 | 1448 | 33 |
2457994 | 2457994 | 2022-04-30 | Ohio | Indiana | 18115 | 1448 | 19 |
2454249 | 2454249 | 2022-04-29 | Huerfano | Colorado | 8055 | 1448 | 33 |
2454738 | 2454738 | 2022-04-29 | Ohio | Indiana | 18115 | 1448 | 19 |
2451482 | 2451482 | 2022-04-28 | Ohio | Indiana | 18115 | 1448 | 19 |
2448226 | 2448226 | 2022-04-27 | Ohio | Indiana | 18115 | 1448 | 19 |
2342421 | 2342421 | 2022-03-25 | Guanica | Puerto Rico | 72055 | 1448 | |
2237671 | 2237671 | 2022-02-21 | Cedar | Nebraska | 31027 | 1448 | 11 |
2200148 | 2200148 | 2022-02-09 | Iron | Wisconsin | 55051 | 1448 | 45 |
2171428 | 2171428 | 2022-02-01 | Marion | Georgia | 13197 | 1448 | 43 |
2130366 | 2130366 | 2022-01-19 | Knox | Nebraska | 31107 | 1448 | 13 |
2126964 | 2126964 | 2022-01-18 | Ozark | Missouri | 29153 | 1448 | 48 |
2110796 | 2110796 | 2022-01-13 | Valley | Montana | 30105 | 1448 | 32 |
2092759 | 2092759 | 2022-01-07 | Pocahontas | West Virginia | 54075 | 1448 | 23 |
2076788 | 2076788 | 2022-01-03 | Searcy | Arkansas | 5129 | 1448 | 31 |
2073537 | 2073537 | 2022-01-02 | Searcy | Arkansas | 5129 | 1448 | 31 |
2070286 | 2070286 | 2022-01-01 | Searcy | Arkansas | 5129 | 1448 | 31 |
2041023 | 2041023 | 2021-12-23 | Nevada | Arkansas | 5099 | 1448 | 42 |
2040004 | 2040004 | 2021-12-22 | Quebradillas | Puerto Rico | 72115 | 1448 | |
2035525 | 2035525 | 2021-12-21 | Red River | Louisiana | 22081 | 1448 | 49 |
2033487 | 2033487 | 2021-12-20 | Lares | Puerto Rico | 72081 | 1448 | |
2028895 | 2028895 | 2021-12-19 | Elliott | Kentucky | 21063 | 1448 | 13 |
2028975 | 2028975 | 2021-12-19 | Trimble | Kentucky | 21223 | 1448 | 28 |
2025644 | 2025644 | 2021-12-18 | Elliott | Kentucky | 21063 | 1448 | 13 |
2025724 | 2025724 | 2021-12-18 | Trimble | Kentucky | 21223 | 1448 | 28 |
2022393 | 2022393 | 2021-12-17 | Elliott | Kentucky | 21063 | 1448 | 13 |
2022473 | 2022473 | 2021-12-17 | Trimble | Kentucky | 21223 | 1448 | 28 |
2013617 | 2013617 | 2021-12-14 | Benson | North Dakota | 38005 | 1448 | 21 |
2013804 | 2013804 | 2021-12-14 | Major | Oklahoma | 40093 | 1448 | 33 |
2010553 | 2010553 | 2021-12-13 | Major | Oklahoma | 40093 | 1448 | 33 |
2007302 | 2007302 | 2021-12-12 | Major | Oklahoma | 40093 | 1448 | 33 |
2004051 | 2004051 | 2021-12-11 | Major | Oklahoma | 40093 | 1448 | 33 |
2000800 | 2000800 | 2021-12-10 | Major | Oklahoma | 40093 | 1448 | 33 |
1997550 | 1997550 | 2021-12-09 | Major | Oklahoma | 40093 | 1448 | 33 |
1994299 | 1994299 | 2021-12-08 | Major | Oklahoma | 40093 | 1448 | 33 |
1987289 | 1987289 | 2021-12-06 | Cheyenne | Nebraska | 31033 | 1448 | 19 |
1984005 | 1984005 | 2021-12-05 | Powell | Montana | 30077 | 1448 | 23 |
1980755 | 1980755 | 2021-12-04 | Powell | Montana | 30077 | 1448 | 23 |
1977420 | 1977420 | 2021-12-03 | Monroe | Missouri | 29137 | 1448 | 32 |
1977505 | 1977505 | 2021-12-03 | Powell | Montana | 30077 | 1448 | 23 |
1974170 | 1974170 | 2021-12-02 | Monroe | Missouri | 29137 | 1448 | 32 |
1965331 | 1965331 | 2021-11-29 | Custer | South Dakota | 46033 | 1448 | 19 |
1962611 | 1962611 | 2021-11-28 | Nelson | Virginia | 51125 | 1448 | 20 |
1959360 | 1959360 | 2021-11-27 | Nelson | Virginia | 51125 | 1448 | 20 |
1956109 | 1956109 | 2021-11-26 | Nelson | Virginia | 51125 | 1448 | 20 |
1939981 | 1939981 | 2021-11-21 | Pleasants | West Virginia | 54073 | 1448 | 30 |
1916148 | 1916148 | 2021-11-14 | Traill | North Dakota | 38097 | 1448 | 21 |
1907587 | 1907587 | 2021-11-11 | Platte | Wyoming | 56031 | 1448 | 26 |
1902474 | 1902474 | 2021-11-10 | Murray | Minnesota | 27101 | 1448 | 11 |
1904338 | 1904338 | 2021-11-10 | Platte | Wyoming | 56031 | 1448 | 26 |
1874818 | 1874818 | 2021-11-01 | Floyd | Virginia | 51063 | 1448 | 29 |
1869068 | 1869068 | 2021-10-31 | Irwin | Georgia | 13155 | 1448 | 39 |
1865819 | 1865819 | 2021-10-30 | Irwin | Georgia | 13155 | 1448 | 39 |
1862570 | 1862570 | 2021-10-29 | Irwin | Georgia | 13155 | 1448 | 39 |
1841767 | 1841767 | 2021-10-22 | Yauco | Puerto Rico | 72153 | 1448 | |
1827720 | 1827720 | 2021-10-18 | Jackson | Minnesota | 27063 | 1448 | 14 |
1800586 | 1800586 | 2021-10-10 | Plumas | California | 6063 | 1448 | 6 |
1797337 | 1797337 | 2021-10-09 | Plumas | California | 6063 | 1448 | 6 |
1794088 | 1794088 | 2021-10-08 | Plumas | California | 6063 | 1448 | 6 |
1791098 | 1791098 | 2021-10-07 | Lanier | Georgia | 13173 | 1448 | 15 |
1787464 | 1787464 | 2021-10-06 | Valdez-Cordova Census Area | Alaska | 2261 | 1448 | 3 |
1778089 | 1778089 | 2021-10-03 | Heard | Georgia | 13149 | 1448 | 32 |
1774839 | 1774839 | 2021-10-02 | Heard | Georgia | 13149 | 1448 | 32 |
1771589 | 1771589 | 2021-10-01 | Heard | Georgia | 13149 | 1448 | 32 |
1771719 | 1771719 | 2021-10-01 | Owyhee | Idaho | 16073 | 1448 | 36 |
1768039 | 1768039 | 2021-09-30 | Perry | Arkansas | 5105 | 1448 | 20 |
1767538 | 1767538 | 2021-09-29 | Caledonia | Vermont | 50005 | 1448 | 10 |
1757852 | 1757852 | 2021-09-26 | Franklin city | Virginia | 51620 | 1448 | 38 |
1754604 | 1754604 | 2021-09-25 | Franklin city | Virginia | 51620 | 1448 | 38 |
1751356 | 1751356 | 2021-09-24 | Franklin city | Virginia | 51620 | 1448 | 38 |
1739186 | 1739186 | 2021-09-21 | Wilkinson | Georgia | 13319 | 1448 | 34 |
1739235 | 1739235 | 2021-09-21 | Teton | Idaho | 16081 | 1448 | 5 |
1721736 | 1721736 | 2021-09-15 | Perry | Tennessee | 47135 | 1448 | 31 |
1712932 | 1712932 | 2021-09-13 | Moffat | Colorado | 8081 | 1448 | 30 |
1702155 | 1702155 | 2021-09-09 | Lake | South Dakota | 46079 | 1448 | 20 |
1666041 | 1666041 | 2021-08-29 | Noble | Ohio | 39121 | 1448 | 40 |
1655392 | 1655392 | 2021-08-26 | Kent | Maryland | 24029 | 1448 | 51 |
1653845 | 1653845 | 2021-08-25 | Orleans | Vermont | 50019 | 1448 | 13 |
1646722 | 1646722 | 2021-08-23 | Forest | Pennsylvania | 42053 | 1448 | 21 |
1642509 | 1642509 | 2021-08-22 | Aitkin | Minnesota | 27001 | 1448 | 37 |
1643473 | 1643473 | 2021-08-22 | Forest | Pennsylvania | 42053 | 1448 | 21 |
1639259 | 1639259 | 2021-08-21 | Aitkin | Minnesota | 27001 | 1448 | 37 |
1636009 | 1636009 | 2021-08-20 | Aitkin | Minnesota | 27001 | 1448 | 37 |
1633905 | 1633905 | 2021-08-19 | Charles Mix | South Dakota | 46023 | 1448 | 23 |
1630191 | 1630191 | 2021-08-18 | Barnes | North Dakota | 38003 | 1448 | 32 |
1631115 | 1631115 | 2021-08-18 | Alleghany | Virginia | 51005 | 1448 | 50 |
1624670 | 1624670 | 2021-08-16 | Greene | Virginia | 51079 | 1448 | 22 |
1618580 | 1618580 | 2021-08-15 | Fulton | Arkansas | 5049 | 1448 | 51 |
1605602 | 1605602 | 2021-08-11 | Little River | Arkansas | 5081 | 1448 | 43 |
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);