ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8586 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Indiana 5
- North Carolina 5
- South Carolina 5
- Washington 4
- Alabama 2
- Illinois 2
- New York 2
- Ohio 2
- Texas 2
- Virginia 2
- Idaho 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Pennsylvania 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447298 | 2447298 | 2022-04-26 | Okanogan | Washington | 53047 | 8586 | 123 |
2444010 | 2444010 | 2022-04-25 | Warren | Virginia | 51187 | 8586 | 155 |
2444042 | 2444042 | 2022-04-25 | Okanogan | Washington | 53047 | 8586 | 123 |
2361460 | 2361460 | 2022-03-31 | Orleans | New York | 36073 | 8586 | 113 |
2345178 | 2345178 | 2022-03-26 | Greene | New York | 36039 | 8586 | 124 |
2210767 | 2210767 | 2022-02-13 | Wabash | Indiana | 18169 | 8586 | 146 |
2212412 | 2212412 | 2022-02-13 | Colleton | South Carolina | 45029 | 8586 | 207 |
2207514 | 2207514 | 2022-02-12 | Wabash | Indiana | 18169 | 8586 | 146 |
2209159 | 2209159 | 2022-02-12 | Colleton | South Carolina | 45029 | 8586 | 207 |
2204261 | 2204261 | 2022-02-11 | Wabash | Indiana | 18169 | 8586 | 146 |
2205906 | 2205906 | 2022-02-11 | Colleton | South Carolina | 45029 | 8586 | 207 |
2202653 | 2202653 | 2022-02-10 | Colleton | South Carolina | 45029 | 8586 | 207 |
2083069 | 2083069 | 2022-01-04 | Pierce | Wisconsin | 55093 | 8586 | 61 |
2029807 | 2029807 | 2021-12-19 | Granville | North Carolina | 37077 | 8586 | 106 |
2026556 | 2026556 | 2021-12-18 | Granville | North Carolina | 37077 | 8586 | 106 |
2023305 | 2023305 | 2021-12-17 | Granville | North Carolina | 37077 | 8586 | 106 |
1998008 | 1998008 | 2021-12-09 | Caldwell | Texas | 48055 | 8586 | 156 |
1918399 | 1918399 | 2021-11-15 | Hopkins | Kentucky | 21107 | 8586 | 205 |
1768586 | 1768586 | 2021-09-30 | Boone | Indiana | 18011 | 8586 | 118 |
1669612 | 1669612 | 2021-08-30 | Laurens | South Carolina | 45059 | 8586 | 175 |
1645823 | 1645823 | 2021-08-23 | Rice | Minnesota | 27131 | 8586 | 113 |
1524311 | 1524311 | 2021-07-17 | Talladega | Alabama | 1121 | 8586 | 186 |
1446128 | 1446128 | 2021-06-22 | Roanoke city | Virginia | 51770 | 8586 | 198 |
1441822 | 1441822 | 2021-06-21 | Orange | North Carolina | 37135 | 8586 | 101 |
1427600 | 1427600 | 2021-06-17 | Hancock | Indiana | 18059 | 8586 | 149 |
1373971 | 1373971 | 2021-05-31 | Clearfield | Pennsylvania | 42033 | 8586 | 147 |
1234231 | 1234231 | 2021-04-18 | Wayne | Ohio | 39169 | 8586 | 209 |
1204063 | 1204063 | 2021-04-09 | Carroll | Maryland | 24013 | 8586 | 225 |
1169988 | 1169988 | 2021-03-29 | Walker | Texas | 48471 | 8586 | 122 |
1109304 | 1109304 | 2021-03-11 | DeKalb | Illinois | 17037 | 8586 | 120 |
1100947 | 1100947 | 2021-03-08 | Wilson | North Carolina | 37195 | 8586 | 150 |
1080162 | 1080162 | 2021-03-02 | Vermilion | Illinois | 17183 | 8586 | 135 |
1080992 | 1080992 | 2021-03-02 | Cole | Missouri | 29051 | 8586 | 114 |
946998 | 946998 | 2021-01-20 | Twin Falls | Idaho | 16083 | 8586 | 119 |
874824 | 874824 | 2020-12-28 | Franklin | Washington | 53021 | 8586 | 79 |
867338 | 867338 | 2020-12-26 | Clark | Ohio | 39023 | 8586 | 179 |
566863 | 566863 | 2020-09-25 | Tuscaloosa | Alabama | 1125 | 8586 | 117 |
519388 | 519388 | 2020-09-10 | Lafayette | Louisiana | 22055 | 8586 | 116 |
230644 | 230644 | 2020-06-11 | King | Washington | 53033 | 8586 | 585 |
198044 | 198044 | 2020-06-01 | Norfolk | Massachusetts | 25021 | 8586 | 841 |
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);