ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5859 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 13
- Indiana 11
- Ohio 8
- Wisconsin 8
- Puerto Rico 5
- Louisiana 4
- North Carolina 4
- Kansas 3
- Virginia 3
- Washington 3
- Alabama 2
- Michigan 2
- Minnesota 2
- Missouri 2
- Alaska 1
- Arkansas 1
- California 1
- Florida 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Mississippi 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Utah 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494204 | 2494204 | 2022-05-11 | Grant | Louisiana | 22043 | 5859 | 94 |
2490946 | 2490946 | 2022-05-10 | Grant | Louisiana | 22043 | 5859 | 94 |
2487689 | 2487689 | 2022-05-09 | Grant | Louisiana | 22043 | 5859 | 94 |
2374973 | 2374973 | 2022-04-04 | Moca | Puerto Rico | 72099 | 5859 | |
2353560 | 2353560 | 2022-03-29 | Monroe | Georgia | 13207 | 5859 | 172 |
2350308 | 2350308 | 2022-03-28 | Monroe | Georgia | 13207 | 5859 | 172 |
2342439 | 2342439 | 2022-03-25 | Manati | Puerto Rico | 72091 | 5859 | |
2334042 | 2334042 | 2022-03-23 | Monroe | Georgia | 13207 | 5859 | 172 |
2330788 | 2330788 | 2022-03-22 | Monroe | Georgia | 13207 | 5859 | 172 |
2313260 | 2313260 | 2022-03-16 | Davison | South Dakota | 46035 | 5859 | 78 |
2242456 | 2242456 | 2022-02-22 | Vernon | Wisconsin | 55123 | 5859 | 88 |
2146251 | 2146251 | 2022-01-24 | Cass | Minnesota | 27021 | 5859 | 70 |
2146698 | 2146698 | 2022-01-24 | Coos | New Hampshire | 33007 | 5859 | 90 |
2136649 | 2136649 | 2022-01-21 | Barry | Missouri | 29009 | 5859 | 101 |
2126182 | 2126182 | 2022-01-18 | Wells | Indiana | 18179 | 5859 | 124 |
2122055 | 2122055 | 2022-01-16 | Door | Wisconsin | 55029 | 5859 | 53 |
2118803 | 2118803 | 2022-01-15 | Door | Wisconsin | 55029 | 5859 | 53 |
2115551 | 2115551 | 2022-01-14 | Door | Wisconsin | 55029 | 5859 | 53 |
2099209 | 2099209 | 2022-01-09 | Okanogan | Washington | 53047 | 5859 | 106 |
2095958 | 2095958 | 2022-01-08 | Okanogan | Washington | 53047 | 5859 | 106 |
2092706 | 2092706 | 2022-01-07 | Okanogan | Washington | 53047 | 5859 | 106 |
2075338 | 2075338 | 2022-01-02 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2072087 | 2072087 | 2022-01-01 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2068836 | 2068836 | 2021-12-31 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2051317 | 2051317 | 2021-12-26 | Adams | Indiana | 18001 | 5859 | 91 |
2048067 | 2048067 | 2021-12-25 | Adams | Indiana | 18001 | 5859 | 91 |
2044817 | 2044817 | 2021-12-24 | Adams | Indiana | 18001 | 5859 | 91 |
2041568 | 2041568 | 2021-12-23 | Adams | Indiana | 18001 | 5859 | 91 |
2038318 | 2038318 | 2021-12-22 | Adams | Indiana | 18001 | 5859 | 91 |
2021326 | 2021326 | 2021-12-16 | Trempealeau | Wisconsin | 55121 | 5859 | 54 |
2017260 | 2017260 | 2021-12-15 | Toa Alta | Puerto Rico | 72135 | 5859 | |
1983095 | 1983095 | 2021-12-05 | Jefferson | Indiana | 18077 | 5859 | 108 |
1979845 | 1979845 | 2021-12-04 | Jefferson | Indiana | 18077 | 5859 | 108 |
1976595 | 1976595 | 2021-12-03 | Jefferson | Indiana | 18077 | 5859 | 108 |
1960098 | 1960098 | 2021-11-28 | Oconee | Georgia | 13219 | 5859 | 82 |
1956847 | 1956847 | 2021-11-27 | Oconee | Georgia | 13219 | 5859 | 82 |
1953596 | 1953596 | 2021-11-26 | Oconee | Georgia | 13219 | 5859 | 82 |
1950345 | 1950345 | 2021-11-25 | Oconee | Georgia | 13219 | 5859 | 82 |
1947094 | 1947094 | 2021-11-24 | Oconee | Georgia | 13219 | 5859 | 82 |
1921704 | 1921704 | 2021-11-16 | Taylor | Kentucky | 21217 | 5859 | 88 |
1890226 | 1890226 | 2021-11-06 | Preble | Ohio | 39135 | 5859 | 132 |
1857077 | 1857077 | 2021-10-27 | Pike | Mississippi | 28113 | 5859 | 154 |
1846273 | 1846273 | 2021-10-24 | Chattahoochee | Georgia | 13053 | 5859 | 19 |
1843023 | 1843023 | 2021-10-23 | Chattahoochee | Georgia | 13053 | 5859 | 19 |
1839773 | 1839773 | 2021-10-22 | Chattahoochee | Georgia | 13053 | 5859 | 19 |
1816270 | 1816270 | 2021-10-14 | Wasatch | Utah | 49051 | 5859 | 28 |
1806752 | 1806752 | 2021-10-11 | Ohio | West Virginia | 54069 | 5859 | 101 |
1788720 | 1788720 | 2021-10-06 | Douglas | Minnesota | 27041 | 5859 | 86 |
1780821 | 1780821 | 2021-10-03 | Monroe | Wisconsin | 55081 | 5859 | 54 |
1777571 | 1777571 | 2021-10-02 | Monroe | Wisconsin | 55081 | 5859 | 54 |
1771154 | 1771154 | 2021-10-01 | Franklin | Alabama | 1059 | 5859 | 103 |
1774321 | 1774321 | 2021-10-01 | Monroe | Wisconsin | 55081 | 5859 | 54 |
1737816 | 1737816 | 2021-09-20 | Chester | South Carolina | 45023 | 5859 | 94 |
1712849 | 1712849 | 2021-09-13 | Lake | California | 6033 | 5859 | 82 |
1685811 | 1685811 | 2021-09-04 | Toa Baja | Puerto Rico | 72137 | 5859 | |
1676204 | 1676204 | 2021-09-01 | Cocke | Tennessee | 47029 | 5859 | 104 |
1620544 | 1620544 | 2021-08-15 | Huron | Ohio | 39077 | 5859 | 122 |
1604304 | 1604304 | 2021-08-10 | Jefferson | Ohio | 39081 | 5859 | 162 |
1599480 | 1599480 | 2021-08-09 | Tift | Georgia | 13277 | 5859 | 135 |
1530424 | 1530424 | 2021-07-18 | Albemarle | Virginia | 51003 | 5859 | 85 |
1527177 | 1527177 | 2021-07-17 | Albemarle | Virginia | 51003 | 5859 | 85 |
1523930 | 1523930 | 2021-07-16 | Albemarle | Virginia | 51003 | 5859 | 85 |
1490675 | 1490675 | 2021-07-06 | Union | Ohio | 39159 | 5859 | 49 |
1487428 | 1487428 | 2021-07-05 | Union | Ohio | 39159 | 5859 | 49 |
1484181 | 1484181 | 2021-07-04 | Union | Ohio | 39159 | 5859 | 49 |
1480935 | 1480935 | 2021-07-03 | Union | Ohio | 39159 | 5859 | 49 |
1359445 | 1359445 | 2021-05-27 | Henry | Indiana | 18065 | 5859 | 108 |
1284812 | 1284812 | 2021-05-04 | Shelby | Indiana | 18145 | 5859 | 106 |
1278765 | 1278765 | 2021-05-02 | St. Mary's | Maryland | 24037 | 5859 | 123 |
1167256 | 1167256 | 2021-03-29 | Crittenden | Arkansas | 5035 | 5859 | 95 |
1113216 | 1113216 | 2021-03-12 | Lapeer | Michigan | 26087 | 5859 | 132 |
1036122 | 1036122 | 2021-02-16 | Hancock | Ohio | 39063 | 5859 | 108 |
1028237 | 1028237 | 2021-02-14 | Whiteside | Illinois | 17195 | 5859 | 185 |
991912 | 991912 | 2021-02-03 | Fairbanks North Star Borough | Alaska | 2090 | 5859 | 26 |
855571 | 855571 | 2020-12-23 | Lauderdale | Alabama | 1077 | 5859 | 68 |
846714 | 846714 | 2020-12-20 | Douglas | Kansas | 20045 | 5859 | 31 |
843468 | 843468 | 2020-12-19 | Douglas | Kansas | 20045 | 5859 | 31 |
840223 | 840223 | 2020-12-18 | Douglas | Kansas | 20045 | 5859 | 31 |
834413 | 834413 | 2020-12-16 | St. Francois | Missouri | 29187 | 5859 | 58 |
795167 | 795167 | 2020-12-04 | Monroe | Michigan | 26115 | 5859 | 90 |
741033 | 741033 | 2020-11-17 | Bayamon | Puerto Rico | 72021 | 5859 | |
698321 | 698321 | 2020-11-04 | Gloucester | New Jersey | 34015 | 5859 | 249 |
675567 | 675567 | 2020-10-28 | Sarpy | Nebraska | 31153 | 5859 | 37 |
648237 | 648237 | 2020-10-20 | Okaloosa | Florida | 12091 | 5859 | 129 |
649845 | 649845 | 2020-10-20 | Pitt | North Carolina | 37147 | 5859 | 35 |
467681 | 467681 | 2020-08-25 | St. Tammany | Louisiana | 22103 | 5859 | 226 |
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);