ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,212 rows where county = "Adams" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Indiana 393
- Colorado 391
- Nebraska 385
- Pennsylvania 385
- Illinois 383
- Mississippi 383
- Washington 380
- Idaho 372
- Wisconsin 371
- Ohio 368
- Iowa 325
- North Dakota 253
fips 12
county 1
- Adams · 4,389 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199511 | 1199511 | 2021-04-07 | Adams | Wisconsin | 55001 | 1822 | 15 |
1193353 | 1193353 | 2021-04-06 | Adams | Colorado | 8001 | 53068 | 643 |
1193666 | 1193666 | 2021-04-06 | Adams | Idaho | 16003 | 336 | 4 |
1193709 | 1193709 | 2021-04-06 | Adams | Illinois | 17001 | 8101 | 144 |
1193812 | 1193812 | 2021-04-06 | Adams | Indiana | 18001 | 3418 | 53 |
1193905 | 1193905 | 2021-04-06 | Adams | Iowa | 19003 | 321 | 4 |
1194523 | 1194523 | 2021-04-06 | Adams | Mississippi | 28001 | 2438 | 82 |
1194778 | 1194778 | 2021-04-06 | Adams | Nebraska | 31001 | 2836 | 38 |
1195113 | 1195113 | 2021-04-06 | Adams | North Dakota | 38001 | 268 | 3 |
1195169 | 1195169 | 2021-04-06 | Adams | Ohio | 39001 | 2255 | 51 |
1195372 | 1195372 | 2021-04-06 | Adams | Pennsylvania | 42001 | 8302 | 161 |
1196168 | 1196168 | 2021-04-06 | Adams | Washington | 53001 | 2005 | 22 |
1196262 | 1196262 | 2021-04-06 | Adams | Wisconsin | 55001 | 1817 | 15 |
1190103 | 1190103 | 2021-04-05 | Adams | Colorado | 8001 | 52982 | 642 |
1190416 | 1190416 | 2021-04-05 | Adams | Idaho | 16003 | 336 | 4 |
1190459 | 1190459 | 2021-04-05 | Adams | Illinois | 17001 | 8088 | 144 |
1190562 | 1190562 | 2021-04-05 | Adams | Indiana | 18001 | 3418 | 53 |
1190655 | 1190655 | 2021-04-05 | Adams | Iowa | 19003 | 321 | 4 |
1191274 | 1191274 | 2021-04-05 | Adams | Mississippi | 28001 | 2435 | 82 |
1191529 | 1191529 | 2021-04-05 | Adams | Nebraska | 31001 | 2834 | 38 |
1191865 | 1191865 | 2021-04-05 | Adams | North Dakota | 38001 | 268 | 3 |
1191921 | 1191921 | 2021-04-05 | Adams | Ohio | 39001 | 2253 | 49 |
1192124 | 1192124 | 2021-04-05 | Adams | Pennsylvania | 42001 | 8275 | 161 |
1192920 | 1192920 | 2021-04-05 | Adams | Washington | 53001 | 2004 | 22 |
1193014 | 1193014 | 2021-04-05 | Adams | Wisconsin | 55001 | 1809 | 15 |
1186856 | 1186856 | 2021-04-04 | Adams | Colorado | 8001 | 52890 | 642 |
1187169 | 1187169 | 2021-04-04 | Adams | Idaho | 16003 | 336 | 4 |
1187212 | 1187212 | 2021-04-04 | Adams | Illinois | 17001 | 8088 | 144 |
1187315 | 1187315 | 2021-04-04 | Adams | Indiana | 18001 | 3418 | 53 |
1187408 | 1187408 | 2021-04-04 | Adams | Iowa | 19003 | 321 | 4 |
1188026 | 1188026 | 2021-04-04 | Adams | Mississippi | 28001 | 2434 | 82 |
1188281 | 1188281 | 2021-04-04 | Adams | Nebraska | 31001 | 2834 | 38 |
1188616 | 1188616 | 2021-04-04 | Adams | North Dakota | 38001 | 268 | 3 |
1188672 | 1188672 | 2021-04-04 | Adams | Ohio | 39001 | 2250 | 49 |
1188875 | 1188875 | 2021-04-04 | Adams | Pennsylvania | 42001 | 8263 | 161 |
1189670 | 1189670 | 2021-04-04 | Adams | Washington | 53001 | 2002 | 22 |
1189764 | 1189764 | 2021-04-04 | Adams | Wisconsin | 55001 | 1808 | 15 |
1183609 | 1183609 | 2021-04-03 | Adams | Colorado | 8001 | 52599 | 641 |
1183922 | 1183922 | 2021-04-03 | Adams | Idaho | 16003 | 336 | 4 |
1183965 | 1183965 | 2021-04-03 | Adams | Illinois | 17001 | 8088 | 144 |
1184068 | 1184068 | 2021-04-03 | Adams | Indiana | 18001 | 3417 | 53 |
1184161 | 1184161 | 2021-04-03 | Adams | Iowa | 19003 | 321 | 4 |
1184779 | 1184779 | 2021-04-03 | Adams | Mississippi | 28001 | 2434 | 82 |
1185034 | 1185034 | 2021-04-03 | Adams | Nebraska | 31001 | 2828 | 38 |
1185369 | 1185369 | 2021-04-03 | Adams | North Dakota | 38001 | 268 | 3 |
1185425 | 1185425 | 2021-04-03 | Adams | Ohio | 39001 | 2250 | 49 |
1185628 | 1185628 | 2021-04-03 | Adams | Pennsylvania | 42001 | 8240 | 161 |
1186423 | 1186423 | 2021-04-03 | Adams | Washington | 53001 | 2002 | 22 |
1186517 | 1186517 | 2021-04-03 | Adams | Wisconsin | 55001 | 1803 | 15 |
1180362 | 1180362 | 2021-04-02 | Adams | Colorado | 8001 | 52599 | 641 |
1180675 | 1180675 | 2021-04-02 | Adams | Idaho | 16003 | 336 | 4 |
1180718 | 1180718 | 2021-04-02 | Adams | Illinois | 17001 | 8087 | 144 |
1180821 | 1180821 | 2021-04-02 | Adams | Indiana | 18001 | 3413 | 53 |
1180914 | 1180914 | 2021-04-02 | Adams | Iowa | 19003 | 321 | 4 |
1181533 | 1181533 | 2021-04-02 | Adams | Mississippi | 28001 | 2429 | 82 |
1181788 | 1181788 | 2021-04-02 | Adams | Nebraska | 31001 | 2828 | 38 |
1182122 | 1182122 | 2021-04-02 | Adams | North Dakota | 38001 | 268 | 3 |
1182178 | 1182178 | 2021-04-02 | Adams | Ohio | 39001 | 2248 | 49 |
1182381 | 1182381 | 2021-04-02 | Adams | Pennsylvania | 42001 | 8194 | 161 |
1183176 | 1183176 | 2021-04-02 | Adams | Washington | 53001 | 2001 | 22 |
1183270 | 1183270 | 2021-04-02 | Adams | Wisconsin | 55001 | 1800 | 15 |
1177115 | 1177115 | 2021-04-01 | Adams | Colorado | 8001 | 52466 | 641 |
1177428 | 1177428 | 2021-04-01 | Adams | Idaho | 16003 | 336 | 4 |
1177471 | 1177471 | 2021-04-01 | Adams | Illinois | 17001 | 8096 | 144 |
1177574 | 1177574 | 2021-04-01 | Adams | Indiana | 18001 | 3400 | 52 |
1177667 | 1177667 | 2021-04-01 | Adams | Iowa | 19003 | 321 | 4 |
1178286 | 1178286 | 2021-04-01 | Adams | Mississippi | 28001 | 2429 | 82 |
1178541 | 1178541 | 2021-04-01 | Adams | Nebraska | 31001 | 2824 | 38 |
1178875 | 1178875 | 2021-04-01 | Adams | North Dakota | 38001 | 268 | 3 |
1178931 | 1178931 | 2021-04-01 | Adams | Ohio | 39001 | 2249 | 47 |
1179134 | 1179134 | 2021-04-01 | Adams | Pennsylvania | 42001 | 8144 | 161 |
1179929 | 1179929 | 2021-04-01 | Adams | Washington | 53001 | 1997 | 22 |
1180023 | 1180023 | 2021-04-01 | Adams | Wisconsin | 55001 | 1799 | 15 |
1173868 | 1173868 | 2021-03-31 | Adams | Colorado | 8001 | 52312 | 641 |
1174181 | 1174181 | 2021-03-31 | Adams | Idaho | 16003 | 336 | 4 |
1174224 | 1174224 | 2021-03-31 | Adams | Illinois | 17001 | 8076 | 144 |
1174327 | 1174327 | 2021-03-31 | Adams | Indiana | 18001 | 3399 | 52 |
1174420 | 1174420 | 2021-03-31 | Adams | Iowa | 19003 | 320 | 4 |
1175039 | 1175039 | 2021-03-31 | Adams | Mississippi | 28001 | 2429 | 82 |
1175294 | 1175294 | 2021-03-31 | Adams | Nebraska | 31001 | 2812 | 38 |
1175628 | 1175628 | 2021-03-31 | Adams | North Dakota | 38001 | 268 | 3 |
1175684 | 1175684 | 2021-03-31 | Adams | Ohio | 39001 | 2245 | 47 |
1175887 | 1175887 | 2021-03-31 | Adams | Pennsylvania | 42001 | 8112 | 161 |
1176682 | 1176682 | 2021-03-31 | Adams | Washington | 53001 | 1994 | 22 |
1176776 | 1176776 | 2021-03-31 | Adams | Wisconsin | 55001 | 1794 | 15 |
1170621 | 1170621 | 2021-03-30 | Adams | Colorado | 8001 | 52190 | 640 |
1170934 | 1170934 | 2021-03-30 | Adams | Idaho | 16003 | 336 | 4 |
1170977 | 1170977 | 2021-03-30 | Adams | Illinois | 17001 | 8076 | 144 |
1171080 | 1171080 | 2021-03-30 | Adams | Indiana | 18001 | 3394 | 52 |
1171173 | 1171173 | 2021-03-30 | Adams | Iowa | 19003 | 319 | 4 |
1171792 | 1171792 | 2021-03-30 | Adams | Mississippi | 28001 | 2426 | 81 |
1172047 | 1172047 | 2021-03-30 | Adams | Nebraska | 31001 | 2796 | 38 |
1172381 | 1172381 | 2021-03-30 | Adams | North Dakota | 38001 | 268 | 3 |
1172437 | 1172437 | 2021-03-30 | Adams | Ohio | 39001 | 2238 | 47 |
1172640 | 1172640 | 2021-03-30 | Adams | Pennsylvania | 42001 | 8062 | 159 |
1173435 | 1173435 | 2021-03-30 | Adams | Washington | 53001 | 1993 | 22 |
1173529 | 1173529 | 2021-03-30 | Adams | Wisconsin | 55001 | 1791 | 15 |
1167373 | 1167373 | 2021-03-29 | Adams | Colorado | 8001 | 52137 | 639 |
1167686 | 1167686 | 2021-03-29 | Adams | Idaho | 16003 | 336 | 4 |
1167729 | 1167729 | 2021-03-29 | Adams | Illinois | 17001 | 8078 | 144 |
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);