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 576
- Colorado 574
- Nebraska 569
- Pennsylvania 569
- Mississippi 567
- Illinois 566
- Washington 564
- Idaho 555
- Wisconsin 554
- Ohio 552
- Iowa 509
- North Dakota 437
fips 12
county 1
- Adams · 6,592 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1791420 | 1791420 | 2021-10-07 | Adams | Iowa | 19003 | 482 | 4 |
1792037 | 1792037 | 2021-10-07 | Adams | Mississippi | 28001 | 4524 | 119 |
1792292 | 1792292 | 2021-10-07 | Adams | Nebraska | 31001 | 3791 | 54 |
1792627 | 1792627 | 2021-10-07 | Adams | North Dakota | 38001 | 348 | 4 |
1792683 | 1792683 | 2021-10-07 | Adams | Ohio | 39001 | 3965 | 81 |
1792886 | 1792886 | 2021-10-07 | Adams | Pennsylvania | 42001 | 12356 | 206 |
1793681 | 1793681 | 2021-10-07 | Adams | Washington | 53001 | 3096 | 28 |
1793775 | 1793775 | 2021-10-07 | Adams | Wisconsin | 55001 | 2595 | 33 |
1787618 | 1787618 | 2021-10-06 | Adams | Colorado | 8001 | 72765 | 852 |
1787932 | 1787932 | 2021-10-06 | Adams | Idaho | 16003 | 465 | 8 |
1787975 | 1787975 | 2021-10-06 | Adams | Illinois | 17001 | 12949 | 179 |
1788078 | 1788078 | 2021-10-06 | Adams | Indiana | 18001 | 4680 | 71 |
1788171 | 1788171 | 2021-10-06 | Adams | Iowa | 19003 | 482 | 4 |
1788788 | 1788788 | 2021-10-06 | Adams | Mississippi | 28001 | 4506 | 119 |
1789043 | 1789043 | 2021-10-06 | Adams | Nebraska | 31001 | 3773 | 54 |
1789378 | 1789378 | 2021-10-06 | Adams | North Dakota | 38001 | 345 | 4 |
1789434 | 1789434 | 2021-10-06 | Adams | Ohio | 39001 | 3948 | 81 |
1789637 | 1789637 | 2021-10-06 | Adams | Pennsylvania | 42001 | 12302 | 205 |
1790432 | 1790432 | 2021-10-06 | Adams | Washington | 53001 | 3086 | 27 |
1790526 | 1790526 | 2021-10-06 | Adams | Wisconsin | 55001 | 2582 | 33 |
1784369 | 1784369 | 2021-10-05 | Adams | Colorado | 8001 | 72628 | 852 |
1784683 | 1784683 | 2021-10-05 | Adams | Idaho | 16003 | 462 | 8 |
1784726 | 1784726 | 2021-10-05 | Adams | Illinois | 17001 | 12928 | 179 |
1784829 | 1784829 | 2021-10-05 | Adams | Indiana | 18001 | 4665 | 70 |
1784922 | 1784922 | 2021-10-05 | Adams | Iowa | 19003 | 455 | 4 |
1785540 | 1785540 | 2021-10-05 | Adams | Mississippi | 28001 | 4498 | 119 |
1785795 | 1785795 | 2021-10-05 | Adams | Nebraska | 31001 | 3759 | 54 |
1786130 | 1786130 | 2021-10-05 | Adams | North Dakota | 38001 | 345 | 4 |
1786186 | 1786186 | 2021-10-05 | Adams | Ohio | 39001 | 3925 | 81 |
1786389 | 1786389 | 2021-10-05 | Adams | Pennsylvania | 42001 | 12252 | 200 |
1787184 | 1787184 | 2021-10-05 | Adams | Washington | 53001 | 3079 | 27 |
1787278 | 1787278 | 2021-10-05 | Adams | Wisconsin | 55001 | 2570 | 33 |
1781120 | 1781120 | 2021-10-04 | Adams | Colorado | 8001 | 72520 | 851 |
1781434 | 1781434 | 2021-10-04 | Adams | Idaho | 16003 | 460 | 8 |
1781477 | 1781477 | 2021-10-04 | Adams | Illinois | 17001 | 12904 | 179 |
1781580 | 1781580 | 2021-10-04 | Adams | Indiana | 18001 | 4662 | 70 |
1781673 | 1781673 | 2021-10-04 | Adams | Iowa | 19003 | 455 | 4 |
1782291 | 1782291 | 2021-10-04 | Adams | Mississippi | 28001 | 4471 | 119 |
1782546 | 1782546 | 2021-10-04 | Adams | Nebraska | 31001 | 3737 | 54 |
1782881 | 1782881 | 2021-10-04 | Adams | North Dakota | 38001 | 341 | 4 |
1782937 | 1782937 | 2021-10-04 | Adams | Ohio | 39001 | 3904 | 80 |
1783140 | 1783140 | 2021-10-04 | Adams | Pennsylvania | 42001 | 12225 | 199 |
1783935 | 1783935 | 2021-10-04 | Adams | Washington | 53001 | 3073 | 27 |
1784029 | 1784029 | 2021-10-04 | Adams | Wisconsin | 55001 | 2549 | 33 |
1777870 | 1777870 | 2021-10-03 | Adams | Colorado | 8001 | 72520 | 851 |
1778184 | 1778184 | 2021-10-03 | Adams | Idaho | 16003 | 459 | 8 |
1778227 | 1778227 | 2021-10-03 | Adams | Illinois | 17001 | 12862 | 177 |
1778330 | 1778330 | 2021-10-03 | Adams | Indiana | 18001 | 4622 | 70 |
1778423 | 1778423 | 2021-10-03 | Adams | Iowa | 19003 | 455 | 4 |
1779041 | 1779041 | 2021-10-03 | Adams | Mississippi | 28001 | 4462 | 118 |
1779296 | 1779296 | 2021-10-03 | Adams | Nebraska | 31001 | 3716 | 54 |
1779632 | 1779632 | 2021-10-03 | Adams | North Dakota | 38001 | 341 | 4 |
1779688 | 1779688 | 2021-10-03 | Adams | Ohio | 39001 | 3894 | 80 |
1779891 | 1779891 | 2021-10-03 | Adams | Pennsylvania | 42001 | 12162 | 199 |
1780686 | 1780686 | 2021-10-03 | Adams | Washington | 53001 | 3043 | 27 |
1780780 | 1780780 | 2021-10-03 | Adams | Wisconsin | 55001 | 2529 | 33 |
1774620 | 1774620 | 2021-10-02 | Adams | Colorado | 8001 | 72392 | 850 |
1774934 | 1774934 | 2021-10-02 | Adams | Idaho | 16003 | 458 | 8 |
1774977 | 1774977 | 2021-10-02 | Adams | Illinois | 17001 | 12862 | 177 |
1775080 | 1775080 | 2021-10-02 | Adams | Indiana | 18001 | 4622 | 70 |
1775173 | 1775173 | 2021-10-02 | Adams | Iowa | 19003 | 455 | 4 |
1775791 | 1775791 | 2021-10-02 | Adams | Mississippi | 28001 | 4462 | 118 |
1776046 | 1776046 | 2021-10-02 | Adams | Nebraska | 31001 | 3716 | 54 |
1776382 | 1776382 | 2021-10-02 | Adams | North Dakota | 38001 | 341 | 4 |
1776438 | 1776438 | 2021-10-02 | Adams | Ohio | 39001 | 3869 | 80 |
1776641 | 1776641 | 2021-10-02 | Adams | Pennsylvania | 42001 | 12082 | 199 |
1777436 | 1777436 | 2021-10-02 | Adams | Washington | 53001 | 3043 | 27 |
1777530 | 1777530 | 2021-10-02 | Adams | Wisconsin | 55001 | 2529 | 33 |
1771370 | 1771370 | 2021-10-01 | Adams | Colorado | 8001 | 72218 | 848 |
1771684 | 1771684 | 2021-10-01 | Adams | Idaho | 16003 | 457 | 8 |
1771727 | 1771727 | 2021-10-01 | Adams | Illinois | 17001 | 12862 | 177 |
1771830 | 1771830 | 2021-10-01 | Adams | Indiana | 18001 | 4622 | 70 |
1771923 | 1771923 | 2021-10-01 | Adams | Iowa | 19003 | 455 | 4 |
1772541 | 1772541 | 2021-10-01 | Adams | Mississippi | 28001 | 4462 | 118 |
1772796 | 1772796 | 2021-10-01 | Adams | Nebraska | 31001 | 3716 | 54 |
1773132 | 1773132 | 2021-10-01 | Adams | North Dakota | 38001 | 340 | 4 |
1773188 | 1773188 | 2021-10-01 | Adams | Ohio | 39001 | 3850 | 80 |
1773391 | 1773391 | 2021-10-01 | Adams | Pennsylvania | 42001 | 12056 | 199 |
1774186 | 1774186 | 2021-10-01 | Adams | Washington | 53001 | 3043 | 27 |
1774280 | 1774280 | 2021-10-01 | Adams | Wisconsin | 55001 | 2529 | 33 |
1768121 | 1768121 | 2021-09-30 | Adams | Colorado | 8001 | 72046 | 846 |
1768435 | 1768435 | 2021-09-30 | Adams | Idaho | 16003 | 456 | 8 |
1768478 | 1768478 | 2021-09-30 | Adams | Illinois | 17001 | 12849 | 177 |
1768581 | 1768581 | 2021-09-30 | Adams | Indiana | 18001 | 4607 | 70 |
1768674 | 1768674 | 2021-09-30 | Adams | Iowa | 19003 | 455 | 4 |
1769292 | 1769292 | 2021-09-30 | Adams | Mississippi | 28001 | 4458 | 117 |
1769547 | 1769547 | 2021-09-30 | Adams | Nebraska | 31001 | 3705 | 54 |
1769882 | 1769882 | 2021-09-30 | Adams | North Dakota | 38001 | 337 | 4 |
1769938 | 1769938 | 2021-09-30 | Adams | Ohio | 39001 | 3831 | 76 |
1770141 | 1770141 | 2021-09-30 | Adams | Pennsylvania | 42001 | 12012 | 199 |
1770936 | 1770936 | 2021-09-30 | Adams | Washington | 53001 | 3023 | 27 |
1771030 | 1771030 | 2021-09-30 | Adams | Wisconsin | 55001 | 2515 | 33 |
1764872 | 1764872 | 2021-09-29 | Adams | Colorado | 8001 | 71780 | 841 |
1765186 | 1765186 | 2021-09-29 | Adams | Idaho | 16003 | 453 | 8 |
1765229 | 1765229 | 2021-09-29 | Adams | Illinois | 17001 | 12824 | 177 |
1765332 | 1765332 | 2021-09-29 | Adams | Indiana | 18001 | 4585 | 70 |
1765425 | 1765425 | 2021-09-29 | Adams | Iowa | 19003 | 455 | 4 |
1766043 | 1766043 | 2021-09-29 | Adams | Mississippi | 28001 | 4443 | 117 |
1766298 | 1766298 | 2021-09-29 | Adams | Nebraska | 31001 | 3670 | 54 |
1766633 | 1766633 | 2021-09-29 | Adams | North Dakota | 38001 | 334 | 4 |
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);