ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
313 rows where deaths = 57 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Carteret 49
- Yadkin 21
- Anson 20
- Chatham 17
- Orange 15
- Johnston 14
- Columbus 13
- Bertie 12
- Stanly 12
- Yancey 10
- Randolph 8
- Lincoln 7
- Polk 7
- Catawba 6
- Granville 6
- Martin 6
- Transylvania 6
- Ashe 5
- Craven 5
- Sampson 5
- Wilson 5
- Buncombe 4
- Burke 4
- Gaston 4
- Madison 4
- Scotland 4
- Wayne 4
- Franklin 3
- Halifax 3
- Haywood 3
- …
state 1
- North Carolina · 313 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501585 | 2501585 | 2022-05-13 | Yancey | North Carolina | 37199 | 5353 | 57 |
2498327 | 2498327 | 2022-05-12 | Yancey | North Carolina | 37199 | 5353 | 57 |
2495069 | 2495069 | 2022-05-11 | Yancey | North Carolina | 37199 | 5353 | 57 |
2491811 | 2491811 | 2022-05-10 | Yancey | North Carolina | 37199 | 5331 | 57 |
2488553 | 2488553 | 2022-05-09 | Yancey | North Carolina | 37199 | 5331 | 57 |
2485296 | 2485296 | 2022-05-08 | Yancey | North Carolina | 37199 | 5331 | 57 |
2482038 | 2482038 | 2022-05-07 | Yancey | North Carolina | 37199 | 5331 | 57 |
2478780 | 2478780 | 2022-05-06 | Yancey | North Carolina | 37199 | 5331 | 57 |
2475522 | 2475522 | 2022-05-05 | Yancey | North Carolina | 37199 | 5331 | 57 |
2472265 | 2472265 | 2022-05-04 | Yancey | North Carolina | 37199 | 5331 | 57 |
2468984 | 2468984 | 2022-05-03 | Polk | North Carolina | 37149 | 3901 | 57 |
2465728 | 2465728 | 2022-05-02 | Polk | North Carolina | 37149 | 3901 | 57 |
2462473 | 2462473 | 2022-05-01 | Polk | North Carolina | 37149 | 3901 | 57 |
2459217 | 2459217 | 2022-04-30 | Polk | North Carolina | 37149 | 3901 | 57 |
2455961 | 2455961 | 2022-04-29 | Polk | North Carolina | 37149 | 3901 | 57 |
2452705 | 2452705 | 2022-04-28 | Polk | North Carolina | 37149 | 3901 | 57 |
2449449 | 2449449 | 2022-04-27 | Polk | North Carolina | 37149 | 3901 | 57 |
2306273 | 2306273 | 2022-03-14 | Watauga | North Carolina | 37189 | 12258 | 57 |
2166428 | 2166428 | 2022-01-30 | Transylvania | North Carolina | 37175 | 5606 | 57 |
2163173 | 2163173 | 2022-01-29 | Transylvania | North Carolina | 37175 | 5606 | 57 |
2159918 | 2159918 | 2022-01-28 | Transylvania | North Carolina | 37175 | 5606 | 57 |
2156663 | 2156663 | 2022-01-27 | Transylvania | North Carolina | 37175 | 5578 | 57 |
2153410 | 2153410 | 2022-01-26 | Transylvania | North Carolina | 37175 | 5552 | 57 |
2150078 | 2150078 | 2022-01-25 | Bertie | North Carolina | 37015 | 3875 | 57 |
2150158 | 2150158 | 2022-01-25 | Transylvania | North Carolina | 37175 | 5492 | 57 |
2146826 | 2146826 | 2022-01-24 | Bertie | North Carolina | 37015 | 3868 | 57 |
2143572 | 2143572 | 2022-01-23 | Bertie | North Carolina | 37015 | 3752 | 57 |
2140317 | 2140317 | 2022-01-22 | Bertie | North Carolina | 37015 | 3752 | 57 |
2137061 | 2137061 | 2022-01-21 | Bertie | North Carolina | 37015 | 3752 | 57 |
2133808 | 2133808 | 2022-01-20 | Bertie | North Carolina | 37015 | 3687 | 57 |
2130556 | 2130556 | 2022-01-19 | Bertie | North Carolina | 37015 | 3647 | 57 |
2127302 | 2127302 | 2022-01-18 | Bertie | North Carolina | 37015 | 3626 | 57 |
2124050 | 2124050 | 2022-01-17 | Bertie | North Carolina | 37015 | 3375 | 57 |
2120798 | 2120798 | 2022-01-16 | Bertie | North Carolina | 37015 | 3375 | 57 |
2117546 | 2117546 | 2022-01-15 | Bertie | North Carolina | 37015 | 3375 | 57 |
2114295 | 2114295 | 2022-01-14 | Bertie | North Carolina | 37015 | 3375 | 57 |
2029773 | 2029773 | 2021-12-19 | Ashe | North Carolina | 37009 | 3904 | 57 |
2026522 | 2026522 | 2021-12-18 | Ashe | North Carolina | 37009 | 3904 | 57 |
2023271 | 2023271 | 2021-12-17 | Ashe | North Carolina | 37009 | 3904 | 57 |
2020020 | 2020020 | 2021-12-16 | Ashe | North Carolina | 37009 | 3879 | 57 |
2016769 | 2016769 | 2021-12-15 | Ashe | North Carolina | 37009 | 3868 | 57 |
1838069 | 1838069 | 2021-10-21 | Macon | North Carolina | 37113 | 4911 | 57 |
1825074 | 1825074 | 2021-10-17 | Madison | North Carolina | 37115 | 2718 | 57 |
1821825 | 1821825 | 2021-10-16 | Madison | North Carolina | 37115 | 2718 | 57 |
1818576 | 1818576 | 2021-10-15 | Madison | North Carolina | 37115 | 2718 | 57 |
1815327 | 1815327 | 2021-10-14 | Madison | North Carolina | 37115 | 2711 | 57 |
1737351 | 1737351 | 2021-09-20 | Martin | North Carolina | 37117 | 3288 | 57 |
1734101 | 1734101 | 2021-09-19 | Martin | North Carolina | 37117 | 3250 | 57 |
1730851 | 1730851 | 2021-09-18 | Martin | North Carolina | 37117 | 3250 | 57 |
1727601 | 1727601 | 2021-09-17 | Martin | North Carolina | 37117 | 3250 | 57 |
1724314 | 1724314 | 2021-09-16 | Cherokee | North Carolina | 37039 | 4161 | 57 |
1724352 | 1724352 | 2021-09-16 | Martin | North Carolina | 37117 | 3222 | 57 |
1721080 | 1721080 | 2021-09-15 | Franklin | North Carolina | 37069 | 8763 | 57 |
1721103 | 1721103 | 2021-09-15 | Martin | North Carolina | 37117 | 3196 | 57 |
1717832 | 1717832 | 2021-09-14 | Franklin | North Carolina | 37069 | 8709 | 57 |
1714584 | 1714584 | 2021-09-13 | Franklin | North Carolina | 37069 | 8693 | 57 |
1691913 | 1691913 | 2021-09-06 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1688663 | 1688663 | 2021-09-05 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1685413 | 1685413 | 2021-09-04 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1682162 | 1682162 | 2021-09-03 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1678913 | 1678913 | 2021-09-02 | Yadkin | North Carolina | 37197 | 4954 | 57 |
1675665 | 1675665 | 2021-09-01 | Yadkin | North Carolina | 37197 | 4931 | 57 |
1672418 | 1672418 | 2021-08-31 | Yadkin | North Carolina | 37197 | 4886 | 57 |
1669170 | 1669170 | 2021-08-30 | Yadkin | North Carolina | 37197 | 4858 | 57 |
1665923 | 1665923 | 2021-08-29 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1662675 | 1662675 | 2021-08-28 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1659427 | 1659427 | 2021-08-27 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1656178 | 1656178 | 2021-08-26 | Yadkin | North Carolina | 37197 | 4765 | 57 |
1652848 | 1652848 | 2021-08-25 | Carteret | North Carolina | 37031 | 6248 | 57 |
1652931 | 1652931 | 2021-08-25 | Yadkin | North Carolina | 37197 | 4739 | 57 |
1649600 | 1649600 | 2021-08-24 | Carteret | North Carolina | 37031 | 6230 | 57 |
1649683 | 1649683 | 2021-08-24 | Yadkin | North Carolina | 37197 | 4710 | 57 |
1646351 | 1646351 | 2021-08-23 | Carteret | North Carolina | 37031 | 6206 | 57 |
1646434 | 1646434 | 2021-08-23 | Yadkin | North Carolina | 37197 | 4685 | 57 |
1643102 | 1643102 | 2021-08-22 | Carteret | North Carolina | 37031 | 6125 | 57 |
1643185 | 1643185 | 2021-08-22 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1639852 | 1639852 | 2021-08-21 | Carteret | North Carolina | 37031 | 6125 | 57 |
1639935 | 1639935 | 2021-08-21 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1636602 | 1636602 | 2021-08-20 | Carteret | North Carolina | 37031 | 6125 | 57 |
1636685 | 1636685 | 2021-08-20 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1633352 | 1633352 | 2021-08-19 | Carteret | North Carolina | 37031 | 6067 | 57 |
1633435 | 1633435 | 2021-08-19 | Yadkin | North Carolina | 37197 | 4596 | 57 |
1630105 | 1630105 | 2021-08-18 | Carteret | North Carolina | 37031 | 6010 | 57 |
1630188 | 1630188 | 2021-08-18 | Yadkin | North Carolina | 37197 | 4580 | 57 |
1626858 | 1626858 | 2021-08-17 | Carteret | North Carolina | 37031 | 5939 | 57 |
1626941 | 1626941 | 2021-08-17 | Yadkin | North Carolina | 37197 | 4556 | 57 |
1623599 | 1623599 | 2021-08-16 | Anson | North Carolina | 37007 | 2847 | 57 |
1623611 | 1623611 | 2021-08-16 | Carteret | North Carolina | 37031 | 5917 | 57 |
1620352 | 1620352 | 2021-08-15 | Anson | North Carolina | 37007 | 2815 | 57 |
1620364 | 1620364 | 2021-08-15 | Carteret | North Carolina | 37031 | 5804 | 57 |
1617104 | 1617104 | 2021-08-14 | Anson | North Carolina | 37007 | 2815 | 57 |
1617116 | 1617116 | 2021-08-14 | Carteret | North Carolina | 37031 | 5804 | 57 |
1613856 | 1613856 | 2021-08-13 | Anson | North Carolina | 37007 | 2815 | 57 |
1613868 | 1613868 | 2021-08-13 | Carteret | North Carolina | 37031 | 5804 | 57 |
1610607 | 1610607 | 2021-08-12 | Anson | North Carolina | 37007 | 2802 | 57 |
1610619 | 1610619 | 2021-08-12 | Carteret | North Carolina | 37031 | 5728 | 57 |
1607359 | 1607359 | 2021-08-11 | Anson | North Carolina | 37007 | 2794 | 57 |
1607371 | 1607371 | 2021-08-11 | Carteret | North Carolina | 37031 | 5670 | 57 |
1604122 | 1604122 | 2021-08-10 | Carteret | North Carolina | 37031 | 5612 | 57 |
1600873 | 1600873 | 2021-08-09 | Carteret | North Carolina | 37031 | 5601 | 57 |
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);