ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 9414 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 5
- South Carolina 4
- Indiana 3
- Missouri 3
- Pennsylvania 3
- Tennessee 3
- Virginia 3
- Ohio 2
- Texas 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Idaho 1
- Iowa 1
- Kentucky 1
- Maryland 1
- New York 1
- North Dakota 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497088 | 2497088 | 2022-05-12 | Putnam | Indiana | 18133 | 9414 | 129 |
2493830 | 2493830 | 2022-05-11 | Putnam | Indiana | 18133 | 9414 | 129 |
2476697 | 2476697 | 2022-05-05 | Green | Wisconsin | 55045 | 9414 | 53 |
2189639 | 2189639 | 2022-02-06 | Dillon | South Carolina | 45033 | 9414 | 130 |
2186386 | 2186386 | 2022-02-05 | Dillon | South Carolina | 45033 | 9414 | 130 |
2183134 | 2183134 | 2022-02-04 | Dillon | South Carolina | 45033 | 9414 | 130 |
2180694 | 2180694 | 2022-02-03 | Teton | Wyoming | 56039 | 9414 | 15 |
2140463 | 2140463 | 2022-01-22 | Williams | North Dakota | 38105 | 9414 | 66 |
2124119 | 2124119 | 2022-01-17 | Richmond | North Carolina | 37153 | 9414 | 157 |
2120867 | 2120867 | 2022-01-16 | Richmond | North Carolina | 37153 | 9414 | 157 |
2117615 | 2117615 | 2022-01-15 | Richmond | North Carolina | 37153 | 9414 | 157 |
2114364 | 2114364 | 2022-01-14 | Richmond | North Carolina | 37153 | 9414 | 157 |
2085427 | 2085427 | 2022-01-05 | Mifflin | Pennsylvania | 42087 | 9414 | 241 |
2036467 | 2036467 | 2021-12-21 | Knox | Ohio | 39083 | 9414 | 181 |
2024088 | 2024088 | 2021-12-17 | Harrison | Texas | 48203 | 9414 | 188 |
2010975 | 2010975 | 2021-12-13 | Unknown | Tennessee | 9414 | 144 | |
1956364 | 1956364 | 2021-11-27 | Coffee | Alabama | 1031 | 9414 | 192 |
1792726 | 1792726 | 2021-10-07 | Lawrence | Ohio | 39087 | 9414 | 136 |
1759983 | 1759983 | 2021-09-27 | Chemung | New York | 36015 | 9414 | 146 |
1745273 | 1745273 | 2021-09-23 | Greene | Arkansas | 5055 | 9414 | 108 |
1713871 | 1713871 | 2021-09-13 | Wicomico | Maryland | 24045 | 9414 | 191 |
1697198 | 1697198 | 2021-09-08 | Wayne | Indiana | 18177 | 9414 | 214 |
1653485 | 1653485 | 2021-08-25 | Greene | Tennessee | 47059 | 9414 | 172 |
1650238 | 1650238 | 2021-08-24 | Greene | Tennessee | 47059 | 9414 | 172 |
1625498 | 1625498 | 2021-08-17 | Bannock | Idaho | 16005 | 9414 | 121 |
1480318 | 1480318 | 2021-07-03 | Cole | Missouri | 29051 | 9414 | 130 |
1420134 | 1420134 | 2021-06-14 | Montgomery | Virginia | 51121 | 9414 | 96 |
1413643 | 1413643 | 2021-06-12 | Montgomery | Virginia | 51121 | 9414 | 96 |
1410398 | 1410398 | 2021-06-11 | Montgomery | Virginia | 51121 | 9414 | 96 |
1380111 | 1380111 | 2021-06-02 | Craven | North Carolina | 37049 | 9414 | 127 |
1356536 | 1356536 | 2021-05-26 | Madison | Kentucky | 21151 | 9414 | 111 |
1322011 | 1322011 | 2021-05-15 | Adams | Pennsylvania | 42001 | 9414 | 181 |
1292073 | 1292073 | 2021-05-06 | Jasper | Missouri | 29097 | 9414 | 127 |
1141617 | 1141617 | 2021-03-21 | Jackson | Georgia | 13157 | 9414 | 139 |
1055026 | 1055026 | 2021-02-22 | Clay | Missouri | 29047 | 9414 | 143 |
945423 | 945423 | 2021-01-19 | Blair | Pennsylvania | 42013 | 9414 | 216 |
739493 | 739493 | 2020-11-17 | Black Hawk | Iowa | 19013 | 9414 | 122 |
715383 | 715383 | 2020-11-09 | Brazos | Texas | 48041 | 9414 | 80 |
689249 | 689249 | 2020-11-01 | Spartanburg | South Carolina | 45083 | 9414 | 238 |
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);