ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
405 rows where deaths = 42 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2361489 | 2361489 | 2022-03-31 | Avery | North Carolina | 37011 | 4547 | 42 |
2358235 | 2358235 | 2022-03-30 | Avery | North Carolina | 37011 | 4530 | 42 |
2354981 | 2354981 | 2022-03-29 | Avery | North Carolina | 37011 | 4498 | 42 |
2351728 | 2351728 | 2022-03-28 | Avery | North Carolina | 37011 | 4495 | 42 |
2348476 | 2348476 | 2022-03-27 | Avery | North Carolina | 37011 | 4482 | 42 |
2345223 | 2345223 | 2022-03-26 | Avery | North Carolina | 37011 | 4482 | 42 |
2341970 | 2341970 | 2022-03-25 | Avery | North Carolina | 37011 | 4482 | 42 |
2338717 | 2338717 | 2022-03-24 | Avery | North Carolina | 37011 | 4471 | 42 |
2335463 | 2335463 | 2022-03-23 | Avery | North Carolina | 37011 | 4463 | 42 |
2332209 | 2332209 | 2022-03-22 | Avery | North Carolina | 37011 | 4455 | 42 |
2328956 | 2328956 | 2022-03-21 | Avery | North Carolina | 37011 | 4453 | 42 |
2325704 | 2325704 | 2022-03-20 | Avery | North Carolina | 37011 | 4439 | 42 |
2322451 | 2322451 | 2022-03-19 | Avery | North Carolina | 37011 | 4439 | 42 |
2319197 | 2319197 | 2022-03-18 | Avery | North Carolina | 37011 | 4439 | 42 |
2306184 | 2306184 | 2022-03-14 | Avery | North Carolina | 37011 | 4423 | 42 |
2302933 | 2302933 | 2022-03-13 | Avery | North Carolina | 37011 | 4418 | 42 |
2299681 | 2299681 | 2022-03-12 | Avery | North Carolina | 37011 | 4418 | 42 |
2296429 | 2296429 | 2022-03-11 | Avery | North Carolina | 37011 | 4418 | 42 |
2293177 | 2293177 | 2022-03-10 | Avery | North Carolina | 37011 | 4414 | 42 |
2289925 | 2289925 | 2022-03-09 | Avery | North Carolina | 37011 | 4413 | 42 |
2286673 | 2286673 | 2022-03-08 | Avery | North Carolina | 37011 | 4406 | 42 |
2283421 | 2283421 | 2022-03-07 | Avery | North Carolina | 37011 | 4402 | 42 |
2280169 | 2280169 | 2022-03-06 | Avery | North Carolina | 37011 | 4393 | 42 |
2276916 | 2276916 | 2022-03-05 | Avery | North Carolina | 37011 | 4393 | 42 |
2273663 | 2273663 | 2022-03-04 | Avery | North Carolina | 37011 | 4393 | 42 |
2270410 | 2270410 | 2022-03-03 | Avery | North Carolina | 37011 | 4390 | 42 |
2267158 | 2267158 | 2022-03-02 | Avery | North Carolina | 37011 | 4385 | 42 |
2263906 | 2263906 | 2022-03-01 | Avery | North Carolina | 37011 | 4376 | 42 |
2189203 | 2189203 | 2022-02-06 | Washington | North Carolina | 37187 | 2829 | 42 |
2185950 | 2185950 | 2022-02-05 | Washington | North Carolina | 37187 | 2829 | 42 |
2182698 | 2182698 | 2022-02-04 | Washington | North Carolina | 37187 | 2829 | 42 |
2179446 | 2179446 | 2022-02-03 | Washington | North Carolina | 37187 | 2822 | 42 |
2176195 | 2176195 | 2022-02-02 | Washington | North Carolina | 37187 | 2810 | 42 |
2172942 | 2172942 | 2022-02-01 | Washington | North Carolina | 37187 | 2798 | 42 |
2169689 | 2169689 | 2022-01-31 | Washington | North Carolina | 37187 | 2782 | 42 |
2059111 | 2059111 | 2021-12-28 | Watauga | North Carolina | 37189 | 7420 | 42 |
2055862 | 2055862 | 2021-12-27 | Watauga | North Carolina | 37189 | 7308 | 42 |
2052612 | 2052612 | 2021-12-26 | Watauga | North Carolina | 37189 | 7308 | 42 |
2049362 | 2049362 | 2021-12-25 | Watauga | North Carolina | 37189 | 7308 | 42 |
2046112 | 2046112 | 2021-12-24 | Watauga | North Carolina | 37189 | 7308 | 42 |
2042862 | 2042862 | 2021-12-23 | Watauga | North Carolina | 37189 | 7308 | 42 |
2039613 | 2039613 | 2021-12-22 | Watauga | North Carolina | 37189 | 7308 | 42 |
2036363 | 2036363 | 2021-12-21 | Watauga | North Carolina | 37189 | 7268 | 42 |
2033113 | 2033113 | 2021-12-20 | Watauga | North Carolina | 37189 | 7252 | 42 |
2029863 | 2029863 | 2021-12-19 | Watauga | North Carolina | 37189 | 7199 | 42 |
2026612 | 2026612 | 2021-12-18 | Watauga | North Carolina | 37189 | 7199 | 42 |
2023361 | 2023361 | 2021-12-17 | Watauga | North Carolina | 37189 | 7199 | 42 |
2020110 | 2020110 | 2021-12-16 | Watauga | North Carolina | 37189 | 7175 | 42 |
2016859 | 2016859 | 2021-12-15 | Watauga | North Carolina | 37189 | 7167 | 42 |
2013609 | 2013609 | 2021-12-14 | Watauga | North Carolina | 37189 | 7136 | 42 |
2010358 | 2010358 | 2021-12-13 | Watauga | North Carolina | 37189 | 7129 | 42 |
2007107 | 2007107 | 2021-12-12 | Watauga | North Carolina | 37189 | 7075 | 42 |
2003856 | 2003856 | 2021-12-11 | Watauga | North Carolina | 37189 | 7075 | 42 |
2000605 | 2000605 | 2021-12-10 | Watauga | North Carolina | 37189 | 7075 | 42 |
1916020 | 1916020 | 2021-11-14 | Chowan | North Carolina | 37041 | 2333 | 42 |
1912770 | 1912770 | 2021-11-13 | Chowan | North Carolina | 37041 | 2333 | 42 |
1909520 | 1909520 | 2021-11-12 | Chowan | North Carolina | 37041 | 2333 | 42 |
1906271 | 1906271 | 2021-11-11 | Chowan | North Carolina | 37041 | 2321 | 42 |
1903022 | 1903022 | 2021-11-10 | Chowan | North Carolina | 37041 | 2321 | 42 |
1899772 | 1899772 | 2021-11-09 | Chowan | North Carolina | 37041 | 2310 | 42 |
1896522 | 1896522 | 2021-11-08 | Chowan | North Carolina | 37041 | 2310 | 42 |
1893272 | 1893272 | 2021-11-07 | Chowan | North Carolina | 37041 | 2311 | 42 |
1890022 | 1890022 | 2021-11-06 | Chowan | North Carolina | 37041 | 2311 | 42 |
1886772 | 1886772 | 2021-11-05 | Chowan | North Carolina | 37041 | 2311 | 42 |
1883523 | 1883523 | 2021-11-04 | Chowan | North Carolina | 37041 | 2307 | 42 |
1880274 | 1880274 | 2021-11-03 | Chowan | North Carolina | 37041 | 2306 | 42 |
1877025 | 1877025 | 2021-11-02 | Chowan | North Carolina | 37041 | 2306 | 42 |
1873776 | 1873776 | 2021-11-01 | Chowan | North Carolina | 37041 | 2300 | 42 |
1870527 | 1870527 | 2021-10-31 | Chowan | North Carolina | 37041 | 2297 | 42 |
1867278 | 1867278 | 2021-10-30 | Chowan | North Carolina | 37041 | 2297 | 42 |
1864029 | 1864029 | 2021-10-29 | Chowan | North Carolina | 37041 | 2297 | 42 |
1792601 | 1792601 | 2021-10-07 | Polk | North Carolina | 37149 | 2235 | 42 |
1789352 | 1789352 | 2021-10-06 | Polk | North Carolina | 37149 | 2229 | 42 |
1786104 | 1786104 | 2021-10-05 | Polk | North Carolina | 37149 | 2225 | 42 |
1782855 | 1782855 | 2021-10-04 | Polk | North Carolina | 37149 | 2221 | 42 |
1779606 | 1779606 | 2021-10-03 | Polk | North Carolina | 37149 | 2205 | 42 |
1776356 | 1776356 | 2021-10-02 | Polk | North Carolina | 37149 | 2205 | 42 |
1773106 | 1773106 | 2021-10-01 | Polk | North Carolina | 37149 | 2205 | 42 |
1769856 | 1769856 | 2021-09-30 | Polk | North Carolina | 37149 | 2203 | 42 |
1766607 | 1766607 | 2021-09-29 | Polk | North Carolina | 37149 | 2196 | 42 |
1558655 | 1558655 | 2021-07-27 | Davie | North Carolina | 37059 | 4275 | 42 |
1555408 | 1555408 | 2021-07-26 | Davie | North Carolina | 37059 | 4272 | 42 |
1552161 | 1552161 | 2021-07-25 | Davie | North Carolina | 37059 | 4247 | 42 |
1548914 | 1548914 | 2021-07-24 | Davie | North Carolina | 37059 | 4247 | 42 |
1545667 | 1545667 | 2021-07-23 | Davie | North Carolina | 37059 | 4247 | 42 |
1542420 | 1542420 | 2021-07-22 | Davie | North Carolina | 37059 | 4242 | 42 |
1539172 | 1539172 | 2021-07-21 | Davie | North Carolina | 37059 | 4238 | 42 |
1487248 | 1487248 | 2021-07-05 | Madison | North Carolina | 37115 | 1601 | 42 |
1484002 | 1484002 | 2021-07-04 | Madison | North Carolina | 37115 | 1601 | 42 |
1480756 | 1480756 | 2021-07-03 | Madison | North Carolina | 37115 | 1601 | 42 |
1477509 | 1477509 | 2021-07-02 | Madison | North Carolina | 37115 | 1601 | 42 |
1474263 | 1474263 | 2021-07-01 | Madison | North Carolina | 37115 | 1602 | 42 |
1471017 | 1471017 | 2021-06-30 | Madison | North Carolina | 37115 | 1601 | 42 |
1467772 | 1467772 | 2021-06-29 | Madison | North Carolina | 37115 | 1601 | 42 |
1464527 | 1464527 | 2021-06-28 | Madison | North Carolina | 37115 | 1601 | 42 |
1445056 | 1445056 | 2021-06-22 | Madison | North Carolina | 37115 | 1605 | 42 |
1441811 | 1441811 | 2021-06-21 | Madison | North Carolina | 37115 | 1604 | 42 |
1438518 | 1438518 | 2021-06-20 | Bladen | North Carolina | 37017 | 3421 | 42 |
1438566 | 1438566 | 2021-06-20 | Madison | North Carolina | 37115 | 1604 | 42 |
1435271 | 1435271 | 2021-06-19 | Bladen | North Carolina | 37017 | 3421 | 42 |
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);