ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5746 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Georgia 14
- Louisiana 7
- Mississippi 7
- New York 7
- Indiana 5
- Missouri 4
- North Carolina 4
- Texas 4
- Virginia 4
- Kentucky 3
- Ohio 3
- Illinois 2
- Puerto Rico 2
- Utah 2
- West Virginia 2
- Wisconsin 2
- Alabama 1
- Florida 1
- Iowa 1
- Michigan 1
- Nebraska 1
- Nevada 1
- New Jersey 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499363 | 2499363 | 2022-05-12 | Salem city | Virginia | 51775 | 5746 | 97 |
2444711 | 2444711 | 2022-04-26 | Pierce | Georgia | 13229 | 5746 | 131 |
2441455 | 2441455 | 2022-04-25 | Pierce | Georgia | 13229 | 5746 | 131 |
2438199 | 2438199 | 2022-04-24 | Pierce | Georgia | 13229 | 5746 | 131 |
2434943 | 2434943 | 2022-04-23 | Pierce | Georgia | 13229 | 5746 | 131 |
2431687 | 2431687 | 2022-04-22 | Pierce | Georgia | 13229 | 5746 | 131 |
2428431 | 2428431 | 2022-04-21 | Pierce | Georgia | 13229 | 5746 | 131 |
2425175 | 2425175 | 2022-04-20 | Pierce | Georgia | 13229 | 5746 | 131 |
2424055 | 2424055 | 2022-04-19 | Austin | Texas | 48015 | 5746 | 73 |
2420799 | 2420799 | 2022-04-18 | Austin | Texas | 48015 | 5746 | 73 |
2302503 | 2302503 | 2022-03-13 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2299251 | 2299251 | 2022-03-12 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2295999 | 2295999 | 2022-03-11 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2292747 | 2292747 | 2022-03-10 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2289495 | 2289495 | 2022-03-09 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2286244 | 2286244 | 2022-03-08 | Sunflower | Mississippi | 28133 | 5746 | 120 |
2286366 | 2286366 | 2022-03-08 | Stone | Missouri | 29209 | 5746 | 117 |
2263163 | 2263163 | 2022-03-01 | St. James | Louisiana | 22093 | 5746 | 75 |
2259912 | 2259912 | 2022-02-28 | St. James | Louisiana | 22093 | 5746 | 75 |
2260636 | 2260636 | 2022-02-28 | Seneca | New York | 36099 | 5746 | 89 |
2256661 | 2256661 | 2022-02-27 | St. James | Louisiana | 22093 | 5746 | 75 |
2253410 | 2253410 | 2022-02-26 | St. James | Louisiana | 22093 | 5746 | 75 |
2250159 | 2250159 | 2022-02-25 | St. James | Louisiana | 22093 | 5746 | 75 |
2220875 | 2220875 | 2022-02-16 | Grant | Louisiana | 22043 | 5746 | 84 |
2175693 | 2175693 | 2022-02-02 | Adair | Missouri | 29001 | 5746 | 58 |
2146090 | 2146090 | 2022-01-24 | Union | Louisiana | 22111 | 5746 | 115 |
2118375 | 2118375 | 2022-01-15 | Hutchinson | Texas | 48233 | 5746 | 118 |
2081952 | 2081952 | 2022-01-04 | Fayette | Ohio | 39047 | 5746 | 80 |
2056973 | 2056973 | 2021-12-27 | Greenbrier | West Virginia | 54025 | 5746 | 117 |
1990716 | 1990716 | 2021-12-07 | Franklin | New York | 36033 | 5746 | 27 |
1972252 | 1972252 | 2021-12-01 | Sanpete | Utah | 49039 | 5746 | 40 |
1969002 | 1969002 | 2021-11-30 | Sanpete | Utah | 49039 | 5746 | 40 |
1955488 | 1955488 | 2021-11-26 | Ponce | Puerto Rico | 72113 | 5746 | |
1948903 | 1948903 | 2021-11-24 | McKean | Pennsylvania | 42083 | 5746 | 102 |
1943153 | 1943153 | 2021-11-22 | Wise | Virginia | 51195 | 5746 | 130 |
1883997 | 1883997 | 2021-11-04 | Toa Alta | Puerto Rico | 72135 | 5746 | |
1870330 | 1870330 | 2021-10-31 | Madison | Nebraska | 31119 | 5746 | 47 |
1863715 | 1863715 | 2021-10-29 | Webster | Missouri | 29225 | 5746 | 90 |
1828468 | 1828468 | 2021-10-18 | Logan | Ohio | 39091 | 5746 | 92 |
1823883 | 1823883 | 2021-10-17 | Putnam | Indiana | 18133 | 5746 | 80 |
1820634 | 1820634 | 2021-10-16 | Putnam | Indiana | 18133 | 5746 | 80 |
1817385 | 1817385 | 2021-10-15 | Putnam | Indiana | 18133 | 5746 | 80 |
1785996 | 1785996 | 2021-10-05 | Madison | New York | 36053 | 5746 | 98 |
1742605 | 1742605 | 2021-09-22 | DeKalb | Indiana | 18033 | 5746 | 94 |
1702961 | 1702961 | 2021-09-10 | Russell | Alabama | 1113 | 5746 | 51 |
1700692 | 1700692 | 2021-09-09 | Franklin | Kentucky | 21073 | 5746 | 65 |
1678774 | 1678774 | 2021-09-02 | Genesee | New York | 36037 | 5746 | 125 |
1670809 | 1670809 | 2021-08-31 | Baldwin | Georgia | 13009 | 5746 | 146 |
1668935 | 1668935 | 2021-08-30 | Elko | Nevada | 32007 | 5746 | 69 |
1659017 | 1659017 | 2021-08-27 | Scott | Missouri | 29201 | 5746 | 90 |
1626029 | 1626029 | 2021-08-17 | Nelson | Kentucky | 21179 | 5746 | 63 |
1562990 | 1562990 | 2021-07-28 | Pittsylvania | Virginia | 51143 | 5746 | 85 |
1529433 | 1529433 | 2021-07-18 | Edgecombe | North Carolina | 37065 | 5746 | 113 |
1526186 | 1526186 | 2021-07-17 | Edgecombe | North Carolina | 37065 | 5746 | 113 |
1522939 | 1522939 | 2021-07-16 | Edgecombe | North Carolina | 37065 | 5746 | 113 |
1469563 | 1469563 | 2021-06-30 | Polk | Georgia | 13233 | 5746 | 100 |
1459828 | 1459828 | 2021-06-27 | Polk | Georgia | 13233 | 5746 | 100 |
1456583 | 1456583 | 2021-06-26 | Polk | Georgia | 13233 | 5746 | 100 |
1440357 | 1440357 | 2021-06-21 | Polk | Georgia | 13233 | 5746 | 99 |
1437110 | 1437110 | 2021-06-20 | Polk | Georgia | 13233 | 5746 | 99 |
1380083 | 1380083 | 2021-06-02 | Wayne | New York | 36117 | 5746 | 68 |
1291143 | 1291143 | 2021-05-06 | Clinton | Illinois | 17027 | 5746 | 99 |
1292396 | 1292396 | 2021-05-06 | Jefferson | New York | 36045 | 5746 | 66 |
1219846 | 1219846 | 2021-04-14 | Marshall | Indiana | 18099 | 5746 | 109 |
1196247 | 1196247 | 2021-04-06 | Raleigh | West Virginia | 54081 | 5746 | 73 |
1150406 | 1150406 | 2021-03-23 | Lamar | Texas | 48277 | 5746 | 152 |
1115150 | 1115150 | 2021-03-12 | Waupaca | Wisconsin | 55135 | 5746 | 159 |
1067567 | 1067567 | 2021-02-26 | McCracken | Kentucky | 21145 | 5746 | 67 |
1055569 | 1055569 | 2021-02-22 | Ashtabula | Ohio | 39007 | 5746 | 140 |
1039430 | 1039430 | 2021-02-17 | Bryan | Oklahoma | 40013 | 5746 | 52 |
1036265 | 1036265 | 2021-02-16 | Deschutes | Oregon | 41017 | 5746 | 56 |
1026174 | 1026174 | 2021-02-13 | Oswego | New York | 36075 | 5746 | 87 |
991750 | 991750 | 2021-02-02 | Calumet | Wisconsin | 55015 | 5746 | 41 |
974161 | 974161 | 2021-01-28 | Hunterdon | New Jersey | 34019 | 5746 | 147 |
959134 | 959134 | 2021-01-23 | Lynchburg city | Virginia | 51680 | 5746 | 67 |
885205 | 885205 | 2021-01-01 | Jackson | Georgia | 13157 | 5746 | 73 |
836662 | 836662 | 2020-12-17 | Adams | Illinois | 17001 | 5746 | 67 |
810423 | 810423 | 2020-12-09 | Charlotte | Florida | 12015 | 5746 | 207 |
782177 | 782177 | 2020-11-30 | Livingston | Michigan | 26093 | 5746 | 48 |
782871 | 782871 | 2020-11-30 | Rowan | North Carolina | 37159 | 5746 | 131 |
755796 | 755796 | 2020-11-22 | Pottawattamie | Iowa | 19155 | 5746 | 66 |
733646 | 733646 | 2020-11-15 | Jackson | Mississippi | 28059 | 5746 | 105 |
595145 | 595145 | 2020-10-03 | Beaufort | South Carolina | 45013 | 5746 | 83 |
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);