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 212
- Colorado 210
- Nebraska 205
- Pennsylvania 205
- Mississippi 203
- Illinois 202
- Washington 200
- Idaho 191
- Wisconsin 190
- Ohio 188
- Iowa 145
- North Dakota 73
fips 12
county 1
- Adams · 2,224 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
609736 | 609736 | 2020-10-08 | Adams | Iowa | 19003 | 52 | 0 |
610354 | 610354 | 2020-10-08 | Adams | Mississippi | 28001 | 984 | 40 |
610609 | 610609 | 2020-10-08 | Adams | Nebraska | 31001 | 625 | 12 |
610943 | 610943 | 2020-10-08 | Adams | North Dakota | 38001 | 29 | 0 |
610999 | 610999 | 2020-10-08 | Adams | Ohio | 39001 | 162 | 4 |
611200 | 611200 | 2020-10-08 | Adams | Pennsylvania | 42001 | 910 | 26 |
611993 | 611993 | 2020-10-08 | Adams | Washington | 53001 | 879 | 10 |
612088 | 612088 | 2020-10-08 | Adams | Wisconsin | 55001 | 304 | 4 |
605942 | 605942 | 2020-10-07 | Adams | Colorado | 8001 | 10143 | 233 |
606254 | 606254 | 2020-10-07 | Adams | Idaho | 16003 | 29 | 2 |
606297 | 606297 | 2020-10-07 | Adams | Illinois | 17001 | 1298 | 10 |
606400 | 606400 | 2020-10-07 | Adams | Indiana | 18001 | 320 | 5 |
606493 | 606493 | 2020-10-07 | Adams | Iowa | 19003 | 49 | 0 |
607112 | 607112 | 2020-10-07 | Adams | Mississippi | 28001 | 978 | 40 |
607367 | 607367 | 2020-10-07 | Adams | Nebraska | 31001 | 617 | 12 |
607701 | 607701 | 2020-10-07 | Adams | North Dakota | 38001 | 28 | 0 |
607757 | 607757 | 2020-10-07 | Adams | Ohio | 39001 | 160 | 4 |
607958 | 607958 | 2020-10-07 | Adams | Pennsylvania | 42001 | 897 | 26 |
608751 | 608751 | 2020-10-07 | Adams | Washington | 53001 | 878 | 10 |
608846 | 608846 | 2020-10-07 | Adams | Wisconsin | 55001 | 299 | 4 |
602700 | 602700 | 2020-10-06 | Adams | Colorado | 8001 | 10001 | 232 |
603012 | 603012 | 2020-10-06 | Adams | Idaho | 16003 | 29 | 2 |
603055 | 603055 | 2020-10-06 | Adams | Illinois | 17001 | 1282 | 10 |
603158 | 603158 | 2020-10-06 | Adams | Indiana | 18001 | 318 | 5 |
603251 | 603251 | 2020-10-06 | Adams | Iowa | 19003 | 46 | 0 |
603869 | 603869 | 2020-10-06 | Adams | Mississippi | 28001 | 973 | 40 |
604124 | 604124 | 2020-10-06 | Adams | Nebraska | 31001 | 613 | 12 |
604458 | 604458 | 2020-10-06 | Adams | North Dakota | 38001 | 28 | 0 |
604514 | 604514 | 2020-10-06 | Adams | Ohio | 39001 | 158 | 4 |
604715 | 604715 | 2020-10-06 | Adams | Pennsylvania | 42001 | 891 | 26 |
605508 | 605508 | 2020-10-06 | Adams | Washington | 53001 | 877 | 10 |
605603 | 605603 | 2020-10-06 | Adams | Wisconsin | 55001 | 295 | 4 |
599457 | 599457 | 2020-10-05 | Adams | Colorado | 8001 | 9943 | 231 |
599769 | 599769 | 2020-10-05 | Adams | Idaho | 16003 | 29 | 2 |
599812 | 599812 | 2020-10-05 | Adams | Illinois | 17001 | 1267 | 10 |
599915 | 599915 | 2020-10-05 | Adams | Indiana | 18001 | 306 | 5 |
600008 | 600008 | 2020-10-05 | Adams | Iowa | 19003 | 43 | 0 |
600627 | 600627 | 2020-10-05 | Adams | Mississippi | 28001 | 971 | 39 |
600882 | 600882 | 2020-10-05 | Adams | Nebraska | 31001 | 607 | 12 |
601216 | 601216 | 2020-10-05 | Adams | North Dakota | 38001 | 27 | 0 |
601272 | 601272 | 2020-10-05 | Adams | Ohio | 39001 | 158 | 4 |
601473 | 601473 | 2020-10-05 | Adams | Pennsylvania | 42001 | 885 | 26 |
602266 | 602266 | 2020-10-05 | Adams | Washington | 53001 | 877 | 10 |
602361 | 602361 | 2020-10-05 | Adams | Wisconsin | 55001 | 293 | 4 |
596214 | 596214 | 2020-10-04 | Adams | Colorado | 8001 | 9824 | 231 |
596526 | 596526 | 2020-10-04 | Adams | Idaho | 16003 | 28 | 2 |
596570 | 596570 | 2020-10-04 | Adams | Illinois | 17001 | 1249 | 10 |
596673 | 596673 | 2020-10-04 | Adams | Indiana | 18001 | 343 | 5 |
596766 | 596766 | 2020-10-04 | Adams | Iowa | 19003 | 40 | 0 |
597384 | 597384 | 2020-10-04 | Adams | Mississippi | 28001 | 967 | 39 |
597638 | 597638 | 2020-10-04 | Adams | Nebraska | 31001 | 596 | 12 |
597973 | 597973 | 2020-10-04 | Adams | North Dakota | 38001 | 27 | 0 |
598029 | 598029 | 2020-10-04 | Adams | Ohio | 39001 | 153 | 4 |
598230 | 598230 | 2020-10-04 | Adams | Pennsylvania | 42001 | 880 | 26 |
599023 | 599023 | 2020-10-04 | Adams | Washington | 53001 | 877 | 10 |
599118 | 599118 | 2020-10-04 | Adams | Wisconsin | 55001 | 293 | 4 |
592972 | 592972 | 2020-10-03 | Adams | Colorado | 8001 | 9725 | 230 |
593284 | 593284 | 2020-10-03 | Adams | Idaho | 16003 | 28 | 2 |
593328 | 593328 | 2020-10-03 | Adams | Illinois | 17001 | 1247 | 10 |
593431 | 593431 | 2020-10-03 | Adams | Indiana | 18001 | 342 | 5 |
593524 | 593524 | 2020-10-03 | Adams | Iowa | 19003 | 40 | 0 |
594143 | 594143 | 2020-10-03 | Adams | Mississippi | 28001 | 964 | 39 |
594397 | 594397 | 2020-10-03 | Adams | Nebraska | 31001 | 596 | 12 |
594730 | 594730 | 2020-10-03 | Adams | North Dakota | 38001 | 27 | 0 |
594786 | 594786 | 2020-10-03 | Adams | Ohio | 39001 | 151 | 4 |
594987 | 594987 | 2020-10-03 | Adams | Pennsylvania | 42001 | 864 | 26 |
595780 | 595780 | 2020-10-03 | Adams | Washington | 53001 | 875 | 10 |
595875 | 595875 | 2020-10-03 | Adams | Wisconsin | 55001 | 292 | 4 |
589732 | 589732 | 2020-10-02 | Adams | Colorado | 8001 | 9669 | 230 |
590044 | 590044 | 2020-10-02 | Adams | Idaho | 16003 | 29 | 2 |
590087 | 590087 | 2020-10-02 | Adams | Illinois | 17001 | 1218 | 10 |
590190 | 590190 | 2020-10-02 | Adams | Indiana | 18001 | 316 | 5 |
590283 | 590283 | 2020-10-02 | Adams | Iowa | 19003 | 39 | 0 |
590902 | 590902 | 2020-10-02 | Adams | Mississippi | 28001 | 958 | 38 |
591156 | 591156 | 2020-10-02 | Adams | Nebraska | 31001 | 586 | 12 |
591489 | 591489 | 2020-10-02 | Adams | North Dakota | 38001 | 27 | 0 |
591545 | 591545 | 2020-10-02 | Adams | Ohio | 39001 | 148 | 4 |
591746 | 591746 | 2020-10-02 | Adams | Pennsylvania | 42001 | 864 | 26 |
592538 | 592538 | 2020-10-02 | Adams | Washington | 53001 | 875 | 10 |
592633 | 592633 | 2020-10-02 | Adams | Wisconsin | 55001 | 286 | 4 |
586491 | 586491 | 2020-10-01 | Adams | Colorado | 8001 | 9537 | 228 |
586803 | 586803 | 2020-10-01 | Adams | Idaho | 16003 | 29 | 2 |
586846 | 586846 | 2020-10-01 | Adams | Illinois | 17001 | 1209 | 10 |
586949 | 586949 | 2020-10-01 | Adams | Indiana | 18001 | 288 | 4 |
587042 | 587042 | 2020-10-01 | Adams | Iowa | 19003 | 38 | 0 |
587661 | 587661 | 2020-10-01 | Adams | Mississippi | 28001 | 956 | 38 |
587915 | 587915 | 2020-10-01 | Adams | Nebraska | 31001 | 580 | 12 |
588248 | 588248 | 2020-10-01 | Adams | North Dakota | 38001 | 26 | 0 |
588304 | 588304 | 2020-10-01 | Adams | Ohio | 39001 | 144 | 4 |
588505 | 588505 | 2020-10-01 | Adams | Pennsylvania | 42001 | 854 | 26 |
589298 | 589298 | 2020-10-01 | Adams | Washington | 53001 | 870 | 10 |
589393 | 589393 | 2020-10-01 | Adams | Wisconsin | 55001 | 281 | 4 |
583251 | 583251 | 2020-09-30 | Adams | Colorado | 8001 | 9433 | 227 |
583563 | 583563 | 2020-09-30 | Adams | Idaho | 16003 | 29 | 2 |
583606 | 583606 | 2020-09-30 | Adams | Illinois | 17001 | 1199 | 10 |
583709 | 583709 | 2020-09-30 | Adams | Indiana | 18001 | 284 | 4 |
583802 | 583802 | 2020-09-30 | Adams | Iowa | 19003 | 38 | 0 |
584421 | 584421 | 2020-09-30 | Adams | Mississippi | 28001 | 949 | 37 |
584675 | 584675 | 2020-09-30 | Adams | Nebraska | 31001 | 574 | 12 |
585008 | 585008 | 2020-09-30 | Adams | North Dakota | 38001 | 21 | 0 |
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);