ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Adams" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1792037 | 1792037 | 2021-10-07 | Adams | Mississippi | 28001 | 4524 | 119 |
1788788 | 1788788 | 2021-10-06 | Adams | Mississippi | 28001 | 4506 | 119 |
1785540 | 1785540 | 2021-10-05 | Adams | Mississippi | 28001 | 4498 | 119 |
1782291 | 1782291 | 2021-10-04 | Adams | Mississippi | 28001 | 4471 | 119 |
1779041 | 1779041 | 2021-10-03 | Adams | Mississippi | 28001 | 4462 | 118 |
1775791 | 1775791 | 2021-10-02 | Adams | Mississippi | 28001 | 4462 | 118 |
1772541 | 1772541 | 2021-10-01 | Adams | Mississippi | 28001 | 4462 | 118 |
1769292 | 1769292 | 2021-09-30 | Adams | Mississippi | 28001 | 4458 | 117 |
1766043 | 1766043 | 2021-09-29 | Adams | Mississippi | 28001 | 4443 | 117 |
1762794 | 1762794 | 2021-09-28 | Adams | Mississippi | 28001 | 4436 | 117 |
1759545 | 1759545 | 2021-09-27 | Adams | Mississippi | 28001 | 4429 | 117 |
1756297 | 1756297 | 2021-09-26 | Adams | Mississippi | 28001 | 4416 | 116 |
1753049 | 1753049 | 2021-09-25 | Adams | Mississippi | 28001 | 4416 | 116 |
1749801 | 1749801 | 2021-09-24 | Adams | Mississippi | 28001 | 4416 | 116 |
1746551 | 1746551 | 2021-09-23 | Adams | Mississippi | 28001 | 4403 | 116 |
1743302 | 1743302 | 2021-09-22 | Adams | Mississippi | 28001 | 4376 | 116 |
1740053 | 1740053 | 2021-09-21 | Adams | Mississippi | 28001 | 4365 | 116 |
1736804 | 1736804 | 2021-09-20 | Adams | Mississippi | 28001 | 4309 | 114 |
1733554 | 1733554 | 2021-09-19 | Adams | Mississippi | 28001 | 4219 | 114 |
1730304 | 1730304 | 2021-09-18 | Adams | Mississippi | 28001 | 4219 | 114 |
1727054 | 1727054 | 2021-09-17 | Adams | Mississippi | 28001 | 4219 | 114 |
1723805 | 1723805 | 2021-09-16 | Adams | Mississippi | 28001 | 4184 | 110 |
1720556 | 1720556 | 2021-09-15 | Adams | Mississippi | 28001 | 4174 | 109 |
1717308 | 1717308 | 2021-09-14 | Adams | Mississippi | 28001 | 4166 | 109 |
1714060 | 1714060 | 2021-09-13 | Adams | Mississippi | 28001 | 4141 | 109 |
1710814 | 1710814 | 2021-09-12 | Adams | Mississippi | 28001 | 4125 | 109 |
1707567 | 1707567 | 2021-09-11 | Adams | Mississippi | 28001 | 4125 | 109 |
1704320 | 1704320 | 2021-09-10 | Adams | Mississippi | 28001 | 4125 | 109 |
1701070 | 1701070 | 2021-09-09 | Adams | Mississippi | 28001 | 4116 | 109 |
1697821 | 1697821 | 2021-09-08 | Adams | Mississippi | 28001 | 4103 | 109 |
1694573 | 1694573 | 2021-09-07 | Adams | Mississippi | 28001 | 4101 | 109 |
1691324 | 1691324 | 2021-09-06 | Adams | Mississippi | 28001 | 4095 | 109 |
1688074 | 1688074 | 2021-09-05 | Adams | Mississippi | 28001 | 4038 | 107 |
1684824 | 1684824 | 2021-09-04 | Adams | Mississippi | 28001 | 4038 | 107 |
1681573 | 1681573 | 2021-09-03 | Adams | Mississippi | 28001 | 4038 | 107 |
1678325 | 1678325 | 2021-09-02 | Adams | Mississippi | 28001 | 3990 | 107 |
1675077 | 1675077 | 2021-09-01 | Adams | Mississippi | 28001 | 3982 | 107 |
1671829 | 1671829 | 2021-08-31 | Adams | Mississippi | 28001 | 3972 | 106 |
1668582 | 1668582 | 2021-08-30 | Adams | Mississippi | 28001 | 3971 | 106 |
1665335 | 1665335 | 2021-08-29 | Adams | Mississippi | 28001 | 3947 | 105 |
1662087 | 1662087 | 2021-08-28 | Adams | Mississippi | 28001 | 3947 | 105 |
1658839 | 1658839 | 2021-08-27 | Adams | Mississippi | 28001 | 3947 | 105 |
1655590 | 1655590 | 2021-08-26 | Adams | Mississippi | 28001 | 3922 | 102 |
1652343 | 1652343 | 2021-08-25 | Adams | Mississippi | 28001 | 3910 | 102 |
1649095 | 1649095 | 2021-08-24 | Adams | Mississippi | 28001 | 3888 | 101 |
1645846 | 1645846 | 2021-08-23 | Adams | Mississippi | 28001 | 3872 | 99 |
1642597 | 1642597 | 2021-08-22 | Adams | Mississippi | 28001 | 3853 | 98 |
1639347 | 1639347 | 2021-08-21 | Adams | Mississippi | 28001 | 3853 | 98 |
1636097 | 1636097 | 2021-08-20 | Adams | Mississippi | 28001 | 3853 | 98 |
1632847 | 1632847 | 2021-08-19 | Adams | Mississippi | 28001 | 3840 | 94 |
1629600 | 1629600 | 2021-08-18 | Adams | Mississippi | 28001 | 3822 | 94 |
1626353 | 1626353 | 2021-08-17 | Adams | Mississippi | 28001 | 3800 | 93 |
1623106 | 1623106 | 2021-08-16 | Adams | Mississippi | 28001 | 3790 | 93 |
1619859 | 1619859 | 2021-08-15 | Adams | Mississippi | 28001 | 3759 | 90 |
1616611 | 1616611 | 2021-08-14 | Adams | Mississippi | 28001 | 3759 | 90 |
1613363 | 1613363 | 2021-08-13 | Adams | Mississippi | 28001 | 3759 | 90 |
1610114 | 1610114 | 2021-08-12 | Adams | Mississippi | 28001 | 3672 | 90 |
1606866 | 1606866 | 2021-08-11 | Adams | Mississippi | 28001 | 3645 | 90 |
1603617 | 1603617 | 2021-08-10 | Adams | Mississippi | 28001 | 3619 | 90 |
1600368 | 1600368 | 2021-08-09 | Adams | Mississippi | 28001 | 3602 | 90 |
1597120 | 1597120 | 2021-08-08 | Adams | Mississippi | 28001 | 3552 | 90 |
1593871 | 1593871 | 2021-08-07 | Adams | Mississippi | 28001 | 3552 | 90 |
1590622 | 1590622 | 2021-08-06 | Adams | Mississippi | 28001 | 3552 | 90 |
1587373 | 1587373 | 2021-08-05 | Adams | Mississippi | 28001 | 3539 | 90 |
1584122 | 1584122 | 2021-08-04 | Adams | Mississippi | 28001 | 3506 | 90 |
1580873 | 1580873 | 2021-08-03 | Adams | Mississippi | 28001 | 3474 | 90 |
1577624 | 1577624 | 2021-08-02 | Adams | Mississippi | 28001 | 3453 | 88 |
1574376 | 1574376 | 2021-08-01 | Adams | Mississippi | 28001 | 3409 | 88 |
1571128 | 1571128 | 2021-07-31 | Adams | Mississippi | 28001 | 3409 | 88 |
1567880 | 1567880 | 2021-07-30 | Adams | Mississippi | 28001 | 3409 | 88 |
1564632 | 1564632 | 2021-07-29 | Adams | Mississippi | 28001 | 3405 | 88 |
1561384 | 1561384 | 2021-07-28 | Adams | Mississippi | 28001 | 3397 | 88 |
1558136 | 1558136 | 2021-07-27 | Adams | Mississippi | 28001 | 3384 | 88 |
1554889 | 1554889 | 2021-07-26 | Adams | Mississippi | 28001 | 3363 | 87 |
1551642 | 1551642 | 2021-07-25 | Adams | Mississippi | 28001 | 3333 | 87 |
1548395 | 1548395 | 2021-07-24 | Adams | Mississippi | 28001 | 3333 | 87 |
1545148 | 1545148 | 2021-07-23 | Adams | Mississippi | 28001 | 3333 | 87 |
1541900 | 1541900 | 2021-07-22 | Adams | Mississippi | 28001 | 3319 | 87 |
1538653 | 1538653 | 2021-07-21 | Adams | Mississippi | 28001 | 3302 | 87 |
1535406 | 1535406 | 2021-07-20 | Adams | Mississippi | 28001 | 3298 | 87 |
1532158 | 1532158 | 2021-07-19 | Adams | Mississippi | 28001 | 3291 | 87 |
1528911 | 1528911 | 2021-07-18 | Adams | Mississippi | 28001 | 3259 | 87 |
1525664 | 1525664 | 2021-07-17 | Adams | Mississippi | 28001 | 3259 | 87 |
1522417 | 1522417 | 2021-07-16 | Adams | Mississippi | 28001 | 3259 | 87 |
1519168 | 1519168 | 2021-07-15 | Adams | Mississippi | 28001 | 3238 | 87 |
1515921 | 1515921 | 2021-07-14 | Adams | Mississippi | 28001 | 3215 | 87 |
1512675 | 1512675 | 2021-07-13 | Adams | Mississippi | 28001 | 3183 | 86 |
1509428 | 1509428 | 2021-07-12 | Adams | Mississippi | 28001 | 3165 | 86 |
1506182 | 1506182 | 2021-07-11 | Adams | Mississippi | 28001 | 3151 | 86 |
1502936 | 1502936 | 2021-07-10 | Adams | Mississippi | 28001 | 3151 | 86 |
1499690 | 1499690 | 2021-07-09 | Adams | Mississippi | 28001 | 3151 | 86 |
1496444 | 1496444 | 2021-07-08 | Adams | Mississippi | 28001 | 3145 | 86 |
1493197 | 1493197 | 2021-07-07 | Adams | Mississippi | 28001 | 3141 | 86 |
1489950 | 1489950 | 2021-07-06 | Adams | Mississippi | 28001 | 3136 | 86 |
1486703 | 1486703 | 2021-07-05 | Adams | Mississippi | 28001 | 3128 | 86 |
1483457 | 1483457 | 2021-07-04 | Adams | Mississippi | 28001 | 3128 | 86 |
1480211 | 1480211 | 2021-07-03 | Adams | Mississippi | 28001 | 3128 | 86 |
1476964 | 1476964 | 2021-07-02 | Adams | Mississippi | 28001 | 3128 | 86 |
1473718 | 1473718 | 2021-07-01 | Adams | Mississippi | 28001 | 3126 | 86 |
1470472 | 1470472 | 2021-06-30 | Adams | Mississippi | 28001 | 3124 | 86 |
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);