ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 5789 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Iowa 7
- Tennessee 7
- Texas 7
- Colorado 6
- Illinois 6
- Pennsylvania 5
- Indiana 4
- Michigan 4
- Washington 4
- Georgia 3
- Ohio 3
- Puerto Rico 3
- Kansas 2
- Mississippi 2
- Vermont 2
- Virginia 2
- West Virginia 2
- Alabama 1
- California 1
- Delaware 1
- Florida 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Minnesota 1
- Missouri 1
- North Carolina 1
- North Dakota 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489462 | 2489462 | 2022-05-09 | Caledonia | Vermont | 50005 | 5789 | 25 |
2466659 | 2466659 | 2022-05-02 | Addison | Vermont | 50001 | 5789 | 15 |
2260118 | 2260118 | 2022-02-28 | Meeker | Minnesota | 27093 | 5789 | 74 |
2241283 | 2241283 | 2022-02-22 | Rolette | North Dakota | 38079 | 5789 | 41 |
2231865 | 2231865 | 2022-02-19 | Manati | Puerto Rico | 72091 | 5789 | |
2225991 | 2225991 | 2022-02-17 | Mecklenburg | Virginia | 51117 | 5789 | 107 |
2198174 | 2198174 | 2022-02-09 | Caroline | Maryland | 24011 | 5789 | 74 |
2172545 | 2172545 | 2022-02-01 | Stoddard | Missouri | 29207 | 5789 | 114 |
2149324 | 2149324 | 2022-01-25 | Plaquemines | Louisiana | 22075 | 5789 | 43 |
2146180 | 2146180 | 2022-01-24 | Emmet | Michigan | 26047 | 5789 | 65 |
2141952 | 2141952 | 2022-01-23 | Pitkin | Colorado | 8097 | 5789 | 6 |
2138697 | 2138697 | 2022-01-22 | Pitkin | Colorado | 8097 | 5789 | 6 |
2135441 | 2135441 | 2022-01-21 | Pitkin | Colorado | 8097 | 5789 | 6 |
2137911 | 2137911 | 2022-01-21 | Kleberg | Texas | 48273 | 5789 | 133 |
2131663 | 2131663 | 2022-01-19 | Orange | Virginia | 51137 | 5789 | 69 |
2099218 | 2099218 | 2022-01-09 | Stevens | Washington | 53065 | 5789 | 116 |
2095967 | 2095967 | 2022-01-08 | Stevens | Washington | 53065 | 5789 | 116 |
2092715 | 2092715 | 2022-01-07 | Stevens | Washington | 53065 | 5789 | 116 |
2082951 | 2082951 | 2022-01-04 | Okanogan | Washington | 53047 | 5789 | 106 |
2056444 | 2056444 | 2021-12-27 | Macon | Tennessee | 47111 | 5789 | 118 |
2000929 | 2000929 | 2021-12-10 | Tioga | Pennsylvania | 42117 | 5789 | 159 |
1945746 | 1945746 | 2021-11-23 | Toa Alta | Puerto Rico | 72135 | 5789 | |
1942495 | 1942495 | 2021-11-22 | Toa Alta | Puerto Rico | 72135 | 5789 | |
1922724 | 1922724 | 2021-11-16 | Putnam | Ohio | 39137 | 5789 | 116 |
1907209 | 1907209 | 2021-11-11 | Washington | Texas | 48477 | 5789 | 130 |
1888104 | 1888104 | 2021-11-06 | Chambers | Alabama | 1017 | 5789 | 144 |
1826903 | 1826903 | 2021-10-18 | Wayne | Georgia | 13305 | 5789 | 166 |
1773241 | 1773241 | 2021-10-01 | Mercer | Ohio | 39107 | 5789 | 91 |
1769181 | 1769181 | 2021-09-30 | Newaygo | Michigan | 26123 | 5789 | 71 |
1765932 | 1765932 | 2021-09-29 | Newaygo | Michigan | 26123 | 5789 | 71 |
1739503 | 1739503 | 2021-09-21 | Muscatine | Iowa | 19139 | 5789 | 108 |
1736254 | 1736254 | 2021-09-20 | Muscatine | Iowa | 19139 | 5789 | 108 |
1733004 | 1733004 | 2021-09-19 | Muscatine | Iowa | 19139 | 5789 | 108 |
1729754 | 1729754 | 2021-09-18 | Muscatine | Iowa | 19139 | 5789 | 108 |
1726504 | 1726504 | 2021-09-17 | Muscatine | Iowa | 19139 | 5789 | 108 |
1723255 | 1723255 | 2021-09-16 | Muscatine | Iowa | 19139 | 5789 | 108 |
1720006 | 1720006 | 2021-09-15 | Muscatine | Iowa | 19139 | 5789 | 108 |
1708767 | 1708767 | 2021-09-11 | Unknown | Tennessee | 5789 | 100 | |
1709273 | 1709273 | 2021-09-11 | Marion | West Virginia | 54049 | 5789 | 63 |
1692448 | 1692448 | 2021-09-06 | Cheatham | Tennessee | 47021 | 5789 | 58 |
1689199 | 1689199 | 2021-09-05 | Cheatham | Tennessee | 47021 | 5789 | 58 |
1685949 | 1685949 | 2021-09-04 | Cheatham | Tennessee | 47021 | 5789 | 58 |
1682698 | 1682698 | 2021-09-03 | Cheatham | Tennessee | 47021 | 5789 | 58 |
1649144 | 1649144 | 2021-08-24 | Neshoba | Mississippi | 28099 | 5789 | 186 |
1578935 | 1578935 | 2021-08-02 | Harrison | Texas | 48203 | 5789 | 112 |
1531249 | 1531249 | 2021-07-19 | Polk | Georgia | 13233 | 5789 | 100 |
1514745 | 1514745 | 2021-07-14 | Tehama | California | 6103 | 5789 | 64 |
1484692 | 1484692 | 2021-07-04 | Caldwell | Texas | 48055 | 5789 | 100 |
1478199 | 1478199 | 2021-07-02 | Caldwell | Texas | 48055 | 5789 | 100 |
1473228 | 1473228 | 2021-07-01 | Ford | Kansas | 20057 | 5789 | 76 |
1469982 | 1469982 | 2021-06-30 | Ford | Kansas | 20057 | 5789 | 76 |
1446956 | 1446956 | 2021-06-23 | Clinton | Illinois | 17027 | 5789 | 100 |
1443711 | 1443711 | 2021-06-22 | Clinton | Illinois | 17027 | 5789 | 100 |
1440466 | 1440466 | 2021-06-21 | Clinton | Illinois | 17027 | 5789 | 100 |
1437219 | 1437219 | 2021-06-20 | Clinton | Illinois | 17027 | 5789 | 100 |
1433972 | 1433972 | 2021-06-19 | Clinton | Illinois | 17027 | 5789 | 100 |
1430726 | 1430726 | 2021-06-18 | Clinton | Illinois | 17027 | 5789 | 100 |
1344758 | 1344758 | 2021-05-22 | Columbia | Pennsylvania | 42037 | 5789 | 133 |
1341510 | 1341510 | 2021-05-21 | Columbia | Pennsylvania | 42037 | 5789 | 133 |
1320943 | 1320943 | 2021-05-15 | Penobscot | Maine | 23019 | 5789 | 90 |
1245848 | 1245848 | 2021-04-22 | Shelby | Indiana | 18145 | 5789 | 105 |
1236085 | 1236085 | 2021-04-19 | Marshall | Indiana | 18099 | 5789 | 109 |
1225855 | 1225855 | 2021-04-16 | Fremont | Colorado | 8043 | 5789 | 54 |
1199496 | 1199496 | 2021-04-07 | Raleigh | West Virginia | 54081 | 5789 | 74 |
1137877 | 1137877 | 2021-03-19 | Waupaca | Wisconsin | 55135 | 5789 | 160 |
1077304 | 1077304 | 2021-03-01 | McCracken | Kentucky | 21145 | 5789 | 69 |
1075506 | 1075506 | 2021-02-28 | Bedford | Tennessee | 47003 | 5789 | 119 |
1036163 | 1036163 | 2021-02-16 | Scioto | Ohio | 39145 | 5789 | 101 |
989103 | 989103 | 2021-02-02 | Rockdale | Georgia | 13247 | 5789 | 115 |
904940 | 904940 | 2021-01-07 | Grant | Indiana | 18053 | 5789 | 108 |
864879 | 864879 | 2020-12-25 | Walker | Texas | 48471 | 5789 | 82 |
810839 | 810839 | 2020-12-09 | LaPorte | Indiana | 18091 | 5789 | 112 |
812415 | 812415 | 2020-12-09 | Washington | Pennsylvania | 42125 | 5789 | 81 |
802653 | 802653 | 2020-12-06 | Lackawanna | Pennsylvania | 42069 | 5789 | 235 |
797431 | 797431 | 2020-12-05 | Kent | Delaware | 10001 | 5789 | 133 |
717260 | 717260 | 2020-11-10 | Ingham | Michigan | 26065 | 5789 | 79 |
654735 | 654735 | 2020-10-22 | Santa Rosa | Florida | 12113 | 5789 | 86 |
594159 | 594159 | 2020-10-03 | DeSoto | Mississippi | 28033 | 5789 | 69 |
580042 | 580042 | 2020-09-29 | Jefferson | Colorado | 8059 | 5789 | 252 |
387852 | 387852 | 2020-07-31 | Durham | North Carolina | 37063 | 5789 | 77 |
372496 | 372496 | 2020-07-26 | Collin | Texas | 48085 | 5789 | 74 |
334882 | 334882 | 2020-07-15 | Arapahoe | Colorado | 8005 | 5789 | 352 |
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);