ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 5321 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- West Virginia 10
- Mississippi 9
- Washington 8
- Georgia 7
- Texas 7
- Virginia 7
- Indiana 6
- New Mexico 5
- Tennessee 5
- New York 4
- Ohio 4
- Illinois 3
- Michigan 3
- California 2
- Florida 2
- Maryland 2
- Missouri 2
- North Dakota 2
- Puerto Rico 2
- Arkansas 1
- Kentucky 1
- Louisiana 1
- New Jersey 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495476 | 2495476 | 2022-05-11 | Yauco | Puerto Rico | 72153 | 5321 | |
2442373 | 2442373 | 2022-04-25 | Attala | Mississippi | 28007 | 5321 | 113 |
2439117 | 2439117 | 2022-04-24 | Attala | Mississippi | 28007 | 5321 | 113 |
2440822 | 2440822 | 2022-04-24 | Lewis | West Virginia | 54041 | 5321 | 85 |
2435861 | 2435861 | 2022-04-23 | Attala | Mississippi | 28007 | 5321 | 113 |
2437566 | 2437566 | 2022-04-23 | Lewis | West Virginia | 54041 | 5321 | 85 |
2432605 | 2432605 | 2022-04-22 | Attala | Mississippi | 28007 | 5321 | 113 |
2434310 | 2434310 | 2022-04-22 | Lewis | West Virginia | 54041 | 5321 | 85 |
2429349 | 2429349 | 2022-04-21 | Attala | Mississippi | 28007 | 5321 | 113 |
2426093 | 2426093 | 2022-04-20 | Attala | Mississippi | 28007 | 5321 | 113 |
2422837 | 2422837 | 2022-04-19 | Attala | Mississippi | 28007 | 5321 | 113 |
2419581 | 2419581 | 2022-04-18 | Attala | Mississippi | 28007 | 5321 | 113 |
2408104 | 2408104 | 2022-04-14 | Dinwiddie | Virginia | 51053 | 5321 | 89 |
2395175 | 2395175 | 2022-04-10 | Waynesboro city | Virginia | 51820 | 5321 | 60 |
2391919 | 2391919 | 2022-04-09 | Waynesboro city | Virginia | 51820 | 5321 | 60 |
2388663 | 2388663 | 2022-04-08 | Waynesboro city | Virginia | 51820 | 5321 | 60 |
2384196 | 2384196 | 2022-04-07 | Taos | New Mexico | 35055 | 5321 | 89 |
2385408 | 2385408 | 2022-04-07 | Waynesboro city | Virginia | 51820 | 5321 | 60 |
2245286 | 2245286 | 2022-02-23 | Moore | Texas | 48341 | 5321 | 108 |
2239114 | 2239114 | 2022-02-21 | McDowell | West Virginia | 54047 | 5321 | 62 |
2211193 | 2211193 | 2022-02-13 | Garrett | Maryland | 24023 | 5321 | 112 |
2204696 | 2204696 | 2022-02-11 | Talbot | Maryland | 24041 | 5321 | 79 |
2194958 | 2194958 | 2022-02-08 | Alpena | Michigan | 26007 | 5321 | 125 |
2196346 | 2196346 | 2022-02-08 | Austin | Texas | 48015 | 5321 | 64 |
2196760 | 2196760 | 2022-02-08 | Staunton city | Virginia | 51790 | 5321 | 98 |
2190918 | 2190918 | 2022-02-07 | Haralson | Georgia | 13143 | 5321 | 149 |
2191704 | 2191704 | 2022-02-07 | Alpena | Michigan | 26007 | 5321 | 125 |
2179286 | 2179286 | 2022-02-03 | San Miguel | New Mexico | 35047 | 5321 | 46 |
2146500 | 2146500 | 2022-01-24 | Randolph | Missouri | 29175 | 5321 | 90 |
2108613 | 2108613 | 2022-01-12 | Hockley | Texas | 48219 | 5321 | 143 |
2077099 | 2077099 | 2022-01-03 | Madison | Georgia | 13195 | 5321 | 85 |
2073848 | 2073848 | 2022-01-02 | Madison | Georgia | 13195 | 5321 | 85 |
2070597 | 2070597 | 2022-01-01 | Madison | Georgia | 13195 | 5321 | 85 |
2067346 | 2067346 | 2021-12-31 | Madison | Georgia | 13195 | 5321 | 85 |
2029949 | 2029949 | 2021-12-19 | Fayette | Ohio | 39047 | 5321 | 75 |
2016412 | 2016412 | 2021-12-15 | Lafayette | Missouri | 29107 | 5321 | 91 |
1985417 | 1985417 | 2021-12-05 | Clallam | Washington | 53009 | 5321 | 74 |
1982167 | 1982167 | 2021-12-04 | Clallam | Washington | 53009 | 5321 | 74 |
1978917 | 1978917 | 2021-12-03 | Clallam | Washington | 53009 | 5321 | 74 |
1961484 | 1961484 | 2021-11-28 | Otsego | New York | 36077 | 5321 | 62 |
1962694 | 1962694 | 2021-11-28 | Stevens | Washington | 53065 | 5321 | 103 |
1959443 | 1959443 | 2021-11-27 | Stevens | Washington | 53065 | 5321 | 103 |
1956192 | 1956192 | 2021-11-26 | Stevens | Washington | 53065 | 5321 | 103 |
1952941 | 1952941 | 2021-11-25 | Stevens | Washington | 53065 | 5321 | 103 |
1949690 | 1949690 | 2021-11-24 | Stevens | Washington | 53065 | 5321 | 103 |
1935449 | 1935449 | 2021-11-20 | Chenango | New York | 36017 | 5321 | 94 |
1920585 | 1920585 | 2021-11-15 | Park | Wyoming | 56029 | 5321 | 88 |
1897234 | 1897234 | 2021-11-08 | Bee | Texas | 48025 | 5321 | 128 |
1893984 | 1893984 | 2021-11-07 | Bee | Texas | 48025 | 5321 | 128 |
1861911 | 1861911 | 2021-10-28 | Wise | Virginia | 51195 | 5321 | 129 |
1837157 | 1837157 | 2021-10-21 | Harlan | Kentucky | 21095 | 5321 | 127 |
1764486 | 1764486 | 2021-09-28 | Fayette | West Virginia | 54019 | 5321 | 99 |
1755562 | 1755562 | 2021-09-26 | Randolph | Illinois | 17157 | 5321 | 103 |
1752314 | 1752314 | 2021-09-25 | Randolph | Illinois | 17157 | 5321 | 103 |
1749065 | 1749065 | 2021-09-24 | Randolph | Illinois | 17157 | 5321 | 103 |
1746999 | 1746999 | 2021-09-23 | Fulton | New York | 36035 | 5321 | 97 |
1728027 | 1728027 | 2021-09-17 | Ponce | Puerto Rico | 72113 | 5321 | |
1728501 | 1728501 | 2021-09-17 | Washington | Texas | 48477 | 5321 | 113 |
1690666 | 1690666 | 2021-09-06 | Montgomery | Indiana | 18107 | 5321 | 98 |
1687416 | 1687416 | 2021-09-05 | Montgomery | Indiana | 18107 | 5321 | 98 |
1684166 | 1684166 | 2021-09-04 | Montgomery | Indiana | 18107 | 5321 | 98 |
1680915 | 1680915 | 2021-09-03 | Montgomery | Indiana | 18107 | 5321 | 98 |
1651042 | 1651042 | 2021-08-25 | Baxter | Arkansas | 5005 | 5321 | 144 |
1601019 | 1601019 | 2021-08-09 | Athens | Ohio | 39009 | 5321 | 60 |
1579655 | 1579655 | 2021-08-03 | Humboldt | California | 6023 | 5321 | 53 |
1462458 | 1462458 | 2021-06-27 | Putnam | West Virginia | 54079 | 5321 | 93 |
1459213 | 1459213 | 2021-06-26 | Putnam | West Virginia | 54079 | 5321 | 93 |
1455968 | 1455968 | 2021-06-25 | Putnam | West Virginia | 54079 | 5321 | 93 |
1452723 | 1452723 | 2021-06-24 | Putnam | West Virginia | 54079 | 5321 | 93 |
1448159 | 1448159 | 2021-06-23 | Curry | New Mexico | 35009 | 5321 | 85 |
1448485 | 1448485 | 2021-06-23 | Washington | Ohio | 39167 | 5321 | 109 |
1449477 | 1449477 | 2021-06-23 | Putnam | West Virginia | 54079 | 5321 | 93 |
1444914 | 1444914 | 2021-06-22 | Curry | New Mexico | 35009 | 5321 | 85 |
1441669 | 1441669 | 2021-06-21 | Curry | New Mexico | 35009 | 5321 | 85 |
1389952 | 1389952 | 2021-06-05 | Morton | North Dakota | 38059 | 5321 | 101 |
1386707 | 1386707 | 2021-06-04 | Morton | North Dakota | 38059 | 5321 | 101 |
1351104 | 1351104 | 2021-05-24 | Seneca | Ohio | 39147 | 5321 | 123 |
1314424 | 1314424 | 2021-05-13 | St. Martin | Louisiana | 22099 | 5321 | 115 |
1274679 | 1274679 | 2021-05-01 | Suwannee | Florida | 12121 | 5321 | 138 |
1264979 | 1264979 | 2021-04-28 | Coffee | Georgia | 13069 | 5321 | 170 |
1261732 | 1261732 | 2021-04-27 | Coffee | Georgia | 13069 | 5321 | 170 |
1200926 | 1200926 | 2021-04-08 | St. Joseph | Michigan | 26149 | 5321 | 91 |
1189161 | 1189161 | 2021-04-04 | Dyer | Tennessee | 47045 | 5321 | 103 |
1185914 | 1185914 | 2021-04-03 | Dyer | Tennessee | 47045 | 5321 | 103 |
1182667 | 1182667 | 2021-04-02 | Dyer | Tennessee | 47045 | 5321 | 103 |
1179420 | 1179420 | 2021-04-01 | Dyer | Tennessee | 47045 | 5321 | 103 |
1085331 | 1085331 | 2021-03-03 | Warren | Tennessee | 47177 | 5321 | 75 |
1034750 | 1034750 | 2021-02-16 | Dearborn | Indiana | 18029 | 5321 | 65 |
1027879 | 1027879 | 2021-02-14 | Gadsden | Florida | 12039 | 5321 | 77 |
974242 | 974242 | 2021-01-28 | Oswego | New York | 36075 | 5321 | 82 |
965062 | 965062 | 2021-01-25 | Georgetown | South Carolina | 45043 | 5321 | 112 |
944953 | 944953 | 2021-01-19 | Hunterdon | New Jersey | 34019 | 5321 | 145 |
773652 | 773652 | 2020-11-27 | Lincoln | South Dakota | 46083 | 5321 | 49 |
738919 | 738919 | 2020-11-17 | San Luis Obispo | California | 6079 | 5321 | 34 |
630642 | 630642 | 2020-10-14 | Marion | Oregon | 41047 | 5321 | 102 |
542323 | 542323 | 2020-09-17 | DeSoto | Mississippi | 28033 | 5321 | 53 |
506011 | 506011 | 2020-09-06 | Allen | Indiana | 18003 | 5321 | 192 |
410704 | 410704 | 2020-08-07 | Berks | Pennsylvania | 42011 | 5321 | 368 |
382222 | 382222 | 2020-07-29 | Jefferson | Texas | 48245 | 5321 | 61 |
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);