ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
281 rows where deaths = 48 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Transylvania 36
- Greene 30
- Jackson 13
- Columbus 12
- Davidson 12
- Granville 12
- Ashe 11
- Alamance 10
- Caswell 10
- Duplin 10
- Orange 8
- Polk 8
- Washington 8
- Chowan 7
- Franklin 7
- Pitt 7
- Yadkin 6
- Anson 5
- Craven 5
- Forsyth 5
- Henderson 5
- Montgomery 5
- Union 5
- Watauga 5
- Catawba 4
- Rowan 4
- Hertford 3
- Pender 3
- Yancey 3
- Burke 2
- …
state 1
- North Carolina · 281 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501502 | 2501502 | 2022-05-13 | Caswell | North Carolina | 37033 | 5357 | 48 |
2498244 | 2498244 | 2022-05-12 | Caswell | North Carolina | 37033 | 5357 | 48 |
2494986 | 2494986 | 2022-05-11 | Caswell | North Carolina | 37033 | 5357 | 48 |
2491728 | 2491728 | 2022-05-10 | Caswell | North Carolina | 37033 | 5325 | 48 |
2488470 | 2488470 | 2022-05-09 | Caswell | North Carolina | 37033 | 5325 | 48 |
2485213 | 2485213 | 2022-05-08 | Caswell | North Carolina | 37033 | 5325 | 48 |
2481955 | 2481955 | 2022-05-07 | Caswell | North Carolina | 37033 | 5325 | 48 |
2478697 | 2478697 | 2022-05-06 | Caswell | North Carolina | 37033 | 5325 | 48 |
2475439 | 2475439 | 2022-05-05 | Caswell | North Carolina | 37033 | 5325 | 48 |
2472182 | 2472182 | 2022-05-04 | Caswell | North Carolina | 37033 | 5325 | 48 |
2267246 | 2267246 | 2022-03-02 | Washington | North Carolina | 37187 | 2962 | 48 |
2263994 | 2263994 | 2022-03-01 | Washington | North Carolina | 37187 | 2959 | 48 |
2260743 | 2260743 | 2022-02-28 | Washington | North Carolina | 37187 | 2959 | 48 |
2257492 | 2257492 | 2022-02-27 | Washington | North Carolina | 37187 | 2957 | 48 |
2254241 | 2254241 | 2022-02-26 | Washington | North Carolina | 37187 | 2957 | 48 |
2250990 | 2250990 | 2022-02-25 | Washington | North Carolina | 37187 | 2957 | 48 |
2247739 | 2247739 | 2022-02-24 | Washington | North Carolina | 37187 | 2956 | 48 |
2244488 | 2244488 | 2022-02-23 | Washington | North Carolina | 37187 | 2956 | 48 |
2189130 | 2189130 | 2022-02-06 | Chowan | North Carolina | 37041 | 4011 | 48 |
2189209 | 2189209 | 2022-02-06 | Yancey | North Carolina | 37199 | 4439 | 48 |
2185877 | 2185877 | 2022-02-05 | Chowan | North Carolina | 37041 | 4011 | 48 |
2185956 | 2185956 | 2022-02-05 | Yancey | North Carolina | 37199 | 4439 | 48 |
2182625 | 2182625 | 2022-02-04 | Chowan | North Carolina | 37041 | 4011 | 48 |
2182704 | 2182704 | 2022-02-04 | Yancey | North Carolina | 37199 | 4439 | 48 |
2179373 | 2179373 | 2022-02-03 | Chowan | North Carolina | 37041 | 3996 | 48 |
2176122 | 2176122 | 2022-02-02 | Chowan | North Carolina | 37041 | 3976 | 48 |
2172869 | 2172869 | 2022-02-01 | Chowan | North Carolina | 37041 | 3953 | 48 |
2169616 | 2169616 | 2022-01-31 | Chowan | North Carolina | 37041 | 3950 | 48 |
2169690 | 2169690 | 2022-01-31 | Watauga | North Carolina | 37189 | 10627 | 48 |
2166435 | 2166435 | 2022-01-30 | Watauga | North Carolina | 37189 | 10272 | 48 |
2163180 | 2163180 | 2022-01-29 | Watauga | North Carolina | 37189 | 10272 | 48 |
2159925 | 2159925 | 2022-01-28 | Watauga | North Carolina | 37189 | 10272 | 48 |
2156670 | 2156670 | 2022-01-27 | Watauga | North Carolina | 37189 | 10145 | 48 |
1925836 | 1925836 | 2021-11-17 | Transylvania | North Carolina | 37175 | 3960 | 48 |
1922587 | 1922587 | 2021-11-16 | Transylvania | North Carolina | 37175 | 3953 | 48 |
1919324 | 1919324 | 2021-11-15 | Polk | North Carolina | 37149 | 2389 | 48 |
1919337 | 1919337 | 2021-11-15 | Transylvania | North Carolina | 37175 | 3950 | 48 |
1916074 | 1916074 | 2021-11-14 | Polk | North Carolina | 37149 | 2378 | 48 |
1916087 | 1916087 | 2021-11-14 | Transylvania | North Carolina | 37175 | 3941 | 48 |
1912824 | 1912824 | 2021-11-13 | Polk | North Carolina | 37149 | 2378 | 48 |
1912837 | 1912837 | 2021-11-13 | Transylvania | North Carolina | 37175 | 3941 | 48 |
1909574 | 1909574 | 2021-11-12 | Polk | North Carolina | 37149 | 2378 | 48 |
1909587 | 1909587 | 2021-11-12 | Transylvania | North Carolina | 37175 | 3941 | 48 |
1906325 | 1906325 | 2021-11-11 | Polk | North Carolina | 37149 | 2376 | 48 |
1906338 | 1906338 | 2021-11-11 | Transylvania | North Carolina | 37175 | 3934 | 48 |
1903076 | 1903076 | 2021-11-10 | Polk | North Carolina | 37149 | 2376 | 48 |
1903089 | 1903089 | 2021-11-10 | Transylvania | North Carolina | 37175 | 3934 | 48 |
1899826 | 1899826 | 2021-11-09 | Polk | North Carolina | 37149 | 2372 | 48 |
1899839 | 1899839 | 2021-11-09 | Transylvania | North Carolina | 37175 | 3928 | 48 |
1896576 | 1896576 | 2021-11-08 | Polk | North Carolina | 37149 | 2369 | 48 |
1896589 | 1896589 | 2021-11-08 | Transylvania | North Carolina | 37175 | 3923 | 48 |
1893339 | 1893339 | 2021-11-07 | Transylvania | North Carolina | 37175 | 3913 | 48 |
1890089 | 1890089 | 2021-11-06 | Transylvania | North Carolina | 37175 | 3913 | 48 |
1886839 | 1886839 | 2021-11-05 | Transylvania | North Carolina | 37175 | 3913 | 48 |
1883590 | 1883590 | 2021-11-04 | Transylvania | North Carolina | 37175 | 3907 | 48 |
1880341 | 1880341 | 2021-11-03 | Transylvania | North Carolina | 37175 | 3902 | 48 |
1877092 | 1877092 | 2021-11-02 | Transylvania | North Carolina | 37175 | 3898 | 48 |
1873843 | 1873843 | 2021-11-01 | Transylvania | North Carolina | 37175 | 3893 | 48 |
1870594 | 1870594 | 2021-10-31 | Transylvania | North Carolina | 37175 | 3888 | 48 |
1867345 | 1867345 | 2021-10-30 | Transylvania | North Carolina | 37175 | 3888 | 48 |
1864096 | 1864096 | 2021-10-29 | Transylvania | North Carolina | 37175 | 3888 | 48 |
1860847 | 1860847 | 2021-10-28 | Transylvania | North Carolina | 37175 | 3886 | 48 |
1857515 | 1857515 | 2021-10-27 | Ashe | North Carolina | 37009 | 3434 | 48 |
1857598 | 1857598 | 2021-10-27 | Transylvania | North Carolina | 37175 | 3880 | 48 |
1854266 | 1854266 | 2021-10-26 | Ashe | North Carolina | 37009 | 3430 | 48 |
1854349 | 1854349 | 2021-10-26 | Transylvania | North Carolina | 37175 | 3873 | 48 |
1851017 | 1851017 | 2021-10-25 | Ashe | North Carolina | 37009 | 3430 | 48 |
1851100 | 1851100 | 2021-10-25 | Transylvania | North Carolina | 37175 | 3873 | 48 |
1847850 | 1847850 | 2021-10-24 | Transylvania | North Carolina | 37175 | 3863 | 48 |
1844600 | 1844600 | 2021-10-23 | Transylvania | North Carolina | 37175 | 3863 | 48 |
1841350 | 1841350 | 2021-10-22 | Transylvania | North Carolina | 37175 | 3863 | 48 |
1838018 | 1838018 | 2021-10-21 | Ashe | North Carolina | 37009 | 3415 | 48 |
1838101 | 1838101 | 2021-10-21 | Transylvania | North Carolina | 37175 | 3857 | 48 |
1834769 | 1834769 | 2021-10-20 | Ashe | North Carolina | 37009 | 3409 | 48 |
1834852 | 1834852 | 2021-10-20 | Transylvania | North Carolina | 37175 | 3854 | 48 |
1831520 | 1831520 | 2021-10-19 | Ashe | North Carolina | 37009 | 3407 | 48 |
1831603 | 1831603 | 2021-10-19 | Transylvania | North Carolina | 37175 | 3850 | 48 |
1828271 | 1828271 | 2021-10-18 | Ashe | North Carolina | 37009 | 3403 | 48 |
1828354 | 1828354 | 2021-10-18 | Transylvania | North Carolina | 37175 | 3849 | 48 |
1825022 | 1825022 | 2021-10-17 | Ashe | North Carolina | 37009 | 3381 | 48 |
1825105 | 1825105 | 2021-10-17 | Transylvania | North Carolina | 37175 | 3842 | 48 |
1821773 | 1821773 | 2021-10-16 | Ashe | North Carolina | 37009 | 3381 | 48 |
1821856 | 1821856 | 2021-10-16 | Transylvania | North Carolina | 37175 | 3842 | 48 |
1818524 | 1818524 | 2021-10-15 | Ashe | North Carolina | 37009 | 3381 | 48 |
1818607 | 1818607 | 2021-10-15 | Transylvania | North Carolina | 37175 | 3842 | 48 |
1815275 | 1815275 | 2021-10-14 | Ashe | North Carolina | 37009 | 3372 | 48 |
1815358 | 1815358 | 2021-10-14 | Transylvania | North Carolina | 37175 | 3834 | 48 |
1812110 | 1812110 | 2021-10-13 | Transylvania | North Carolina | 37175 | 3828 | 48 |
1763291 | 1763291 | 2021-09-28 | Bertie | North Carolina | 37015 | 2340 | 48 |
1656109 | 1656109 | 2021-08-26 | Davie | North Carolina | 37059 | 4927 | 48 |
1652862 | 1652862 | 2021-08-25 | Davie | North Carolina | 37059 | 4887 | 48 |
1630147 | 1630147 | 2021-08-18 | Martin | North Carolina | 37117 | 2640 | 48 |
1626882 | 1626882 | 2021-08-17 | Greene | North Carolina | 37079 | 2677 | 48 |
1623635 | 1623635 | 2021-08-16 | Greene | North Carolina | 37079 | 2670 | 48 |
1620388 | 1620388 | 2021-08-15 | Greene | North Carolina | 37079 | 2609 | 48 |
1617140 | 1617140 | 2021-08-14 | Greene | North Carolina | 37079 | 2609 | 48 |
1613892 | 1613892 | 2021-08-13 | Greene | North Carolina | 37079 | 2609 | 48 |
1610643 | 1610643 | 2021-08-12 | Greene | North Carolina | 37079 | 2589 | 48 |
1607395 | 1607395 | 2021-08-11 | Greene | North Carolina | 37079 | 2579 | 48 |
1604146 | 1604146 | 2021-08-10 | Greene | North Carolina | 37079 | 2571 | 48 |
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);