ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
825 rows where deaths = 18 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Clay 196
- Swain 91
- Gates 87
- Perquimans 58
- Warren 37
- Dare 31
- Chowan 30
- Caldwell 26
- Mitchell 25
- Jackson 18
- Jones 16
- Hoke 14
- Montgomery 12
- Davidson 10
- Avery 9
- Anson 8
- Carteret 8
- Iredell 8
- Wilson 8
- Halifax 7
- Alexander 6
- Bladen 6
- Hertford 6
- Northampton 6
- Vance 6
- Cherokee 5
- Wayne 5
- Craven 4
- Davie 4
- Martin 4
- …
state 1
- North Carolina · 825 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468981 | 2468981 | 2022-05-03 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2465725 | 2465725 | 2022-05-02 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2462470 | 2462470 | 2022-05-01 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2459214 | 2459214 | 2022-04-30 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2455958 | 2455958 | 2022-04-29 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2452702 | 2452702 | 2022-04-28 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2449446 | 2449446 | 2022-04-27 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2446189 | 2446189 | 2022-04-26 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2442934 | 2442934 | 2022-04-25 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2439678 | 2439678 | 2022-04-24 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2436422 | 2436422 | 2022-04-23 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2433166 | 2433166 | 2022-04-22 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2429910 | 2429910 | 2022-04-21 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2426654 | 2426654 | 2022-04-20 | Perquimans | North Carolina | 37143 | 2753 | 18 |
2423398 | 2423398 | 2022-04-19 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2420141 | 2420141 | 2022-04-18 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2416886 | 2416886 | 2022-04-17 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2413630 | 2413630 | 2022-04-16 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2410374 | 2410374 | 2022-04-15 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2407118 | 2407118 | 2022-04-14 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2403862 | 2403862 | 2022-04-13 | Perquimans | North Carolina | 37143 | 2748 | 18 |
2400607 | 2400607 | 2022-04-12 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2397352 | 2397352 | 2022-04-11 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2394097 | 2394097 | 2022-04-10 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2390841 | 2390841 | 2022-04-09 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2387585 | 2387585 | 2022-04-08 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2384330 | 2384330 | 2022-04-07 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2381075 | 2381075 | 2022-04-06 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2377820 | 2377820 | 2022-04-05 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2374567 | 2374567 | 2022-04-04 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2371315 | 2371315 | 2022-04-03 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2368062 | 2368062 | 2022-04-02 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2364809 | 2364809 | 2022-04-01 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2361555 | 2361555 | 2022-03-31 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2358301 | 2358301 | 2022-03-30 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2355047 | 2355047 | 2022-03-29 | Perquimans | North Carolina | 37143 | 2742 | 18 |
2351794 | 2351794 | 2022-03-28 | Perquimans | North Carolina | 37143 | 2742 | 18 |
2348542 | 2348542 | 2022-03-27 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2345289 | 2345289 | 2022-03-26 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2342036 | 2342036 | 2022-03-25 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2338783 | 2338783 | 2022-03-24 | Perquimans | North Carolina | 37143 | 2742 | 18 |
2335529 | 2335529 | 2022-03-23 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2332275 | 2332275 | 2022-03-22 | Perquimans | North Carolina | 37143 | 2740 | 18 |
2329022 | 2329022 | 2022-03-21 | Perquimans | North Carolina | 37143 | 2743 | 18 |
2325770 | 2325770 | 2022-03-20 | Perquimans | North Carolina | 37143 | 2745 | 18 |
2322517 | 2322517 | 2022-03-19 | Perquimans | North Carolina | 37143 | 2745 | 18 |
2319263 | 2319263 | 2022-03-18 | Perquimans | North Carolina | 37143 | 2745 | 18 |
2316009 | 2316009 | 2022-03-17 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2312756 | 2312756 | 2022-03-16 | Perquimans | North Carolina | 37143 | 2743 | 18 |
2309503 | 2309503 | 2022-03-15 | Perquimans | North Carolina | 37143 | 2743 | 18 |
2306250 | 2306250 | 2022-03-14 | Perquimans | North Carolina | 37143 | 2743 | 18 |
2302999 | 2302999 | 2022-03-13 | Perquimans | North Carolina | 37143 | 2738 | 18 |
2299747 | 2299747 | 2022-03-12 | Perquimans | North Carolina | 37143 | 2738 | 18 |
2296495 | 2296495 | 2022-03-11 | Perquimans | North Carolina | 37143 | 2738 | 18 |
2293243 | 2293243 | 2022-03-10 | Perquimans | North Carolina | 37143 | 2737 | 18 |
2289991 | 2289991 | 2022-03-09 | Perquimans | North Carolina | 37143 | 2732 | 18 |
2286739 | 2286739 | 2022-03-08 | Perquimans | North Carolina | 37143 | 2729 | 18 |
2283487 | 2283487 | 2022-03-07 | Perquimans | North Carolina | 37143 | 2728 | 18 |
2189137 | 2189137 | 2022-02-06 | Dare | North Carolina | 37055 | 6975 | 18 |
2185884 | 2185884 | 2022-02-05 | Dare | North Carolina | 37055 | 6975 | 18 |
2182632 | 2182632 | 2022-02-04 | Dare | North Carolina | 37055 | 6975 | 18 |
2179380 | 2179380 | 2022-02-03 | Dare | North Carolina | 37055 | 6967 | 18 |
2176129 | 2176129 | 2022-02-02 | Dare | North Carolina | 37055 | 6916 | 18 |
2172876 | 2172876 | 2022-02-01 | Dare | North Carolina | 37055 | 6846 | 18 |
2169623 | 2169623 | 2022-01-31 | Dare | North Carolina | 37055 | 6828 | 18 |
2166368 | 2166368 | 2022-01-30 | Dare | North Carolina | 37055 | 6688 | 18 |
2163113 | 2163113 | 2022-01-29 | Dare | North Carolina | 37055 | 6688 | 18 |
2159858 | 2159858 | 2022-01-28 | Dare | North Carolina | 37055 | 6688 | 18 |
2156603 | 2156603 | 2022-01-27 | Dare | North Carolina | 37055 | 6644 | 18 |
2153350 | 2153350 | 2022-01-26 | Dare | North Carolina | 37055 | 6550 | 18 |
2150098 | 2150098 | 2022-01-25 | Dare | North Carolina | 37055 | 6527 | 18 |
2146846 | 2146846 | 2022-01-24 | Dare | North Carolina | 37055 | 6516 | 18 |
2143592 | 2143592 | 2022-01-23 | Dare | North Carolina | 37055 | 6299 | 18 |
2140337 | 2140337 | 2022-01-22 | Dare | North Carolina | 37055 | 6299 | 18 |
2137081 | 2137081 | 2022-01-21 | Dare | North Carolina | 37055 | 6299 | 18 |
2133828 | 2133828 | 2022-01-20 | Dare | North Carolina | 37055 | 6197 | 18 |
2130576 | 2130576 | 2022-01-19 | Dare | North Carolina | 37055 | 6119 | 18 |
2127322 | 2127322 | 2022-01-18 | Dare | North Carolina | 37055 | 6100 | 18 |
2124070 | 2124070 | 2022-01-17 | Dare | North Carolina | 37055 | 5645 | 18 |
2124079 | 2124079 | 2022-01-17 | Gates | North Carolina | 37073 | 1463 | 18 |
2120818 | 2120818 | 2022-01-16 | Dare | North Carolina | 37055 | 5645 | 18 |
2120827 | 2120827 | 2022-01-16 | Gates | North Carolina | 37073 | 1463 | 18 |
2117566 | 2117566 | 2022-01-15 | Dare | North Carolina | 37055 | 5645 | 18 |
2117575 | 2117575 | 2022-01-15 | Gates | North Carolina | 37073 | 1463 | 18 |
2114315 | 2114315 | 2022-01-14 | Dare | North Carolina | 37055 | 5645 | 18 |
2114324 | 2114324 | 2022-01-14 | Gates | North Carolina | 37073 | 1463 | 18 |
2111063 | 2111063 | 2022-01-13 | Dare | North Carolina | 37055 | 5601 | 18 |
2111072 | 2111072 | 2022-01-13 | Gates | North Carolina | 37073 | 1395 | 18 |
2107811 | 2107811 | 2022-01-12 | Dare | North Carolina | 37055 | 5526 | 18 |
2107820 | 2107820 | 2022-01-12 | Gates | North Carolina | 37073 | 1372 | 18 |
2104560 | 2104560 | 2022-01-11 | Dare | North Carolina | 37055 | 5421 | 18 |
2104569 | 2104569 | 2022-01-11 | Gates | North Carolina | 37073 | 1354 | 18 |
2101309 | 2101309 | 2022-01-10 | Dare | North Carolina | 37055 | 5369 | 18 |
2101318 | 2101318 | 2022-01-10 | Gates | North Carolina | 37073 | 1339 | 18 |
2098058 | 2098058 | 2022-01-09 | Dare | North Carolina | 37055 | 5089 | 18 |
2098067 | 2098067 | 2022-01-09 | Gates | North Carolina | 37073 | 1307 | 18 |
2094806 | 2094806 | 2022-01-08 | Dare | North Carolina | 37055 | 5089 | 18 |
2094815 | 2094815 | 2022-01-08 | Gates | North Carolina | 37073 | 1307 | 18 |
2091554 | 2091554 | 2022-01-07 | Dare | North Carolina | 37055 | 5089 | 18 |
2091563 | 2091563 | 2022-01-07 | Gates | North Carolina | 37073 | 1307 | 18 |
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);