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 568
- Colorado 566
- Pennsylvania 561
- Nebraska 560
- Illinois 558
- Mississippi 558
- Washington 556
- Idaho 547
- Wisconsin 546
- Ohio 544
- Iowa 500
- North Dakota 428
fips 12
county 1
- Adams · 6,492 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1766689 | 1766689 | 2021-09-29 | Adams | Ohio | 39001 | 3805 | 76 |
1766892 | 1766892 | 2021-09-29 | Adams | Pennsylvania | 42001 | 11953 | 197 |
1767687 | 1767687 | 2021-09-29 | Adams | Washington | 53001 | 3003 | 27 |
1767781 | 1767781 | 2021-09-29 | Adams | Wisconsin | 55001 | 2508 | 33 |
1761623 | 1761623 | 2021-09-28 | Adams | Colorado | 8001 | 71780 | 841 |
1761937 | 1761937 | 2021-09-28 | Adams | Idaho | 16003 | 450 | 8 |
1761980 | 1761980 | 2021-09-28 | Adams | Illinois | 17001 | 12802 | 177 |
1762083 | 1762083 | 2021-09-28 | Adams | Indiana | 18001 | 4561 | 69 |
1762176 | 1762176 | 2021-09-28 | Adams | Iowa | 19003 | 425 | 4 |
1762794 | 1762794 | 2021-09-28 | Adams | Mississippi | 28001 | 4436 | 117 |
1763049 | 1763049 | 2021-09-28 | Adams | Nebraska | 31001 | 3658 | 54 |
1763384 | 1763384 | 2021-09-28 | Adams | North Dakota | 38001 | 333 | 4 |
1763440 | 1763440 | 2021-09-28 | Adams | Ohio | 39001 | 3781 | 76 |
1763643 | 1763643 | 2021-09-28 | Adams | Pennsylvania | 42001 | 11894 | 197 |
1764438 | 1764438 | 2021-09-28 | Adams | Washington | 53001 | 3001 | 27 |
1764532 | 1764532 | 2021-09-28 | Adams | Wisconsin | 55001 | 2501 | 33 |
1758375 | 1758375 | 2021-09-27 | Adams | Colorado | 8001 | 71562 | 841 |
1758689 | 1758689 | 2021-09-27 | Adams | Idaho | 16003 | 445 | 8 |
1758732 | 1758732 | 2021-09-27 | Adams | Illinois | 17001 | 12764 | 177 |
1758835 | 1758835 | 2021-09-27 | Adams | Indiana | 18001 | 4553 | 69 |
1758928 | 1758928 | 2021-09-27 | Adams | Iowa | 19003 | 425 | 4 |
1759545 | 1759545 | 2021-09-27 | Adams | Mississippi | 28001 | 4429 | 117 |
1759800 | 1759800 | 2021-09-27 | Adams | Nebraska | 31001 | 3629 | 54 |
1760135 | 1760135 | 2021-09-27 | Adams | North Dakota | 38001 | 332 | 4 |
1760191 | 1760191 | 2021-09-27 | Adams | Ohio | 39001 | 3736 | 75 |
1760394 | 1760394 | 2021-09-27 | Adams | Pennsylvania | 42001 | 11850 | 197 |
1761189 | 1761189 | 2021-09-27 | Adams | Washington | 53001 | 2994 | 26 |
1761283 | 1761283 | 2021-09-27 | Adams | Wisconsin | 55001 | 2489 | 32 |
1755127 | 1755127 | 2021-09-26 | Adams | Colorado | 8001 | 71434 | 840 |
1755441 | 1755441 | 2021-09-26 | Adams | Idaho | 16003 | 443 | 8 |
1755484 | 1755484 | 2021-09-26 | Adams | Illinois | 17001 | 12733 | 177 |
1755587 | 1755587 | 2021-09-26 | Adams | Indiana | 18001 | 4525 | 69 |
1755680 | 1755680 | 2021-09-26 | Adams | Iowa | 19003 | 425 | 4 |
1756297 | 1756297 | 2021-09-26 | Adams | Mississippi | 28001 | 4416 | 116 |
1756552 | 1756552 | 2021-09-26 | Adams | Nebraska | 31001 | 3595 | 54 |
1756887 | 1756887 | 2021-09-26 | Adams | North Dakota | 38001 | 331 | 4 |
1756943 | 1756943 | 2021-09-26 | Adams | Ohio | 39001 | 3715 | 75 |
1757146 | 1757146 | 2021-09-26 | Adams | Pennsylvania | 42001 | 11803 | 197 |
1757941 | 1757941 | 2021-09-26 | Adams | Washington | 53001 | 2958 | 26 |
1758035 | 1758035 | 2021-09-26 | Adams | Wisconsin | 55001 | 2444 | 31 |
1751879 | 1751879 | 2021-09-25 | Adams | Colorado | 8001 | 71307 | 835 |
1752193 | 1752193 | 2021-09-25 | Adams | Idaho | 16003 | 442 | 8 |
1752236 | 1752236 | 2021-09-25 | Adams | Illinois | 17001 | 12733 | 177 |
1752339 | 1752339 | 2021-09-25 | Adams | Indiana | 18001 | 4525 | 69 |
1752432 | 1752432 | 2021-09-25 | Adams | Iowa | 19003 | 425 | 4 |
1753049 | 1753049 | 2021-09-25 | Adams | Mississippi | 28001 | 4416 | 116 |
1753304 | 1753304 | 2021-09-25 | Adams | Nebraska | 31001 | 3595 | 54 |
1753639 | 1753639 | 2021-09-25 | Adams | North Dakota | 38001 | 330 | 4 |
1753695 | 1753695 | 2021-09-25 | Adams | Ohio | 39001 | 3692 | 75 |
1753898 | 1753898 | 2021-09-25 | Adams | Pennsylvania | 42001 | 11752 | 196 |
1754693 | 1754693 | 2021-09-25 | Adams | Washington | 53001 | 2958 | 26 |
1754787 | 1754787 | 2021-09-25 | Adams | Wisconsin | 55001 | 2444 | 31 |
1748630 | 1748630 | 2021-09-24 | Adams | Colorado | 8001 | 71189 | 834 |
1748944 | 1748944 | 2021-09-24 | Adams | Idaho | 16003 | 441 | 8 |
1748987 | 1748987 | 2021-09-24 | Adams | Illinois | 17001 | 12733 | 177 |
1749090 | 1749090 | 2021-09-24 | Adams | Indiana | 18001 | 4525 | 69 |
1749183 | 1749183 | 2021-09-24 | Adams | Iowa | 19003 | 425 | 4 |
1749801 | 1749801 | 2021-09-24 | Adams | Mississippi | 28001 | 4416 | 116 |
1750056 | 1750056 | 2021-09-24 | Adams | Nebraska | 31001 | 3595 | 54 |
1750391 | 1750391 | 2021-09-24 | Adams | North Dakota | 38001 | 330 | 4 |
1750447 | 1750447 | 2021-09-24 | Adams | Ohio | 39001 | 3668 | 75 |
1750650 | 1750650 | 2021-09-24 | Adams | Pennsylvania | 42001 | 11713 | 196 |
1751445 | 1751445 | 2021-09-24 | Adams | Washington | 53001 | 2958 | 26 |
1751539 | 1751539 | 2021-09-24 | Adams | Wisconsin | 55001 | 2444 | 31 |
1745380 | 1745380 | 2021-09-23 | Adams | Colorado | 8001 | 71189 | 834 |
1745694 | 1745694 | 2021-09-23 | Adams | Idaho | 16003 | 441 | 8 |
1745737 | 1745737 | 2021-09-23 | Adams | Illinois | 17001 | 12718 | 177 |
1745840 | 1745840 | 2021-09-23 | Adams | Indiana | 18001 | 4520 | 69 |
1745933 | 1745933 | 2021-09-23 | Adams | Iowa | 19003 | 425 | 4 |
1746551 | 1746551 | 2021-09-23 | Adams | Mississippi | 28001 | 4403 | 116 |
1746806 | 1746806 | 2021-09-23 | Adams | Nebraska | 31001 | 3584 | 54 |
1747141 | 1747141 | 2021-09-23 | Adams | North Dakota | 38001 | 329 | 4 |
1747197 | 1747197 | 2021-09-23 | Adams | Ohio | 39001 | 3635 | 75 |
1747401 | 1747401 | 2021-09-23 | Adams | Pennsylvania | 42001 | 11666 | 196 |
1748196 | 1748196 | 2021-09-23 | Adams | Washington | 53001 | 2940 | 26 |
1748290 | 1748290 | 2021-09-23 | Adams | Wisconsin | 55001 | 2421 | 31 |
1742131 | 1742131 | 2021-09-22 | Adams | Colorado | 8001 | 70897 | 831 |
1742445 | 1742445 | 2021-09-22 | Adams | Idaho | 16003 | 440 | 8 |
1742488 | 1742488 | 2021-09-22 | Adams | Illinois | 17001 | 12695 | 177 |
1742591 | 1742591 | 2021-09-22 | Adams | Indiana | 18001 | 4505 | 69 |
1742684 | 1742684 | 2021-09-22 | Adams | Iowa | 19003 | 425 | 4 |
1743302 | 1743302 | 2021-09-22 | Adams | Mississippi | 28001 | 4376 | 116 |
1743557 | 1743557 | 2021-09-22 | Adams | Nebraska | 31001 | 3565 | 54 |
1743892 | 1743892 | 2021-09-22 | Adams | North Dakota | 38001 | 328 | 4 |
1743948 | 1743948 | 2021-09-22 | Adams | Ohio | 39001 | 3606 | 75 |
1744151 | 1744151 | 2021-09-22 | Adams | Pennsylvania | 42001 | 11629 | 196 |
1744946 | 1744946 | 2021-09-22 | Adams | Washington | 53001 | 2918 | 26 |
1745040 | 1745040 | 2021-09-22 | Adams | Wisconsin | 55001 | 2390 | 31 |
1738882 | 1738882 | 2021-09-21 | Adams | Colorado | 8001 | 70897 | 831 |
1739196 | 1739196 | 2021-09-21 | Adams | Idaho | 16003 | 438 | 8 |
1739239 | 1739239 | 2021-09-21 | Adams | Illinois | 17001 | 12662 | 176 |
1739342 | 1739342 | 2021-09-21 | Adams | Indiana | 18001 | 4490 | 67 |
1739435 | 1739435 | 2021-09-21 | Adams | Iowa | 19003 | 391 | 4 |
1740053 | 1740053 | 2021-09-21 | Adams | Mississippi | 28001 | 4365 | 116 |
1740308 | 1740308 | 2021-09-21 | Adams | Nebraska | 31001 | 3543 | 54 |
1740643 | 1740643 | 2021-09-21 | Adams | North Dakota | 38001 | 327 | 3 |
1740699 | 1740699 | 2021-09-21 | Adams | Ohio | 39001 | 3537 | 75 |
1740902 | 1740902 | 2021-09-21 | Adams | Pennsylvania | 42001 | 11571 | 196 |
1741697 | 1741697 | 2021-09-21 | Adams | Washington | 53001 | 2907 | 25 |
1741791 | 1741791 | 2021-09-21 | Adams | Wisconsin | 55001 | 2384 | 30 |
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);