daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,055 rows where deaths = 1 and province_or_state = "North Carolina" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-20 | US | North Carolina | Unassigned | 90037 | 158 | 1 | 0 | 157 | 36.49360862 | 0.0 | 2021-01-21 05:22:01 | Unassigned, North Carolina, US |
2020-12-15 | US | North Carolina | Alleghany | 37005 | 507 | 1 | 0 | 506 | 36.49360862 | -81.12857041 | 2020-12-16 05:28:04 | Alleghany, North Carolina, US |
2020-12-14 | US | North Carolina | Alleghany | 37005 | 505 | 1 | 0 | 504 | 36.49360862 | -81.12857041 | 2020-12-15 05:26:38 | Alleghany, North Carolina, US |
2020-12-13 | US | North Carolina | Alleghany | 37005 | 485 | 1 | 0 | 484 | 36.49360862 | -81.12857041 | 2020-12-14 05:26:27 | Alleghany, North Carolina, US |
2020-12-12 | US | North Carolina | Alleghany | 37005 | 471 | 1 | 0 | 470 | 36.49360862 | -81.12857041 | 2020-12-13 05:27:20 | Alleghany, North Carolina, US |
2020-12-11 | US | North Carolina | Alleghany | 37005 | 458 | 1 | 0 | 457 | 36.49360862 | -81.12857041 | 2020-12-12 05:26:19 | Alleghany, North Carolina, US |
2020-12-10 | US | North Carolina | Alleghany | 37005 | 455 | 1 | 0 | 454 | 36.49360862 | -81.12857041 | 2020-12-11 05:26:59 | Alleghany, North Carolina, US |
2020-12-09 | US | North Carolina | Alleghany | 37005 | 445 | 1 | 0 | 444 | 36.49360862 | -81.12857041 | 2020-12-10 05:26:19 | Alleghany, North Carolina, US |
2020-12-08 | US | North Carolina | Alleghany | 37005 | 436 | 1 | 0 | 435 | 36.49360862 | -81.12857041 | 2020-12-09 05:28:01 | Alleghany, North Carolina, US |
2020-12-07 | US | North Carolina | Alleghany | 37005 | 432 | 1 | 0 | 431 | 36.49360862 | -81.12857041 | 2020-12-08 05:27:42 | Alleghany, North Carolina, US |
2020-12-06 | US | North Carolina | Alleghany | 37005 | 422 | 1 | 0 | 421 | 36.49360862 | -81.12857041 | 2020-12-07 05:26:14 | Alleghany, North Carolina, US |
2020-12-05 | US | North Carolina | Alleghany | 37005 | 416 | 1 | 0 | 415 | 36.49360862 | -81.12857041 | 2020-12-06 05:26:18 | Alleghany, North Carolina, US |
2020-12-04 | US | North Carolina | Alleghany | 37005 | 413 | 1 | 0 | 412 | 36.49360862 | -81.12857041 | 2020-12-05 05:27:36 | Alleghany, North Carolina, US |
2020-12-03 | US | North Carolina | Alleghany | 37005 | 409 | 1 | 0 | 408 | 36.49360862 | -81.12857041 | 2020-12-04 05:27:27 | Alleghany, North Carolina, US |
2020-12-02 | US | North Carolina | Alleghany | 37005 | 403 | 1 | 0 | 402 | 36.49360862 | -81.12857041 | 2020-12-03 05:28:22 | Alleghany, North Carolina, US |
2020-12-01 | US | North Carolina | Alleghany | 37005 | 397 | 1 | 0 | 396 | 36.49360862 | -81.12857041 | 2020-12-02 05:27:41 | Alleghany, North Carolina, US |
2020-11-30 | US | North Carolina | Alleghany | 37005 | 393 | 1 | 0 | 392 | 36.49360862 | -81.12857041 | 2020-12-01 05:26:18 | Alleghany, North Carolina, US |
2020-11-29 | US | North Carolina | Alleghany | 37005 | 390 | 1 | 0 | 389 | 36.49360862 | -81.12857041 | 2020-11-30 05:26:13 | Alleghany, North Carolina, US |
2020-11-28 | US | North Carolina | Alleghany | 37005 | 384 | 1 | 0 | 383 | 36.49360862 | -81.12857041 | 2020-11-29 05:25:55 | Alleghany, North Carolina, US |
2020-11-27 | US | North Carolina | Alleghany | 37005 | 381 | 1 | 0 | 380 | 36.49360862 | -81.12857041 | 2020-11-28 05:25:50 | Alleghany, North Carolina, US |
2020-11-26 | US | North Carolina | Alleghany | 37005 | 378 | 1 | 0 | 377 | 36.49360862 | -81.12857041 | 2020-11-27 05:26:53 | Alleghany, North Carolina, US |
2020-11-25 | US | North Carolina | Alleghany | 37005 | 378 | 1 | 0 | 377 | 36.49360862 | -81.12857041 | 2020-11-26 05:27:44 | Alleghany, North Carolina, US |
2020-11-24 | US | North Carolina | Alleghany | 37005 | 377 | 1 | 0 | 376 | 36.49360862 | -81.12857041 | 2020-11-25 05:27:20 | Alleghany, North Carolina, US |
2020-11-23 | US | North Carolina | Alleghany | 37005 | 376 | 1 | 0 | 375 | 36.49360862 | -81.12857041 | 2020-11-24 05:27:31 | Alleghany, North Carolina, US |
2020-11-22 | US | North Carolina | Alleghany | 37005 | 375 | 1 | 0 | 374 | 36.49360862 | -81.12857041 | 2020-11-23 05:25:26 | Alleghany, North Carolina, US |
2020-11-21 | US | North Carolina | Alleghany | 37005 | 373 | 1 | 0 | 372 | 36.49360862 | -81.12857041 | 2020-11-22 05:25:45 | Alleghany, North Carolina, US |
2020-11-20 | US | North Carolina | Alleghany | 37005 | 370 | 1 | 0 | 369 | 36.49360862 | -81.12857041 | 2020-11-21 05:25:51 | Alleghany, North Carolina, US |
2020-11-19 | US | North Carolina | Alleghany | 37005 | 367 | 1 | 0 | 366 | 36.49360862 | -81.12857041 | 2020-11-20 05:26:28 | Alleghany, North Carolina, US |
2020-11-18 | US | North Carolina | Alleghany | 37005 | 365 | 1 | 0 | 364 | 36.49360862 | -81.12857041 | 2020-11-19 05:25:23 | Alleghany, North Carolina, US |
2020-11-17 | US | North Carolina | Alleghany | 37005 | 363 | 1 | 0 | 362 | 36.49360862 | -81.12857041 | 2020-11-18 05:40:31 | Alleghany, North Carolina, US |
2020-11-16 | US | North Carolina | Alleghany | 37005 | 360 | 1 | 0 | 359 | 36.49360862 | -81.12857041 | 2020-11-17 05:25:54 | Alleghany, North Carolina, US |
2020-11-15 | US | North Carolina | Alleghany | 37005 | 359 | 1 | 0 | 358 | 36.49360862 | -81.12857041 | 2020-11-16 05:25:57 | Alleghany, North Carolina, US |
2020-11-14 | US | North Carolina | Alleghany | 37005 | 359 | 1 | 0 | 358 | 36.49360862 | -81.12857041 | 2020-11-15 05:26:53 | Alleghany, North Carolina, US |
2020-11-13 | US | North Carolina | Alleghany | 37005 | 356 | 1 | 0 | 355 | 36.49360862 | -81.12857041 | 2020-11-14 05:25:37 | Alleghany, North Carolina, US |
2020-11-12 | US | North Carolina | Alleghany | 37005 | 355 | 1 | 0 | 354 | 36.49360862 | -81.12857041 | 2020-11-13 05:25:30 | Alleghany, North Carolina, US |
2020-11-11 | US | North Carolina | Alleghany | 37005 | 354 | 1 | 0 | 353 | 36.49360862 | -81.12857041 | 2020-11-12 05:25:55 | Alleghany, North Carolina, US |
2020-11-10 | US | North Carolina | Alleghany | 37005 | 353 | 1 | 0 | 352 | 36.49360862 | -81.12857041 | 2020-11-11 05:25:30 | Alleghany, North Carolina, US |
2020-11-09 | US | North Carolina | Alleghany | 37005 | 352 | 1 | 0 | 351 | 36.49360862 | -81.12857041 | 2020-11-10 05:40:07 | Alleghany, North Carolina, US |
2020-11-08 | US | North Carolina | Alleghany | 37005 | 351 | 1 | 0 | 350 | 36.49360862 | -81.12857041 | 2020-11-09 05:25:45 | Alleghany, North Carolina, US |
2020-11-07 | US | North Carolina | Alleghany | 37005 | 348 | 1 | 0 | 347 | 36.49360862 | -81.12857041 | 2020-11-08 05:24:56 | Alleghany, North Carolina, US |
2020-11-06 | US | North Carolina | Alleghany | 37005 | 345 | 1 | 0 | 344 | 36.49360862 | -81.12857041 | 2020-11-07 05:24:52 | Alleghany, North Carolina, US |
2020-11-05 | US | North Carolina | Alleghany | 37005 | 340 | 1 | 0 | 339 | 36.49360862 | -81.12857041 | 2020-11-06 05:24:55 | Alleghany, North Carolina, US |
2020-11-04 | US | North Carolina | Alleghany | 37005 | 326 | 1 | 0 | 325 | 36.49360862 | -81.12857041 | 2020-11-05 06:05:03 | Alleghany, North Carolina, US |
2020-11-03 | US | North Carolina | Alleghany | 37005 | 326 | 1 | 0 | 325 | 36.49360862 | -81.12857041 | 2020-11-04 05:25:09 | Alleghany, North Carolina, US |
2020-11-02 | US | North Carolina | Alleghany | 37005 | 319 | 1 | 0 | 318 | 36.49360862 | -81.12857041 | 2020-11-03 06:00:16 | Alleghany, North Carolina, US |
2020-11-02 | US | North Carolina | Avery | 37011 | 648 | 1 | 0 | 647 | 36.07569796 | -81.92308483 | 2020-11-03 06:00:16 | Avery, North Carolina, US |
2020-11-02 | US | North Carolina | Yancey | 37199 | 344 | 1 | 0 | 343 | 35.90079156 | -82.31237181 | 2020-11-03 06:00:16 | Yancey, North Carolina, US |
2020-11-01 | US | North Carolina | Alleghany | 37005 | 316 | 1 | 0 | 315 | 36.49360862 | -81.12857041 | 2020-11-02 05:25:04 | Alleghany, North Carolina, US |
2020-11-01 | US | North Carolina | Avery | 37011 | 647 | 1 | 0 | 646 | 36.07569796 | -81.92308483 | 2020-11-02 05:25:04 | Avery, North Carolina, US |
2020-11-01 | US | North Carolina | Yancey | 37199 | 340 | 1 | 0 | 339 | 35.90079156 | -82.31237181 | 2020-11-02 05:25:04 | Yancey, North Carolina, US |
2020-10-31 | US | North Carolina | Alleghany | 37005 | 311 | 1 | 0 | 310 | 36.49360862 | -81.12857041 | 2020-11-01 04:36:19 | Alleghany, North Carolina, US |
2020-10-31 | US | North Carolina | Avery | 37011 | 645 | 1 | 0 | 644 | 36.07569796 | -81.92308483 | 2020-11-01 04:36:19 | Avery, North Carolina, US |
2020-10-31 | US | North Carolina | Yancey | 37199 | 338 | 1 | 0 | 337 | 35.90079156 | -82.31237181 | 2020-11-01 04:36:19 | Yancey, North Carolina, US |
2020-10-30 | US | North Carolina | Alleghany | 37005 | 307 | 1 | 0 | 306 | 36.49360862 | -81.12857041 | 2020-10-31 04:24:44 | Alleghany, North Carolina, US |
2020-10-30 | US | North Carolina | Madison | 37115 | 281 | 1 | 0 | 280 | 35.85402722 | -82.71346418 | 2020-10-31 04:24:44 | Madison, North Carolina, US |
2020-10-30 | US | North Carolina | Yancey | 37199 | 333 | 1 | 0 | 332 | 35.90079156 | -82.31237181 | 2020-10-31 04:24:44 | Yancey, North Carolina, US |
2020-10-29 | US | North Carolina | Madison | 37115 | 247 | 1 | 0 | 246 | 35.85402722 | -82.71346418 | 2020-10-30 04:24:49 | Madison, North Carolina, US |
2020-10-29 | US | North Carolina | Yancey | 37199 | 328 | 1 | 0 | 327 | 35.90079156 | -82.31237181 | 2020-10-30 04:24:49 | Yancey, North Carolina, US |
2020-10-28 | US | North Carolina | Madison | 37115 | 246 | 1 | 0 | 245 | 35.85402722 | -82.71346418 | 2020-10-29 04:24:49 | Madison, North Carolina, US |
2020-10-27 | US | North Carolina | Madison | 37115 | 244 | 1 | 0 | 243 | 35.85402722 | -82.71346418 | 2020-10-28 04:24:39 | Madison, North Carolina, US |
2020-10-26 | US | North Carolina | Madison | 37115 | 218 | 1 | 0 | 217 | 35.85402722 | -82.71346418 | 2020-10-27 04:24:45 | Madison, North Carolina, US |
2020-10-25 | US | North Carolina | Madison | 37115 | 208 | 1 | 0 | 207 | 35.85402722 | -82.71346418 | 2020-10-26 04:25:02 | Madison, North Carolina, US |
2020-10-24 | US | North Carolina | Madison | 37115 | 208 | 1 | 0 | 207 | 35.85402722 | -82.71346418 | 2020-10-25 04:24:36 | Madison, North Carolina, US |
2020-10-23 | US | North Carolina | Madison | 37115 | 198 | 1 | 0 | 197 | 35.85402722 | -82.71346418 | 2020-10-24 04:24:46 | Madison, North Carolina, US |
2020-10-22 | US | North Carolina | Madison | 37115 | 192 | 1 | 0 | 191 | 35.85402722 | -82.71346418 | 2020-10-23 04:24:46 | Madison, North Carolina, US |
2020-10-21 | US | North Carolina | Alleghany | 37005 | 271 | 1 | 0 | 270 | 36.49360862 | -81.12857041 | 2020-10-22 04:24:27 | Alleghany, North Carolina, US |
2020-10-21 | US | North Carolina | Ashe | 37009 | 370 | 1 | 0 | 369 | 36.43296207 | -81.49862729 | 2020-10-22 04:24:27 | Ashe, North Carolina, US |
2020-10-21 | US | North Carolina | Madison | 37115 | 161 | 1 | 0 | 160 | 35.85402722 | -82.71346418 | 2020-10-22 04:24:27 | Madison, North Carolina, US |
2020-10-20 | US | North Carolina | Alleghany | 37005 | 270 | 1 | 0 | 269 | 36.49360862 | -81.12857041 | 2020-10-21 04:24:14 | Alleghany, North Carolina, US |
2020-10-20 | US | North Carolina | Ashe | 37009 | 370 | 1 | 0 | 369 | 36.43296207 | -81.49862729 | 2020-10-21 04:24:14 | Ashe, North Carolina, US |
2020-10-20 | US | North Carolina | Madison | 37115 | 159 | 1 | 0 | 158 | 35.85402722 | -82.71346418 | 2020-10-21 04:24:14 | Madison, North Carolina, US |
2020-10-19 | US | North Carolina | Alleghany | 37005 | 269 | 1 | 0 | 268 | 36.49360862 | -81.12857041 | 2020-10-20 04:24:22 | Alleghany, North Carolina, US |
2020-10-19 | US | North Carolina | Ashe | 37009 | 367 | 1 | 0 | 366 | 36.43296207 | -81.49862729 | 2020-10-20 04:24:22 | Ashe, North Carolina, US |
2020-10-19 | US | North Carolina | Madison | 37115 | 154 | 1 | 0 | 153 | 35.85402722 | -82.71346418 | 2020-10-20 04:24:22 | Madison, North Carolina, US |
2020-10-18 | US | North Carolina | Alleghany | 37005 | 265 | 1 | 0 | 264 | 36.49360862 | -81.12857041 | 2020-10-19 04:24:16 | Alleghany, North Carolina, US |
2020-10-18 | US | North Carolina | Ashe | 37009 | 366 | 1 | 0 | 365 | 36.43296207 | -81.49862729 | 2020-10-19 04:24:16 | Ashe, North Carolina, US |
2020-10-18 | US | North Carolina | Madison | 37115 | 149 | 1 | 0 | 148 | 35.85402722 | -82.71346418 | 2020-10-19 04:24:16 | Madison, North Carolina, US |
2020-10-17 | US | North Carolina | Alleghany | 37005 | 264 | 1 | 0 | 263 | 36.49360862 | -81.12857041 | 2020-10-18 04:24:25 | Alleghany, North Carolina, US |
2020-10-17 | US | North Carolina | Ashe | 37009 | 364 | 1 | 0 | 363 | 36.43296207 | -81.49862729 | 2020-10-18 04:24:25 | Ashe, North Carolina, US |
2020-10-17 | US | North Carolina | Madison | 37115 | 140 | 1 | 0 | 139 | 35.85402722 | -82.71346418 | 2020-10-18 04:24:25 | Madison, North Carolina, US |
2020-10-16 | US | North Carolina | Alleghany | 37005 | 262 | 1 | 0 | 261 | 36.49360862 | -81.12857041 | 2020-10-17 04:24:12 | Alleghany, North Carolina, US |
2020-10-16 | US | North Carolina | Ashe | 37009 | 358 | 1 | 0 | 357 | 36.43296207 | -81.49862729 | 2020-10-17 04:24:12 | Ashe, North Carolina, US |
2020-10-16 | US | North Carolina | Madison | 37115 | 135 | 1 | 0 | 134 | 35.85402722 | -82.71346418 | 2020-10-17 04:24:12 | Madison, North Carolina, US |
2020-10-15 | US | North Carolina | Alleghany | 37005 | 261 | 1 | 0 | 260 | 36.49360862 | -81.12857041 | 2020-10-16 04:24:01 | Alleghany, North Carolina, US |
2020-10-15 | US | North Carolina | Ashe | 37009 | 347 | 1 | 0 | 346 | 36.43296207 | -81.49862729 | 2020-10-16 04:24:01 | Ashe, North Carolina, US |
2020-10-15 | US | North Carolina | Madison | 37115 | 134 | 1 | 0 | 133 | 35.85402722 | -82.71346418 | 2020-10-16 04:24:01 | Madison, North Carolina, US |
2020-10-14 | US | North Carolina | Alleghany | 37005 | 258 | 1 | 0 | 257 | 36.49360862 | -81.12857041 | 2020-10-15 04:24:28 | Alleghany, North Carolina, US |
2020-10-14 | US | North Carolina | Ashe | 37009 | 336 | 1 | 0 | 335 | 36.43296207 | -81.49862729 | 2020-10-15 04:24:28 | Ashe, North Carolina, US |
2020-10-14 | US | North Carolina | Madison | 37115 | 131 | 1 | 0 | 130 | 35.85402722 | -82.71346418 | 2020-10-15 04:24:28 | Madison, North Carolina, US |
2020-10-13 | US | North Carolina | Alleghany | 37005 | 257 | 1 | 0 | 256 | 36.49360862 | -81.12857041 | 2020-10-14 04:24:05 | Alleghany, North Carolina, US |
2020-10-13 | US | North Carolina | Ashe | 37009 | 334 | 1 | 0 | 333 | 36.43296207 | -81.49862729 | 2020-10-14 04:24:05 | Ashe, North Carolina, US |
2020-10-13 | US | North Carolina | Madison | 37115 | 130 | 1 | 0 | 129 | 35.85402722 | -82.71346418 | 2020-10-14 04:24:05 | Madison, North Carolina, US |
2020-10-12 | US | North Carolina | Alleghany | 37005 | 257 | 1 | 0 | 256 | 36.49360862 | -81.12857041 | 2020-10-13 04:24:02 | Alleghany, North Carolina, US |
2020-10-12 | US | North Carolina | Ashe | 37009 | 330 | 1 | 0 | 329 | 36.43296207 | -81.49862729 | 2020-10-13 04:24:02 | Ashe, North Carolina, US |
2020-10-12 | US | North Carolina | Madison | 37115 | 130 | 1 | 0 | 129 | 35.85402722 | -82.71346418 | 2020-10-13 04:24:02 | Madison, North Carolina, US |
2020-10-11 | US | North Carolina | Alleghany | 37005 | 251 | 1 | 0 | 250 | 36.49360862 | -81.12857041 | 2020-10-12 04:23:45 | Alleghany, North Carolina, US |
2020-10-11 | US | North Carolina | Ashe | 37009 | 326 | 1 | 0 | 325 | 36.43296207 | -81.49862729 | 2020-10-12 04:23:45 | Ashe, North Carolina, US |
2020-10-11 | US | North Carolina | Madison | 37115 | 130 | 1 | 0 | 129 | 35.85402722 | -82.71346418 | 2020-10-12 04:23:45 | Madison, North Carolina, US |
2020-10-10 | US | North Carolina | Alleghany | 37005 | 249 | 1 | 0 | 248 | 36.49360862 | -81.12857041 | 2020-10-11 04:23:46 | Alleghany, North Carolina, US |
2020-10-10 | US | North Carolina | Ashe | 37009 | 323 | 1 | 0 | 322 | 36.43296207 | -81.49862729 | 2020-10-11 04:23:46 | Ashe, North Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;