ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
149 rows where deaths = 70 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338799 | 2338799 | 2022-03-24 | Transylvania | North Carolina | 37175 | 6114 | 70 |
2263905 | 2263905 | 2022-03-01 | Ashe | North Carolina | 37009 | 6269 | 70 |
1847820 | 1847820 | 2021-10-24 | Martin | North Carolina | 37117 | 3620 | 70 |
1844570 | 1844570 | 2021-10-23 | Martin | North Carolina | 37117 | 3620 | 70 |
1841320 | 1841320 | 2021-10-22 | Martin | North Carolina | 37117 | 3620 | 70 |
1838059 | 1838059 | 2021-10-21 | Hertford | North Carolina | 37091 | 2823 | 70 |
1838063 | 1838063 | 2021-10-21 | Jackson | North Carolina | 37099 | 5598 | 70 |
1838071 | 1838071 | 2021-10-21 | Martin | North Carolina | 37117 | 3609 | 70 |
1834810 | 1834810 | 2021-10-20 | Hertford | North Carolina | 37091 | 2815 | 70 |
1834814 | 1834814 | 2021-10-20 | Jackson | North Carolina | 37099 | 5586 | 70 |
1831561 | 1831561 | 2021-10-19 | Hertford | North Carolina | 37091 | 2812 | 70 |
1831565 | 1831565 | 2021-10-19 | Jackson | North Carolina | 37099 | 5581 | 70 |
1828312 | 1828312 | 2021-10-18 | Hertford | North Carolina | 37091 | 2810 | 70 |
1828316 | 1828316 | 2021-10-18 | Jackson | North Carolina | 37099 | 5572 | 70 |
1825047 | 1825047 | 2021-10-17 | Davie | North Carolina | 37059 | 6286 | 70 |
1825063 | 1825063 | 2021-10-17 | Hertford | North Carolina | 37091 | 2787 | 70 |
1825067 | 1825067 | 2021-10-17 | Jackson | North Carolina | 37099 | 5534 | 70 |
1825116 | 1825116 | 2021-10-17 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1821798 | 1821798 | 2021-10-16 | Davie | North Carolina | 37059 | 6286 | 70 |
1821814 | 1821814 | 2021-10-16 | Hertford | North Carolina | 37091 | 2787 | 70 |
1821818 | 1821818 | 2021-10-16 | Jackson | North Carolina | 37099 | 5534 | 70 |
1821867 | 1821867 | 2021-10-16 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1818549 | 1818549 | 2021-10-15 | Davie | North Carolina | 37059 | 6286 | 70 |
1818565 | 1818565 | 2021-10-15 | Hertford | North Carolina | 37091 | 2787 | 70 |
1818569 | 1818569 | 2021-10-15 | Jackson | North Carolina | 37099 | 5534 | 70 |
1818618 | 1818618 | 2021-10-15 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1815300 | 1815300 | 2021-10-14 | Davie | North Carolina | 37059 | 6269 | 70 |
1815316 | 1815316 | 2021-10-14 | Hertford | North Carolina | 37091 | 2765 | 70 |
1815320 | 1815320 | 2021-10-14 | Jackson | North Carolina | 37099 | 5516 | 70 |
1815369 | 1815369 | 2021-10-14 | Yadkin | North Carolina | 37197 | 5874 | 70 |
1812068 | 1812068 | 2021-10-13 | Hertford | North Carolina | 37091 | 2758 | 70 |
1812072 | 1812072 | 2021-10-13 | Jackson | North Carolina | 37099 | 5480 | 70 |
1812121 | 1812121 | 2021-10-13 | Yadkin | North Carolina | 37197 | 5858 | 70 |
1808823 | 1808823 | 2021-10-12 | Jackson | North Carolina | 37099 | 5472 | 70 |
1808872 | 1808872 | 2021-10-12 | Yadkin | North Carolina | 37197 | 5840 | 70 |
1805621 | 1805621 | 2021-10-11 | Yadkin | North Carolina | 37197 | 5828 | 70 |
1802372 | 1802372 | 2021-10-10 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1799123 | 1799123 | 2021-10-09 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1795874 | 1795874 | 2021-10-08 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1792625 | 1792625 | 2021-10-07 | Yadkin | North Carolina | 37197 | 5782 | 70 |
1789376 | 1789376 | 2021-10-06 | Yadkin | North Carolina | 37197 | 5761 | 70 |
1786128 | 1786128 | 2021-10-05 | Yadkin | North Carolina | 37197 | 5750 | 70 |
1756790 | 1756790 | 2021-09-26 | Anson | North Carolina | 37007 | 3571 | 70 |
1753542 | 1753542 | 2021-09-25 | Anson | North Carolina | 37007 | 3571 | 70 |
1750294 | 1750294 | 2021-09-24 | Anson | North Carolina | 37007 | 3571 | 70 |
1747044 | 1747044 | 2021-09-23 | Anson | North Carolina | 37007 | 3550 | 70 |
1743795 | 1743795 | 2021-09-22 | Anson | North Carolina | 37007 | 3543 | 70 |
1740546 | 1740546 | 2021-09-21 | Anson | North Carolina | 37007 | 3526 | 70 |
1604177 | 1604177 | 2021-08-10 | Pender | North Carolina | 37141 | 6136 | 70 |
1600928 | 1600928 | 2021-08-09 | Pender | North Carolina | 37141 | 6112 | 70 |
1597680 | 1597680 | 2021-08-08 | Pender | North Carolina | 37141 | 5991 | 70 |
1594431 | 1594431 | 2021-08-07 | Pender | North Carolina | 37141 | 5991 | 70 |
1591182 | 1591182 | 2021-08-06 | Pender | North Carolina | 37141 | 5991 | 70 |
1448315 | 1448315 | 2021-06-23 | Pender | North Carolina | 37141 | 5551 | 70 |
1425595 | 1425595 | 2021-06-16 | Pender | North Carolina | 37141 | 5553 | 70 |
1422348 | 1422348 | 2021-06-15 | Pender | North Carolina | 37141 | 5550 | 70 |
1419102 | 1419102 | 2021-06-14 | Pender | North Carolina | 37141 | 5550 | 70 |
1357439 | 1357439 | 2021-05-26 | Person | North Carolina | 37145 | 3436 | 70 |
1354193 | 1354193 | 2021-05-25 | Person | North Carolina | 37145 | 3436 | 70 |
1350947 | 1350947 | 2021-05-24 | Person | North Carolina | 37145 | 3434 | 70 |
1324970 | 1324970 | 2021-05-16 | Person | North Carolina | 37145 | 3378 | 70 |
1321724 | 1321724 | 2021-05-15 | Person | North Carolina | 37145 | 3378 | 70 |
1318478 | 1318478 | 2021-05-14 | Person | North Carolina | 37145 | 3378 | 70 |
1315230 | 1315230 | 2021-05-13 | Person | North Carolina | 37145 | 3374 | 70 |
1311984 | 1311984 | 2021-05-12 | Person | North Carolina | 37145 | 3371 | 70 |
1019725 | 1019725 | 2021-02-11 | Chatham | North Carolina | 37037 | 3969 | 70 |
1016480 | 1016480 | 2021-02-10 | Chatham | North Carolina | 37037 | 3939 | 70 |
1013235 | 1013235 | 2021-02-09 | Chatham | North Carolina | 37037 | 3927 | 70 |
1009990 | 1009990 | 2021-02-08 | Chatham | North Carolina | 37037 | 3918 | 70 |
1006744 | 1006744 | 2021-02-07 | Chatham | North Carolina | 37037 | 3907 | 70 |
1003498 | 1003498 | 2021-02-06 | Chatham | North Carolina | 37037 | 3881 | 70 |
1000252 | 1000252 | 2021-02-05 | Chatham | North Carolina | 37037 | 3861 | 70 |
997006 | 997006 | 2021-02-04 | Chatham | North Carolina | 37037 | 3842 | 70 |
993760 | 993760 | 2021-02-03 | Chatham | North Carolina | 37037 | 3823 | 70 |
993803 | 993803 | 2021-02-03 | Montgomery | North Carolina | 37123 | 2767 | 70 |
990514 | 990514 | 2021-02-02 | Chatham | North Carolina | 37037 | 3751 | 70 |
987268 | 987268 | 2021-02-01 | Chatham | North Carolina | 37037 | 3744 | 70 |
984021 | 984021 | 2021-01-31 | Chatham | North Carolina | 37037 | 3726 | 70 |
980774 | 980774 | 2021-01-30 | Chatham | North Carolina | 37037 | 3670 | 70 |
977528 | 977528 | 2021-01-29 | Chatham | North Carolina | 37037 | 3670 | 70 |
974338 | 974338 | 2021-01-28 | Pitt | North Carolina | 37147 | 15037 | 70 |
971093 | 971093 | 2021-01-27 | Pitt | North Carolina | 37147 | 14909 | 70 |
967848 | 967848 | 2021-01-26 | Pitt | North Carolina | 37147 | 14822 | 70 |
964604 | 964604 | 2021-01-25 | Pitt | North Carolina | 37147 | 14796 | 70 |
961359 | 961359 | 2021-01-24 | Pitt | North Carolina | 37147 | 14714 | 70 |
954836 | 954836 | 2021-01-22 | Halifax | North Carolina | 37083 | 3971 | 70 |
951588 | 951588 | 2021-01-21 | Granville | North Carolina | 37077 | 4452 | 70 |
951617 | 951617 | 2021-01-21 | Orange | North Carolina | 37135 | 6211 | 70 |
948343 | 948343 | 2021-01-20 | Granville | North Carolina | 37077 | 4419 | 70 |
948372 | 948372 | 2021-01-20 | Orange | North Carolina | 37135 | 6159 | 70 |
945096 | 945096 | 2021-01-19 | Granville | North Carolina | 37077 | 4369 | 70 |
941850 | 941850 | 2021-01-18 | Granville | North Carolina | 37077 | 4335 | 70 |
938605 | 938605 | 2021-01-17 | Granville | North Carolina | 37077 | 4335 | 70 |
935360 | 935360 | 2021-01-16 | Granville | North Carolina | 37077 | 4297 | 70 |
906159 | 906159 | 2021-01-07 | Haywood | North Carolina | 37087 | 2487 | 70 |
886694 | 886694 | 2021-01-01 | Lenoir | North Carolina | 37107 | 3239 | 70 |
883449 | 883449 | 2020-12-31 | Lenoir | North Carolina | 37107 | 3239 | 70 |
880204 | 880204 | 2020-12-30 | Lenoir | North Carolina | 37107 | 3191 | 70 |
854200 | 854200 | 2020-12-22 | Brunswick | North Carolina | 37019 | 3983 | 70 |
850955 | 850955 | 2020-12-21 | Brunswick | North Carolina | 37019 | 3937 | 70 |
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);