ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 4748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Georgia 12
- Texas 10
- Mississippi 9
- Illinois 7
- Oklahoma 7
- Virginia 7
- California 6
- Indiana 6
- Ohio 6
- Alabama 5
- Tennessee 5
- Colorado 4
- Kansas 4
- North Carolina 4
- Puerto Rico 4
- Missouri 3
- South Dakota 3
- Arkansas 2
- Idaho 2
- Michigan 2
- Pennsylvania 2
- Alaska 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- New York 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496931 | 2496931 | 2022-05-12 | Clay | Illinois | 17025 | 4748 | 74 |
2498672 | 2498672 | 2022-05-12 | Catano | Puerto Rico | 72033 | 4748 | |
2493673 | 2493673 | 2022-05-11 | Clay | Illinois | 17025 | 4748 | 74 |
2399405 | 2399405 | 2022-04-12 | Starke | Indiana | 18149 | 4748 | 97 |
2396150 | 2396150 | 2022-04-11 | Starke | Indiana | 18149 | 4748 | 97 |
2392894 | 2392894 | 2022-04-10 | Starke | Indiana | 18149 | 4748 | 97 |
2394505 | 2394505 | 2022-04-10 | Morovis | Puerto Rico | 72101 | 4748 | |
2389638 | 2389638 | 2022-04-09 | Starke | Indiana | 18149 | 4748 | 97 |
2386383 | 2386383 | 2022-04-08 | Starke | Indiana | 18149 | 4748 | 97 |
2382615 | 2382615 | 2022-04-07 | Elbert | Colorado | 8039 | 4748 | 37 |
2314970 | 2314970 | 2022-03-17 | Jefferson | Kansas | 20087 | 4748 | 59 |
2316733 | 2316733 | 2022-03-17 | Fayette | Texas | 48149 | 4748 | 101 |
2311082 | 2311082 | 2022-03-16 | Teller | Colorado | 8119 | 4748 | 56 |
2311717 | 2311717 | 2022-03-16 | Jefferson | Kansas | 20087 | 4748 | 59 |
2313480 | 2313480 | 2022-03-16 | Fayette | Texas | 48149 | 4748 | 101 |
2310227 | 2310227 | 2022-03-15 | Fayette | Texas | 48149 | 4748 | 101 |
2287706 | 2287706 | 2022-03-08 | Buchanan | Virginia | 51027 | 4748 | 103 |
2283810 | 2283810 | 2022-03-07 | Juniata | Pennsylvania | 42067 | 4748 | 174 |
2284611 | 2284611 | 2022-03-07 | Barbour | West Virginia | 54001 | 4748 | 74 |
2244494 | 2244494 | 2022-02-23 | Yancey | North Carolina | 37199 | 4748 | 50 |
2217015 | 2217015 | 2022-02-15 | Union | Georgia | 13291 | 4748 | 142 |
2155161 | 2155161 | 2022-01-27 | Mitchell | Georgia | 13205 | 4748 | 104 |
2131498 | 2131498 | 2022-01-19 | Unknown | Texas | 4748 | 0 | |
2125837 | 2125837 | 2022-01-18 | Franklin | Georgia | 13119 | 4748 | 88 |
2088716 | 2088716 | 2022-01-06 | Canovanas | Puerto Rico | 72029 | 4748 | |
2084579 | 2084579 | 2022-01-05 | Marion | Mississippi | 28091 | 4748 | 116 |
2085483 | 2085483 | 2022-01-05 | Gurabo | Puerto Rico | 72063 | 4748 | |
2034623 | 2034623 | 2021-12-21 | Delta | Colorado | 8029 | 4748 | 117 |
2021100 | 2021100 | 2021-12-16 | Isle of Wight | Virginia | 51093 | 4748 | 93 |
2006709 | 2006709 | 2021-12-12 | Stoddard | Missouri | 29207 | 4748 | 107 |
1984855 | 1984855 | 2021-12-05 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1981605 | 1981605 | 2021-12-04 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1976438 | 1976438 | 2021-12-03 | Latah | Idaho | 16057 | 4748 | 40 |
1978355 | 1978355 | 2021-12-03 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1973189 | 1973189 | 2021-12-02 | Latah | Idaho | 16057 | 4748 | 40 |
1961084 | 1961084 | 2021-11-28 | Tate | Mississippi | 28137 | 4748 | 116 |
1957833 | 1957833 | 2021-11-27 | Tate | Mississippi | 28137 | 4748 | 116 |
1954582 | 1954582 | 2021-11-26 | Tate | Mississippi | 28137 | 4748 | 116 |
1951331 | 1951331 | 2021-11-25 | Tate | Mississippi | 28137 | 4748 | 116 |
1948080 | 1948080 | 2021-11-24 | Tate | Mississippi | 28137 | 4748 | 116 |
1927132 | 1927132 | 2021-11-18 | Lawrence | Alabama | 1079 | 4748 | 127 |
1928015 | 1928015 | 2021-11-18 | Ellis | Kansas | 20051 | 4748 | 76 |
1924251 | 1924251 | 2021-11-17 | Butts | Georgia | 13035 | 4748 | 123 |
1924765 | 1924765 | 2021-11-17 | Ellis | Kansas | 20051 | 4748 | 76 |
1922038 | 1922038 | 2021-11-16 | Itawamba | Mississippi | 28057 | 4748 | 107 |
1901162 | 1901162 | 2021-11-10 | Winston | Alabama | 1133 | 4748 | 105 |
1897912 | 1897912 | 2021-11-09 | Winston | Alabama | 1133 | 4748 | 105 |
1895744 | 1895744 | 2021-11-08 | Jefferson Davis | Louisiana | 22053 | 4748 | 127 |
1896073 | 1896073 | 2021-11-08 | Scott | Mississippi | 28123 | 4748 | 98 |
1882075 | 1882075 | 2021-11-04 | Lee | Georgia | 13177 | 4748 | 80 |
1828956 | 1828956 | 2021-10-18 | Overton | Tennessee | 47133 | 4748 | 79 |
1795971 | 1795971 | 2021-10-08 | Jackson | Ohio | 39079 | 4748 | 68 |
1762813 | 1762813 | 2021-09-28 | George | Mississippi | 28039 | 4748 | 73 |
1760883 | 1760883 | 2021-09-27 | Kendall | Texas | 48259 | 4748 | 89 |
1745181 | 1745181 | 2021-09-23 | Marion | Alabama | 1093 | 4748 | 116 |
1748139 | 1748139 | 2021-09-23 | Manassas city | Virginia | 51683 | 4748 | 49 |
1723416 | 1723416 | 2021-09-16 | Clay | Kentucky | 21051 | 4748 | 52 |
1699122 | 1699122 | 2021-09-08 | Grimes | Texas | 48185 | 4748 | 79 |
1687866 | 1687866 | 2021-09-05 | Calvert | Maryland | 24009 | 4748 | 90 |
1653548 | 1653548 | 2021-08-25 | Weakley | Tennessee | 47183 | 4748 | 70 |
1650301 | 1650301 | 2021-08-24 | Weakley | Tennessee | 47183 | 4748 | 70 |
1633303 | 1633303 | 2021-08-19 | Madison | New York | 36053 | 4748 | 89 |
1631048 | 1631048 | 2021-08-18 | Washington | Texas | 48477 | 4748 | 101 |
1606863 | 1606863 | 2021-08-11 | Winona | Minnesota | 27169 | 4748 | 52 |
1588501 | 1588501 | 2021-08-05 | Cocke | Tennessee | 47029 | 4748 | 102 |
1530453 | 1530453 | 2021-07-18 | Culpeper | Virginia | 51047 | 4748 | 67 |
1527206 | 1527206 | 2021-07-17 | Culpeper | Virginia | 51047 | 4748 | 67 |
1523959 | 1523959 | 2021-07-16 | Culpeper | Virginia | 51047 | 4748 | 67 |
1508212 | 1508212 | 2021-07-12 | Humboldt | California | 6023 | 4748 | 51 |
1492224 | 1492224 | 2021-07-07 | Effingham | Georgia | 13103 | 4748 | 74 |
1440602 | 1440602 | 2021-06-21 | Lawrence | Indiana | 18093 | 4748 | 125 |
1393298 | 1393298 | 2021-06-06 | Shelby | Ohio | 39149 | 4748 | 94 |
1390053 | 1390053 | 2021-06-05 | Shelby | Ohio | 39149 | 4748 | 94 |
1369073 | 1369073 | 2021-05-30 | Effingham | Illinois | 17049 | 4748 | 83 |
1365827 | 1365827 | 2021-05-29 | Effingham | Illinois | 17049 | 4748 | 83 |
1362381 | 1362381 | 2021-05-28 | Colquitt | Georgia | 13071 | 4748 | 123 |
1352873 | 1352873 | 2021-05-25 | Macoupin | Illinois | 17117 | 4748 | 116 |
1331692 | 1331692 | 2021-05-18 | Osage | Oklahoma | 40113 | 4748 | 72 |
1328445 | 1328445 | 2021-05-17 | Osage | Oklahoma | 40113 | 4748 | 72 |
1325199 | 1325199 | 2021-05-16 | Osage | Oklahoma | 40113 | 4748 | 72 |
1321953 | 1321953 | 2021-05-15 | Osage | Oklahoma | 40113 | 4748 | 72 |
1318707 | 1318707 | 2021-05-14 | Osage | Oklahoma | 40113 | 4748 | 72 |
1315459 | 1315459 | 2021-05-13 | Osage | Oklahoma | 40113 | 4748 | 72 |
1312213 | 1312213 | 2021-05-12 | Osage | Oklahoma | 40113 | 4748 | 72 |
1302918 | 1302918 | 2021-05-09 | Burnet | Texas | 48053 | 4748 | 64 |
1299671 | 1299671 | 2021-05-08 | Burnet | Texas | 48053 | 4748 | 64 |
1242463 | 1242463 | 2021-04-21 | Henry | Illinois | 17073 | 4748 | 92 |
1224407 | 1224407 | 2021-04-15 | Auglaize | Ohio | 39011 | 4748 | 84 |
1214593 | 1214593 | 2021-04-12 | Vance | North Carolina | 37181 | 4748 | 85 |
1190353 | 1190353 | 2021-04-05 | Murray | Georgia | 13213 | 4748 | 78 |
1177509 | 1177509 | 2021-04-01 | Jackson | Illinois | 17077 | 4748 | 73 |
1173861 | 1173861 | 2021-03-31 | Tehama | California | 6103 | 4748 | 52 |
1160655 | 1160655 | 2021-03-27 | Dale | Alabama | 1045 | 4748 | 109 |
1142404 | 1142404 | 2021-03-21 | Branch | Michigan | 26023 | 4748 | 111 |
1139157 | 1139157 | 2021-03-20 | Branch | Michigan | 26023 | 4748 | 111 |
1125443 | 1125443 | 2021-03-16 | Tift | Georgia | 13277 | 4748 | 121 |
1122197 | 1122197 | 2021-03-15 | Tift | Georgia | 13277 | 4748 | 121 |
1048560 | 1048560 | 2021-02-20 | Joplin | Missouri | 4748 | 100 | |
972866 | 972866 | 2021-01-28 | Polk | Georgia | 13233 | 4748 | 65 |
946229 | 946229 | 2021-01-19 | Kitsap | Washington | 53035 | 4748 | 54 |
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);