ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1806914 | 1806914 | 2021-10-12 | Marion | Alabama | 1093 | 4925 | 126 |
1803663 | 1803663 | 2021-10-11 | Marion | Alabama | 1093 | 4916 | 126 |
1800414 | 1800414 | 2021-10-10 | Marion | Alabama | 1093 | 4914 | 126 |
1797165 | 1797165 | 2021-10-09 | Marion | Alabama | 1093 | 4912 | 126 |
1793916 | 1793916 | 2021-10-08 | Marion | Alabama | 1093 | 4906 | 126 |
1790667 | 1790667 | 2021-10-07 | Marion | Alabama | 1093 | 4903 | 126 |
1787419 | 1787419 | 2021-10-06 | Marion | Alabama | 1093 | 4899 | 126 |
1784170 | 1784170 | 2021-10-05 | Marion | Alabama | 1093 | 4891 | 125 |
1780921 | 1780921 | 2021-10-04 | Marion | Alabama | 1093 | 4876 | 125 |
1777671 | 1777671 | 2021-10-03 | Marion | Alabama | 1093 | 4873 | 125 |
1774421 | 1774421 | 2021-10-02 | Marion | Alabama | 1093 | 4868 | 125 |
1771171 | 1771171 | 2021-10-01 | Marion | Alabama | 1093 | 4861 | 124 |
1767922 | 1767922 | 2021-09-30 | Marion | Alabama | 1093 | 4853 | 123 |
1764673 | 1764673 | 2021-09-29 | Marion | Alabama | 1093 | 4840 | 122 |
1761424 | 1761424 | 2021-09-28 | Marion | Alabama | 1093 | 4830 | 121 |
1758176 | 1758176 | 2021-09-27 | Marion | Alabama | 1093 | 4818 | 120 |
1754928 | 1754928 | 2021-09-26 | Marion | Alabama | 1093 | 4800 | 120 |
1751680 | 1751680 | 2021-09-25 | Marion | Alabama | 1093 | 4789 | 120 |
1748431 | 1748431 | 2021-09-24 | Marion | Alabama | 1093 | 4769 | 117 |
1745181 | 1745181 | 2021-09-23 | Marion | Alabama | 1093 | 4748 | 116 |
1741932 | 1741932 | 2021-09-22 | Marion | Alabama | 1093 | 4734 | 115 |
1738683 | 1738683 | 2021-09-21 | Marion | Alabama | 1093 | 4698 | 115 |
1735434 | 1735434 | 2021-09-20 | Marion | Alabama | 1093 | 4655 | 115 |
1732184 | 1732184 | 2021-09-19 | Marion | Alabama | 1093 | 4647 | 115 |
1728934 | 1728934 | 2021-09-18 | Marion | Alabama | 1093 | 4628 | 115 |
1725684 | 1725684 | 2021-09-17 | Marion | Alabama | 1093 | 4579 | 114 |
1722435 | 1722435 | 2021-09-16 | Marion | Alabama | 1093 | 4540 | 114 |
1719187 | 1719187 | 2021-09-15 | Marion | Alabama | 1093 | 4490 | 114 |
1715939 | 1715939 | 2021-09-14 | Marion | Alabama | 1093 | 4464 | 114 |
1712693 | 1712693 | 2021-09-13 | Marion | Alabama | 1093 | 4438 | 113 |
1709446 | 1709446 | 2021-09-12 | Marion | Alabama | 1093 | 4424 | 113 |
1706199 | 1706199 | 2021-09-11 | Marion | Alabama | 1093 | 4417 | 113 |
1702951 | 1702951 | 2021-09-10 | Marion | Alabama | 1093 | 4365 | 112 |
1699701 | 1699701 | 2021-09-09 | Marion | Alabama | 1093 | 4332 | 112 |
1696452 | 1696452 | 2021-09-08 | Marion | Alabama | 1093 | 4292 | 111 |
1693204 | 1693204 | 2021-09-07 | Marion | Alabama | 1093 | 4250 | 111 |
1689955 | 1689955 | 2021-09-06 | Marion | Alabama | 1093 | 4230 | 111 |
1686705 | 1686705 | 2021-09-05 | Marion | Alabama | 1093 | 4219 | 111 |
1683455 | 1683455 | 2021-09-04 | Marion | Alabama | 1093 | 4216 | 111 |
1680204 | 1680204 | 2021-09-03 | Marion | Alabama | 1093 | 4185 | 111 |
1676956 | 1676956 | 2021-09-02 | Marion | Alabama | 1093 | 4143 | 110 |
1673709 | 1673709 | 2021-09-01 | Marion | Alabama | 1093 | 4119 | 110 |
1670461 | 1670461 | 2021-08-31 | Marion | Alabama | 1093 | 4094 | 110 |
1667214 | 1667214 | 2021-08-30 | Marion | Alabama | 1093 | 4066 | 110 |
1663966 | 1663966 | 2021-08-29 | Marion | Alabama | 1093 | 4057 | 110 |
1660718 | 1660718 | 2021-08-28 | Marion | Alabama | 1093 | 4045 | 110 |
1657470 | 1657470 | 2021-08-27 | Marion | Alabama | 1093 | 4003 | 110 |
1654222 | 1654222 | 2021-08-26 | Marion | Alabama | 1093 | 3965 | 108 |
1650976 | 1650976 | 2021-08-25 | Marion | Alabama | 1093 | 3893 | 108 |
1647727 | 1647727 | 2021-08-24 | Marion | Alabama | 1093 | 3893 | 108 |
1644478 | 1644478 | 2021-08-23 | Marion | Alabama | 1093 | 3893 | 108 |
1641228 | 1641228 | 2021-08-22 | Marion | Alabama | 1093 | 3882 | 108 |
1637978 | 1637978 | 2021-08-21 | Marion | Alabama | 1093 | 3860 | 108 |
1634728 | 1634728 | 2021-08-20 | Marion | Alabama | 1093 | 3833 | 108 |
1631480 | 1631480 | 2021-08-19 | Marion | Alabama | 1093 | 3818 | 108 |
1628233 | 1628233 | 2021-08-18 | Marion | Alabama | 1093 | 3791 | 108 |
1624986 | 1624986 | 2021-08-17 | Marion | Alabama | 1093 | 3761 | 108 |
1621739 | 1621739 | 2021-08-16 | Marion | Alabama | 1093 | 3729 | 108 |
1618491 | 1618491 | 2021-08-15 | Marion | Alabama | 1093 | 3725 | 108 |
1615243 | 1615243 | 2021-08-14 | Marion | Alabama | 1093 | 3685 | 108 |
1611994 | 1611994 | 2021-08-13 | Marion | Alabama | 1093 | 3685 | 108 |
1608747 | 1608747 | 2021-08-12 | Marion | Alabama | 1093 | 3659 | 107 |
1605498 | 1605498 | 2021-08-11 | Marion | Alabama | 1093 | 3637 | 107 |
1602248 | 1602248 | 2021-08-10 | Marion | Alabama | 1093 | 3620 | 107 |
1599000 | 1599000 | 2021-08-09 | Marion | Alabama | 1093 | 3591 | 107 |
1595751 | 1595751 | 2021-08-08 | Marion | Alabama | 1093 | 3568 | 107 |
1592502 | 1592502 | 2021-08-07 | Marion | Alabama | 1093 | 3568 | 107 |
1589253 | 1589253 | 2021-08-06 | Marion | Alabama | 1093 | 3540 | 107 |
1586004 | 1586004 | 2021-08-05 | Marion | Alabama | 1093 | 3511 | 107 |
1582754 | 1582754 | 2021-08-04 | Marion | Alabama | 1093 | 3490 | 107 |
1579504 | 1579504 | 2021-08-03 | Marion | Alabama | 1093 | 3470 | 107 |
1576256 | 1576256 | 2021-08-02 | Marion | Alabama | 1093 | 3465 | 107 |
1573008 | 1573008 | 2021-08-01 | Marion | Alabama | 1093 | 3463 | 107 |
1569760 | 1569760 | 2021-07-31 | Marion | Alabama | 1093 | 3455 | 107 |
1566512 | 1566512 | 2021-07-30 | Marion | Alabama | 1093 | 3436 | 106 |
1563264 | 1563264 | 2021-07-29 | Marion | Alabama | 1093 | 3436 | 106 |
1560016 | 1560016 | 2021-07-28 | Marion | Alabama | 1093 | 3427 | 106 |
1556769 | 1556769 | 2021-07-27 | Marion | Alabama | 1093 | 3413 | 106 |
1553522 | 1553522 | 2021-07-26 | Marion | Alabama | 1093 | 3388 | 106 |
1550275 | 1550275 | 2021-07-25 | Marion | Alabama | 1093 | 3380 | 106 |
1547028 | 1547028 | 2021-07-24 | Marion | Alabama | 1093 | 3378 | 106 |
1543781 | 1543781 | 2021-07-23 | Marion | Alabama | 1093 | 3371 | 106 |
1540533 | 1540533 | 2021-07-22 | Marion | Alabama | 1093 | 3354 | 106 |
1537286 | 1537286 | 2021-07-21 | Marion | Alabama | 1093 | 3349 | 106 |
1534038 | 1534038 | 2021-07-20 | Marion | Alabama | 1093 | 3346 | 106 |
1530791 | 1530791 | 2021-07-19 | Marion | Alabama | 1093 | 3341 | 106 |
1527544 | 1527544 | 2021-07-18 | Marion | Alabama | 1093 | 3341 | 106 |
1524297 | 1524297 | 2021-07-17 | Marion | Alabama | 1093 | 3330 | 106 |
1521049 | 1521049 | 2021-07-16 | Marion | Alabama | 1093 | 3324 | 106 |
1517801 | 1517801 | 2021-07-15 | Marion | Alabama | 1093 | 3322 | 106 |
1514554 | 1514554 | 2021-07-14 | Marion | Alabama | 1093 | 3317 | 106 |
1511308 | 1511308 | 2021-07-13 | Marion | Alabama | 1093 | 3311 | 106 |
1508061 | 1508061 | 2021-07-12 | Marion | Alabama | 1093 | 3311 | 106 |
1504815 | 1504815 | 2021-07-11 | Marion | Alabama | 1093 | 3305 | 106 |
1501569 | 1501569 | 2021-07-10 | Marion | Alabama | 1093 | 3305 | 106 |
1498323 | 1498323 | 2021-07-09 | Marion | Alabama | 1093 | 3299 | 106 |
1495076 | 1495076 | 2021-07-08 | Marion | Alabama | 1093 | 3295 | 106 |
1491829 | 1491829 | 2021-07-07 | Marion | Alabama | 1093 | 3295 | 106 |
1488582 | 1488582 | 2021-07-06 | Marion | Alabama | 1093 | 3286 | 106 |
1485335 | 1485335 | 2021-07-05 | Marion | Alabama | 1093 | 3286 | 106 |
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);