ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815424 | 1815424 | 2021-10-14 | Williams | North Dakota | 38105 | 6525 | 48 |
1812176 | 1812176 | 2021-10-13 | Williams | North Dakota | 38105 | 6485 | 48 |
1808927 | 1808927 | 2021-10-12 | Williams | North Dakota | 38105 | 6448 | 47 |
1805676 | 1805676 | 2021-10-11 | Williams | North Dakota | 38105 | 6410 | 46 |
1802427 | 1802427 | 2021-10-10 | Williams | North Dakota | 38105 | 6394 | 46 |
1799178 | 1799178 | 2021-10-09 | Williams | North Dakota | 38105 | 6376 | 46 |
1795929 | 1795929 | 2021-10-08 | Williams | North Dakota | 38105 | 6363 | 46 |
1792680 | 1792680 | 2021-10-07 | Williams | North Dakota | 38105 | 6317 | 46 |
1789431 | 1789431 | 2021-10-06 | Williams | North Dakota | 38105 | 6265 | 45 |
1786183 | 1786183 | 2021-10-05 | Williams | North Dakota | 38105 | 6224 | 44 |
1782934 | 1782934 | 2021-10-04 | Williams | North Dakota | 38105 | 6181 | 43 |
1779685 | 1779685 | 2021-10-03 | Williams | North Dakota | 38105 | 6171 | 43 |
1776435 | 1776435 | 2021-10-02 | Williams | North Dakota | 38105 | 6159 | 43 |
1773185 | 1773185 | 2021-10-01 | Williams | North Dakota | 38105 | 6138 | 43 |
1769935 | 1769935 | 2021-09-30 | Williams | North Dakota | 38105 | 6106 | 43 |
1766686 | 1766686 | 2021-09-29 | Williams | North Dakota | 38105 | 6076 | 43 |
1763437 | 1763437 | 2021-09-28 | Williams | North Dakota | 38105 | 6046 | 43 |
1760188 | 1760188 | 2021-09-27 | Williams | North Dakota | 38105 | 6000 | 43 |
1756940 | 1756940 | 2021-09-26 | Williams | North Dakota | 38105 | 5991 | 43 |
1753692 | 1753692 | 2021-09-25 | Williams | North Dakota | 38105 | 5972 | 43 |
1750444 | 1750444 | 2021-09-24 | Williams | North Dakota | 38105 | 5931 | 43 |
1747194 | 1747194 | 2021-09-23 | Williams | North Dakota | 38105 | 5905 | 43 |
1743945 | 1743945 | 2021-09-22 | Williams | North Dakota | 38105 | 5869 | 43 |
1740696 | 1740696 | 2021-09-21 | Williams | North Dakota | 38105 | 5846 | 43 |
1737447 | 1737447 | 2021-09-20 | Williams | North Dakota | 38105 | 5830 | 43 |
1734197 | 1734197 | 2021-09-19 | Williams | North Dakota | 38105 | 5825 | 43 |
1730947 | 1730947 | 2021-09-18 | Williams | North Dakota | 38105 | 5810 | 43 |
1727697 | 1727697 | 2021-09-17 | Williams | North Dakota | 38105 | 5776 | 42 |
1724448 | 1724448 | 2021-09-16 | Williams | North Dakota | 38105 | 5764 | 42 |
1721199 | 1721199 | 2021-09-15 | Williams | North Dakota | 38105 | 5730 | 42 |
1717951 | 1717951 | 2021-09-14 | Williams | North Dakota | 38105 | 5691 | 42 |
1714703 | 1714703 | 2021-09-13 | Williams | North Dakota | 38105 | 5681 | 42 |
1711457 | 1711457 | 2021-09-12 | Williams | North Dakota | 38105 | 5678 | 42 |
1708210 | 1708210 | 2021-09-11 | Williams | North Dakota | 38105 | 5667 | 42 |
1704963 | 1704963 | 2021-09-10 | Williams | North Dakota | 38105 | 5646 | 42 |
1701713 | 1701713 | 2021-09-09 | Williams | North Dakota | 38105 | 5605 | 42 |
1698464 | 1698464 | 2021-09-08 | Williams | North Dakota | 38105 | 5572 | 42 |
1695216 | 1695216 | 2021-09-07 | Williams | North Dakota | 38105 | 5558 | 42 |
1691968 | 1691968 | 2021-09-06 | Williams | North Dakota | 38105 | 5545 | 42 |
1688718 | 1688718 | 2021-09-05 | Williams | North Dakota | 38105 | 5541 | 42 |
1685468 | 1685468 | 2021-09-04 | Williams | North Dakota | 38105 | 5530 | 42 |
1682217 | 1682217 | 2021-09-03 | Williams | North Dakota | 38105 | 5494 | 42 |
1678968 | 1678968 | 2021-09-02 | Williams | North Dakota | 38105 | 5468 | 42 |
1675720 | 1675720 | 2021-09-01 | Williams | North Dakota | 38105 | 5423 | 42 |
1672473 | 1672473 | 2021-08-31 | Williams | North Dakota | 38105 | 5392 | 42 |
1669225 | 1669225 | 2021-08-30 | Williams | North Dakota | 38105 | 5379 | 42 |
1665978 | 1665978 | 2021-08-29 | Williams | North Dakota | 38105 | 5373 | 42 |
1662730 | 1662730 | 2021-08-28 | Williams | North Dakota | 38105 | 5362 | 42 |
1659482 | 1659482 | 2021-08-27 | Williams | North Dakota | 38105 | 5328 | 42 |
1656233 | 1656233 | 2021-08-26 | Williams | North Dakota | 38105 | 5309 | 42 |
1652986 | 1652986 | 2021-08-25 | Williams | North Dakota | 38105 | 5275 | 42 |
1649738 | 1649738 | 2021-08-24 | Williams | North Dakota | 38105 | 5253 | 42 |
1646489 | 1646489 | 2021-08-23 | Williams | North Dakota | 38105 | 5229 | 41 |
1643240 | 1643240 | 2021-08-22 | Williams | North Dakota | 38105 | 5222 | 41 |
1639990 | 1639990 | 2021-08-21 | Williams | North Dakota | 38105 | 5217 | 41 |
1636740 | 1636740 | 2021-08-20 | Williams | North Dakota | 38105 | 5200 | 41 |
1633490 | 1633490 | 2021-08-19 | Williams | North Dakota | 38105 | 5191 | 40 |
1630243 | 1630243 | 2021-08-18 | Williams | North Dakota | 38105 | 5177 | 40 |
1626996 | 1626996 | 2021-08-17 | Williams | North Dakota | 38105 | 5161 | 40 |
1623749 | 1623749 | 2021-08-16 | Williams | North Dakota | 38105 | 5153 | 40 |
1620502 | 1620502 | 2021-08-15 | Williams | North Dakota | 38105 | 5152 | 40 |
1617254 | 1617254 | 2021-08-14 | Williams | North Dakota | 38105 | 5149 | 40 |
1614006 | 1614006 | 2021-08-13 | Williams | North Dakota | 38105 | 5145 | 40 |
1610757 | 1610757 | 2021-08-12 | Williams | North Dakota | 38105 | 5141 | 40 |
1607509 | 1607509 | 2021-08-11 | Williams | North Dakota | 38105 | 5130 | 40 |
1604260 | 1604260 | 2021-08-10 | Williams | North Dakota | 38105 | 5125 | 40 |
1601011 | 1601011 | 2021-08-09 | Williams | North Dakota | 38105 | 5118 | 40 |
1597763 | 1597763 | 2021-08-08 | Williams | North Dakota | 38105 | 5118 | 40 |
1594514 | 1594514 | 2021-08-07 | Williams | North Dakota | 38105 | 5115 | 40 |
1591265 | 1591265 | 2021-08-06 | Williams | North Dakota | 38105 | 5105 | 40 |
1588016 | 1588016 | 2021-08-05 | Williams | North Dakota | 38105 | 5104 | 40 |
1584766 | 1584766 | 2021-08-04 | Williams | North Dakota | 38105 | 5098 | 40 |
1581516 | 1581516 | 2021-08-03 | Williams | North Dakota | 38105 | 5091 | 40 |
1578267 | 1578267 | 2021-08-02 | Williams | North Dakota | 38105 | 5087 | 40 |
1575019 | 1575019 | 2021-08-01 | Williams | North Dakota | 38105 | 5087 | 40 |
1571771 | 1571771 | 2021-07-31 | Williams | North Dakota | 38105 | 5087 | 40 |
1568523 | 1568523 | 2021-07-30 | Williams | North Dakota | 38105 | 5085 | 40 |
1565275 | 1565275 | 2021-07-29 | Williams | North Dakota | 38105 | 5079 | 40 |
1562027 | 1562027 | 2021-07-28 | Williams | North Dakota | 38105 | 5073 | 40 |
1558779 | 1558779 | 2021-07-27 | Williams | North Dakota | 38105 | 5071 | 40 |
1555532 | 1555532 | 2021-07-26 | Williams | North Dakota | 38105 | 5069 | 40 |
1552285 | 1552285 | 2021-07-25 | Williams | North Dakota | 38105 | 5069 | 40 |
1549038 | 1549038 | 2021-07-24 | Williams | North Dakota | 38105 | 5070 | 40 |
1545791 | 1545791 | 2021-07-23 | Williams | North Dakota | 38105 | 5067 | 40 |
1542544 | 1542544 | 2021-07-22 | Williams | North Dakota | 38105 | 5065 | 40 |
1539296 | 1539296 | 2021-07-21 | Williams | North Dakota | 38105 | 5063 | 40 |
1536049 | 1536049 | 2021-07-20 | Williams | North Dakota | 38105 | 5061 | 40 |
1532801 | 1532801 | 2021-07-19 | Williams | North Dakota | 38105 | 5061 | 40 |
1529554 | 1529554 | 2021-07-18 | Williams | North Dakota | 38105 | 5061 | 40 |
1526307 | 1526307 | 2021-07-17 | Williams | North Dakota | 38105 | 5061 | 40 |
1523060 | 1523060 | 2021-07-16 | Williams | North Dakota | 38105 | 5061 | 40 |
1519812 | 1519812 | 2021-07-15 | Williams | North Dakota | 38105 | 5061 | 40 |
1516564 | 1516564 | 2021-07-14 | Williams | North Dakota | 38105 | 5059 | 40 |
1513317 | 1513317 | 2021-07-13 | Williams | North Dakota | 38105 | 5054 | 40 |
1510071 | 1510071 | 2021-07-12 | Williams | North Dakota | 38105 | 5054 | 40 |
1506824 | 1506824 | 2021-07-11 | Williams | North Dakota | 38105 | 5055 | 40 |
1503578 | 1503578 | 2021-07-10 | Williams | North Dakota | 38105 | 5054 | 40 |
1500332 | 1500332 | 2021-07-09 | Williams | North Dakota | 38105 | 5048 | 40 |
1497086 | 1497086 | 2021-07-08 | Williams | North Dakota | 38105 | 5045 | 40 |
1493839 | 1493839 | 2021-07-07 | Williams | North Dakota | 38105 | 5042 | 40 |
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);