ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 5528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Tennessee 10
- Virginia 8
- Texas 7
- Indiana 5
- Idaho 4
- South Carolina 4
- Puerto Rico 3
- Wisconsin 3
- Alabama 2
- Florida 2
- Minnesota 2
- Mississippi 2
- New York 2
- Ohio 2
- Pennsylvania 2
- Arizona 1
- Georgia 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Missouri 1
- Nebraska 1
- New Mexico 1
- South Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2433588 | 2433588 | 2022-04-22 | San Lorenzo | Puerto Rico | 72129 | 5528 | |
2424189 | 2424189 | 2022-04-19 | Lampasas | Texas | 48281 | 5528 | 90 |
2420933 | 2420933 | 2022-04-18 | Lampasas | Texas | 48281 | 5528 | 90 |
2417677 | 2417677 | 2022-04-17 | Lampasas | Texas | 48281 | 5528 | 90 |
2414421 | 2414421 | 2022-04-16 | Lampasas | Texas | 48281 | 5528 | 90 |
2411165 | 2411165 | 2022-04-15 | Lampasas | Texas | 48281 | 5528 | 90 |
2407909 | 2407909 | 2022-04-14 | Lampasas | Texas | 48281 | 5528 | 90 |
2376435 | 2376435 | 2022-04-05 | Payette | Idaho | 16075 | 5528 | 86 |
2373183 | 2373183 | 2022-04-04 | Payette | Idaho | 16075 | 5528 | 86 |
2353663 | 2353663 | 2022-03-29 | Payette | Idaho | 16075 | 5528 | 85 |
2350411 | 2350411 | 2022-03-28 | Payette | Idaho | 16075 | 5528 | 85 |
2308748 | 2308748 | 2022-03-15 | Talbot | Maryland | 24041 | 5528 | 86 |
2287782 | 2287782 | 2022-03-08 | Page | Virginia | 51139 | 5528 | 117 |
2178591 | 2178591 | 2022-02-03 | Grant | Louisiana | 22043 | 5528 | 84 |
2150646 | 2150646 | 2022-01-25 | Davison | South Dakota | 46035 | 5528 | 78 |
2121819 | 2121819 | 2022-01-16 | Amherst | Virginia | 51009 | 5528 | 64 |
2118567 | 2118567 | 2022-01-15 | Amherst | Virginia | 51009 | 5528 | 64 |
2115315 | 2115315 | 2022-01-14 | Amherst | Virginia | 51009 | 5528 | 64 |
2043889 | 2043889 | 2021-12-23 | Prince George | Virginia | 51149 | 5528 | 52 |
2043904 | 2043904 | 2021-12-23 | Smyth | Virginia | 51173 | 5528 | 136 |
2032498 | 2032498 | 2021-12-20 | Pine | Minnesota | 27115 | 5528 | 47 |
1962050 | 1962050 | 2021-11-28 | Marion | South Carolina | 45067 | 5528 | 142 |
1958799 | 1958799 | 2021-11-27 | Marion | South Carolina | 45067 | 5528 | 142 |
1955548 | 1955548 | 2021-11-26 | Marion | South Carolina | 45067 | 5528 | 142 |
1944371 | 1944371 | 2021-11-23 | Clark | Kentucky | 21049 | 5528 | 45 |
1929676 | 1929676 | 2021-11-18 | Macon | Tennessee | 47111 | 5528 | 93 |
1913982 | 1913982 | 2021-11-13 | Preston | West Virginia | 54077 | 5528 | 91 |
1858169 | 1858169 | 2021-10-27 | Hardin | Tennessee | 47071 | 5528 | 81 |
1812739 | 1812739 | 2021-10-13 | White | Tennessee | 47185 | 5528 | 95 |
1783306 | 1783306 | 2021-10-04 | Colleton | South Carolina | 45029 | 5528 | 182 |
1776451 | 1776451 | 2021-10-02 | Clinton | Ohio | 39027 | 5528 | 86 |
1770460 | 1770460 | 2021-09-30 | Marion | Tennessee | 47115 | 5528 | 52 |
1766324 | 1766324 | 2021-09-29 | Dodge | Nebraska | 31053 | 5528 | 83 |
1706182 | 1706182 | 2021-09-11 | Franklin | Alabama | 1059 | 5528 | 92 |
1671875 | 1671875 | 2021-08-31 | Marshall | Mississippi | 28093 | 5528 | 113 |
1667089 | 1667089 | 2021-08-29 | Dunn | Wisconsin | 55033 | 5528 | 37 |
1663841 | 1663841 | 2021-08-28 | Dunn | Wisconsin | 55033 | 5528 | 37 |
1660593 | 1660593 | 2021-08-27 | Dunn | Wisconsin | 55033 | 5528 | 37 |
1646832 | 1646832 | 2021-08-23 | Toa Baja | Puerto Rico | 72137 | 5528 | |
1641922 | 1641922 | 2021-08-22 | Jackson | Indiana | 18071 | 5528 | 78 |
1638672 | 1638672 | 2021-08-21 | Jackson | Indiana | 18071 | 5528 | 78 |
1635422 | 1635422 | 2021-08-20 | Jackson | Indiana | 18071 | 5528 | 78 |
1623555 | 1623555 | 2021-08-16 | Genesee | New York | 36037 | 5528 | 124 |
1303288 | 1303288 | 2021-05-09 | Pittsylvania | Virginia | 51143 | 5528 | 80 |
1273153 | 1273153 | 2021-04-30 | Lawrence | Ohio | 39087 | 5528 | 102 |
1257431 | 1257431 | 2021-04-25 | Warren | Tennessee | 47177 | 5528 | 81 |
1254184 | 1254184 | 2021-04-24 | Warren | Tennessee | 47177 | 5528 | 81 |
1250937 | 1250937 | 2021-04-23 | Warren | Tennessee | 47177 | 5528 | 81 |
1232184 | 1232184 | 2021-04-18 | Graham | Arizona | 4009 | 5528 | 77 |
1205177 | 1205177 | 2021-04-09 | Union | Pennsylvania | 42119 | 5528 | 86 |
1187116 | 1187116 | 2021-04-04 | Polk | Georgia | 13233 | 5528 | 88 |
1160973 | 1160973 | 2021-03-27 | Gadsden | Florida | 12039 | 5528 | 89 |
1156726 | 1156726 | 2021-03-25 | Monroe | Tennessee | 47123 | 5528 | 94 |
1143000 | 1143000 | 2021-03-21 | Cayuga | New York | 36011 | 5528 | 90 |
1115888 | 1115888 | 2021-03-13 | Cass | Indiana | 18017 | 5528 | 102 |
1067262 | 1067262 | 2021-02-26 | Shelby | Indiana | 18145 | 5528 | 100 |
1065970 | 1065970 | 2021-02-25 | Henderson | Texas | 48213 | 5528 | 151 |
1046341 | 1046341 | 2021-02-19 | Lawrence | Tennessee | 47099 | 5528 | 79 |
1041135 | 1041135 | 2021-02-18 | Clinton | Illinois | 17027 | 5528 | 97 |
1018169 | 1018169 | 2021-02-11 | Monroe | Florida | 12087 | 5528 | 42 |
997682 | 997682 | 2021-02-04 | Roane | Tennessee | 47145 | 5528 | 95 |
941729 | 941729 | 2021-01-18 | Eddy | New Mexico | 35015 | 5528 | 90 |
934778 | 934778 | 2021-01-16 | Kandiyohi | Minnesota | 27067 | 5528 | 71 |
901027 | 901027 | 2021-01-06 | Talladega | Alabama | 1121 | 5528 | 76 |
864326 | 864326 | 2020-12-25 | Mercer | Pennsylvania | 42085 | 5528 | 125 |
805122 | 805122 | 2020-12-07 | Clay | Missouri | 29047 | 5528 | 84 |
720672 | 720672 | 2020-11-11 | Jackson | Mississippi | 28059 | 5528 | 103 |
501225 | 501225 | 2020-09-04 | San Juan | Puerto Rico | 72127 | 5528 | |
443663 | 443663 | 2020-08-17 | Loudoun | Virginia | 51107 | 5528 | 115 |
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);