johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9,121 rows where province_or_state = "Connecticut" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
396941 | 396941 | 2022-10-07 | US | Connecticut | Windham | 9015 | 29630 | 322 | 0 | 41.82972709 | -71.98182316 | 2022-10-08 04:22:56 | Windham, Connecticut, US | |
400932 | 400932 | 2021-06-29 | US | Connecticut | Windham | 9015 | 10945 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-06-30 04:21:41 | Windham, Connecticut, US | |
404966 | 404966 | 2021-12-07 | US | Connecticut | Windham | 9015 | 15314 | 231 | 0 | 41.82972709 | -71.98182316 | 2021-12-08 04:22:46 | Windham, Connecticut, US | |
408962 | 408962 | 2021-07-28 | US | Connecticut | Windham | 9015 | 11063 | 196 | 0 | 41.82972709 | -71.98182316 | 2021-07-29 04:21:33 | Windham, Connecticut, US | |
415048 | 415048 | 2020-07-05 | US | Connecticut | Windham | 9015 | 616 | 14 | 0 | 602 | 41.82972709 | -71.98182316 | 2020-07-06 04:33:57 | Windham, Connecticut, US |
418636 | 418636 | 2020-04-18 | US | Connecticut | Windham | 9015 | 97 | 2 | 0 | 95 | 41.82972709 | -71.98182316 | 2020-04-18 22:32:47 | Windham, Connecticut, US |
420012 | 420012 | 2022-09-18 | US | Connecticut | Windham | 9015 | 29256 | 318 | 0 | 41.82972709 | -71.98182316 | 2022-09-19 04:21:49 | Windham, Connecticut, US | |
424022 | 424022 | 2021-10-10 | US | Connecticut | Windham | 9015 | 12777 | 211 | 0 | 41.82972709 | -71.98182316 | 2021-10-11 04:21:31 | Windham, Connecticut, US | |
427991 | 427991 | 2020-09-07 | US | Connecticut | Windham | 9015 | 813 | 15 | 0 | 798 | 41.82972709 | -71.98182316 | 2020-09-08 04:28:25 | Windham, Connecticut, US |
432034 | 432034 | 2022-11-03 | US | Connecticut | Windham | 9015 | 30000 | 329 | 0 | 41.82972709 | -71.98182316 | 2022-11-04 04:22:11 | Windham, Connecticut, US | |
436018 | 436018 | 2021-01-21 | US | Connecticut | Windham | 9015 | 7534 | 116 | 0 | 7418 | 41.82972709 | -71.98182316 | 2021-01-22 05:22:10 | Windham, Connecticut, US |
442223 | 442223 | 2020-07-26 | US | Connecticut | Windham | 9015 | 658 | 15 | 0 | 643 | 41.82972709 | -71.98182316 | 2020-07-27 04:35:02 | Windham, Connecticut, US |
444026 | 444026 | 2021-10-20 | US | Connecticut | Windham | 9015 | 13155 | 214 | 0 | 41.82972709 | -71.98182316 | 2021-10-21 04:21:18 | Windham, Connecticut, US | |
448043 | 448043 | 2021-11-17 | US | Connecticut | Windham | 9015 | 14022 | 223 | 0 | 41.82972709 | -71.98182316 | 2021-11-18 04:21:33 | Windham, Connecticut, US | |
452064 | 452064 | 2022-12-21 | US | Connecticut | Windham | 9015 | 30605 | 336 | 0 | 41.82972709 | -71.98182316 | 2022-12-22 04:20:56 | Windham, Connecticut, US | |
458248 | 458248 | 2020-08-07 | US | Connecticut | Windham | 9015 | 726 | 15 | 0 | 711 | 41.82972709 | -71.98182316 | 2020-08-08 04:34:53 | Windham, Connecticut, US |
460052 | 460052 | 2022-02-02 | US | Connecticut | Windham | 9015 | 24634 | 276 | 0 | 41.82972709 | -71.98182316 | 2022-02-03 04:21:21 | Windham, Connecticut, US | |
464069 | 464069 | 2022-05-02 | US | Connecticut | Windham | 9015 | 26157 | 303 | 0 | 41.82972709 | -71.98182316 | 2022-05-03 04:21:00 | Windham, Connecticut, US | |
468083 | 468083 | 2021-10-07 | US | Connecticut | Windham | 9015 | 12746 | 211 | 0 | 41.82972709 | -71.98182316 | 2021-10-08 04:21:25 | Windham, Connecticut, US | |
472074 | 472074 | 2021-02-19 | US | Connecticut | Windham | 9015 | 9028 | 176 | 0 | 8852 | 41.82972709 | -71.98182316 | 2021-02-20 05:22:51 | Windham, Connecticut, US |
476116 | 476116 | 2022-06-26 | US | Connecticut | Windham | 9015 | 27848 | 310 | 0 | 41.82972709 | -71.98182316 | 2022-06-27 04:21:00 | Windham, Connecticut, US | |
480267 | 480267 | 2022-11-08 | US | Connecticut | Windham | 9015 | 30091 | 329 | 0 | 41.82972709 | -71.98182316 | 2022-11-09 04:21:22 | Windham, Connecticut, US | |
484258 | 484258 | 2021-07-19 | US | Connecticut | Windham | 9015 | 11006 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-07-20 04:21:48 | Windham, Connecticut, US | |
488297 | 488297 | 2022-11-25 | US | Connecticut | Windham | 9015 | 30296 | 332 | 0 | 41.82972709 | -71.98182316 | 2022-11-26 04:21:11 | Windham, Connecticut, US | |
492307 | 492307 | 2021-10-14 | US | Connecticut | Windham | 9015 | 12963 | 213 | 0 | 41.82972709 | -71.98182316 | 2021-10-15 04:21:26 | Windham, Connecticut, US | |
496324 | 496324 | 2021-11-06 | US | Connecticut | Windham | 9015 | 13573 | 220 | 0 | 41.82972709 | -71.98182316 | 2021-11-07 04:21:53 | Windham, Connecticut, US | |
500341 | 500341 | 2022-04-02 | US | Connecticut | Windham | 9015 | 25619 | 301 | 0 | 41.82972709 | -71.98182316 | 2022-04-03 04:20:48 | Windham, Connecticut, US | |
504361 | 504361 | 2022-12-17 | US | Connecticut | Windham | 9015 | 30558 | 334 | 0 | 41.82972709 | -71.98182316 | 2022-12-18 04:21:03 | Windham, Connecticut, US | |
508352 | 508352 | 2021-08-14 | US | Connecticut | Windham | 9015 | 11278 | 196 | 0 | 41.82972709 | -71.98182316 | 2021-08-15 04:21:41 | Windham, Connecticut, US | |
512366 | 512366 | 2021-08-19 | US | Connecticut | Windham | 9015 | 11348 | 197 | 0 | 41.82972709 | -71.98182316 | 2021-08-20 04:21:33 | Windham, Connecticut, US | |
516405 | 516405 | 2022-10-15 | US | Connecticut | Windham | 9015 | 29758 | 322 | 0 | 41.82972709 | -71.98182316 | 2022-10-16 04:22:39 | Windham, Connecticut, US | |
522172 | 522172 | 2020-04-21 | US | Connecticut | Windham | 9015 | 112 | 2 | 0 | 110 | 41.82972709 | -71.98182316 | 2020-04-21 23:30:50 | Windham, Connecticut, US |
523522 | 523522 | 2021-06-09 | US | Connecticut | Windham | 9015 | 10907 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-06-10 04:23:17 | Windham, Connecticut, US | |
529610 | 529610 | 2020-07-04 | US | Connecticut | Windham | 9015 | 616 | 14 | 0 | 602 | 41.82972709 | -71.98182316 | 2020-07-05 04:33:46 | Windham, Connecticut, US |
531368 | 531368 | 2021-02-22 | US | Connecticut | Windham | 9015 | 9081 | 178 | 0 | 8903 | 41.82972709 | -71.98182316 | 2021-02-23 05:23:41 | Windham, Connecticut, US |
535407 | 535407 | 2021-10-27 | US | Connecticut | Windham | 9015 | 13325 | 218 | 0 | 41.82972709 | -71.98182316 | 2021-10-28 04:22:08 | Windham, Connecticut, US | |
539429 | 539429 | 2022-10-26 | US | Connecticut | Windham | 9015 | 29903 | 326 | 0 | 41.82972709 | -71.98182316 | 2022-10-27 04:22:01 | Windham, Connecticut, US | |
543445 | 543445 | 2022-12-15 | US | Connecticut | Windham | 9015 | 30523 | 334 | 0 | 41.82972709 | -71.98182316 | 2022-12-16 04:21:01 | Windham, Connecticut, US | |
547408 | 547408 | 2020-09-12 | US | Connecticut | Windham | 9015 | 844 | 15 | 0 | 829 | 41.82972709 | -71.98182316 | 2020-09-13 04:30:52 | Windham, Connecticut, US |
551446 | 551446 | 2021-12-08 | US | Connecticut | Windham | 9015 | 15326 | 231 | 0 | 41.82972709 | -71.98182316 | 2021-12-09 04:22:49 | Windham, Connecticut, US | |
555462 | 555462 | 2022-01-16 | US | Connecticut | Windham | 9015 | 21657 | 258 | 0 | 41.82972709 | -71.98182316 | 2022-01-17 04:21:08 | Windham, Connecticut, US | |
559480 | 559480 | 2022-06-16 | US | Connecticut | Windham | 9015 | 27728 | 309 | 0 | 41.82972709 | -71.98182316 | 2022-06-17 04:20:56 | Windham, Connecticut, US | |
563634 | 563634 | 2021-06-22 | US | Connecticut | Windham | 9015 | 10913 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-06-23 04:21:46 | Windham, Connecticut, US | |
567775 | 567775 | 2021-10-29 | US | Connecticut | Windham | 9015 | 13392 | 220 | 0 | 41.82972709 | -71.98182316 | 2021-10-30 04:22:03 | Windham, Connecticut, US | |
573762 | 573762 | 2020-06-06 | US | Connecticut | Windham | 9015 | 416 | 14 | 0 | 402 | 41.82972709 | -71.98182316 | 2020-06-07 03:53:30 | Windham, Connecticut, US |
575505 | 575505 | 2022-02-25 | US | Connecticut | Windham | 9015 | 25349 | 290 | 0 | 41.82972709 | -71.98182316 | 2022-02-26 04:21:12 | Windham, Connecticut, US | |
579500 | 579500 | 2021-07-13 | US | Connecticut | Windham | 9015 | 11000 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-07-14 04:21:35 | Windham, Connecticut, US | |
583485 | 583485 | 2020-08-13 | US | Connecticut | Windham | 9015 | 751 | 15 | 0 | 736 | 41.82972709 | -71.98182316 | 2020-08-14 04:51:19 | Windham, Connecticut, US |
588951 | 588951 | 2020-04-05 | US | Connecticut | Windham | 9015 | 32 | 1 | 0 | 31 | 41.82972709 | -71.98182316 | 2020-04-05 23:06:45 | Windham, Connecticut, US |
590296 | 590296 | 2021-08-08 | US | Connecticut | Windham | 9015 | 11179 | 196 | 0 | 41.82972709 | -71.98182316 | 2021-08-09 04:21:24 | Windham, Connecticut, US | |
594332 | 594332 | 2022-07-01 | US | Connecticut | Windham | 9015 | 27924 | 310 | 0 | 41.82972709 | -71.98182316 | 2022-07-02 04:21:16 | Windham, Connecticut, US | |
598345 | 598345 | 2021-10-19 | US | Connecticut | Windham | 9015 | 13118 | 214 | 0 | 41.82972709 | -71.98182316 | 2021-10-20 04:21:00 | Windham, Connecticut, US | |
602360 | 602360 | 2021-09-23 | US | Connecticut | Windham | 9015 | 12299 | 200 | 0 | 41.82972709 | -71.98182316 | 2021-09-24 04:21:44 | Windham, Connecticut, US | |
606353 | 606353 | 2021-04-09 | US | Connecticut | Windham | 9015 | 10137 | 188 | 0 | 41.82972709 | -71.98182316 | 2021-04-10 04:20:59 | Windham, Connecticut, US | |
610343 | 610343 | 2020-08-29 | US | Connecticut | Windham | 9015 | 789 | 15 | 0 | 774 | 41.82972709 | -71.98182316 | 2020-08-30 04:28:22 | Windham, Connecticut, US |
614350 | 614350 | 2021-02-08 | US | Connecticut | Windham | 9015 | 8756 | 160 | 0 | 8596 | 41.82972709 | -71.98182316 | 2021-02-09 05:23:30 | Windham, Connecticut, US |
618539 | 618539 | 2022-11-05 | US | Connecticut | Windham | 9015 | 30079 | 329 | 0 | 41.82972709 | -71.98182316 | 2022-11-06 04:21:24 | Windham, Connecticut, US | |
622552 | 622552 | 2022-05-22 | US | Connecticut | Windham | 9015 | 27294 | 305 | 0 | 41.82972709 | -71.98182316 | 2022-05-26 04:20:50 | Windham, Connecticut, US | |
626546 | 626546 | 2021-07-10 | US | Connecticut | Windham | 9015 | 10991 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-07-11 04:21:43 | Windham, Connecticut, US | |
630582 | 630582 | 2022-07-12 | US | Connecticut | Windham | 9015 | 28065 | 310 | 0 | 41.82972709 | -71.98182316 | 2022-07-13 04:20:58 | Windham, Connecticut, US | |
634595 | 634595 | 2021-10-13 | US | Connecticut | Windham | 9015 | 12900 | 213 | 0 | 41.82972709 | -71.98182316 | 2021-10-14 04:21:29 | Windham, Connecticut, US | |
638586 | 638586 | 2021-03-31 | US | Connecticut | Windham | 9015 | 9881 | 187 | 0 | 41.82972709 | -71.98182316 | 2021-04-01 04:27:05 | Windham, Connecticut, US | |
642606 | 642606 | 2021-09-07 | US | Connecticut | Windham | 9015 | 11718 | 198 | 0 | 41.82972709 | -71.98182316 | 2021-09-08 04:21:31 | Windham, Connecticut, US | |
646616 | 646616 | 2021-05-05 | US | Connecticut | Windham | 9015 | 10690 | 191 | 0 | 41.82972709 | -71.98182316 | 2021-05-06 04:20:38 | Windham, Connecticut, US | |
650634 | 650634 | 2021-08-09 | US | Connecticut | Windham | 9015 | 11227 | 196 | 0 | 41.82972709 | -71.98182316 | 2021-08-10 04:21:27 | Windham, Connecticut, US | |
654667 | 654667 | 2021-10-22 | US | Connecticut | Windham | 9015 | 13207 | 218 | 0 | 41.82972709 | -71.98182316 | 2021-10-23 04:21:32 | Windham, Connecticut, US | |
658987 | 658987 | 2022-05-13 | US | Connecticut | Windham | 9015 | 26643 | 305 | 0 | 41.82972709 | -71.98182316 | 2022-05-14 04:20:48 | Windham, Connecticut, US | |
662999 | 662999 | 2020-08-11 | US | Connecticut | Windham | 9015 | 745 | 15 | 0 | 730 | 41.82972709 | -71.98182316 | 2020-08-12 04:27:29 | Windham, Connecticut, US |
666933 | 666933 | 2020-09-16 | US | Connecticut | Windham | 9015 | 884 | 15 | 0 | 869 | 41.82972709 | -71.98182316 | 2020-09-17 04:22:00 | Windham, Connecticut, US |
670973 | 670973 | 2022-07-21 | US | Connecticut | Windham | 9015 | 28248 | 310 | 0 | 41.82972709 | -71.98182316 | 2022-07-22 04:21:15 | Windham, Connecticut, US | |
674989 | 674989 | 2022-07-30 | US | Connecticut | Windham | 9015 | 28425 | 310 | 0 | 41.82972709 | -71.98182316 | 2022-07-31 04:21:02 | Windham, Connecticut, US | |
678973 | 678973 | 2020-11-23 | US | Connecticut | Windham | 9015 | 2313 | 27 | 0 | 2286 | 41.82972709 | -71.98182316 | 2020-11-24 05:27:31 | Windham, Connecticut, US |
683012 | 683012 | 2021-10-24 | US | Connecticut | Windham | 9015 | 13207 | 218 | 0 | 41.82972709 | -71.98182316 | 2021-10-25 04:22:31 | Windham, Connecticut, US | |
687029 | 687029 | 2021-11-13 | US | Connecticut | Windham | 9015 | 13786 | 221 | 0 | 41.82972709 | -71.98182316 | 2021-11-14 04:21:31 | Windham, Connecticut, US | |
691050 | 691050 | 2022-12-23 | US | Connecticut | Windham | 9015 | 30648 | 336 | 0 | 41.82972709 | -71.98182316 | 2022-12-24 04:21:02 | Windham, Connecticut, US | |
695062 | 695062 | 2022-03-17 | US | Connecticut | Windham | 9015 | 25492 | 296 | 0 | 41.82972709 | -71.98182316 | 2022-03-18 04:20:55 | Windham, Connecticut, US | |
699077 | 699077 | 2021-11-04 | US | Connecticut | Windham | 9015 | 13552 | 220 | 0 | 41.82972709 | -71.98182316 | 2021-11-05 04:21:54 | Windham, Connecticut, US | |
703067 | 703067 | 2021-03-16 | US | Connecticut | Windham | 9015 | 9500 | 182 | 0 | 41.82972709 | -71.98182316 | 2021-03-17 05:25:07 | Windham, Connecticut, US | |
707105 | 707105 | 2021-09-29 | US | Connecticut | Windham | 9015 | 12483 | 208 | 0 | 41.82972709 | -71.98182316 | 2021-09-30 04:21:20 | Windham, Connecticut, US | |
711127 | 711127 | 2022-11-01 | US | Connecticut | Windham | 9015 | 29981 | 329 | 0 | 41.82972709 | -71.98182316 | 2022-11-02 04:22:09 | Windham, Connecticut, US | |
715138 | 715138 | 2021-11-12 | US | Connecticut | Windham | 9015 | 13786 | 221 | 0 | 41.82972709 | -71.98182316 | 2021-11-13 04:21:38 | Windham, Connecticut, US | |
719159 | 719159 | 2022-12-04 | US | Connecticut | Windham | 9015 | 30395 | 333 | 0 | 41.82972709 | -71.98182316 | 2022-12-05 04:20:58 | Windham, Connecticut, US | |
723170 | 723170 | 2021-11-20 | US | Connecticut | Windham | 9015 | 14149 | 223 | 0 | 41.82972709 | -71.98182316 | 2021-11-21 04:22:13 | Windham, Connecticut, US | |
727162 | 727162 | 2021-05-22 | US | Connecticut | Windham | 9015 | 10850 | 194 | 0 | 41.82972709 | -71.98182316 | 2021-05-23 04:20:51 | Windham, Connecticut, US | |
731200 | 731200 | 2021-12-27 | US | Connecticut | Windham | 9015 | 17392 | 247 | 0 | 41.82972709 | -71.98182316 | 2021-12-28 04:21:47 | Windham, Connecticut, US | |
737207 | 737207 | 2020-06-12 | US | Connecticut | Windham | 9015 | 453 | 14 | 0 | 439 | 41.82972709 | -71.98182316 | 2020-06-13 03:33:14 | Windham, Connecticut, US |
738962 | 738962 | 2020-12-02 | US | Connecticut | Windham | 9015 | 2682 | 32 | 0 | 2650 | 41.82972709 | -71.98182316 | 2020-12-03 05:28:22 | Windham, Connecticut, US |
742976 | 742976 | 2021-02-20 | US | Connecticut | Windham | 9015 | 9028 | 176 | 0 | 8852 | 41.82972709 | -71.98182316 | 2021-02-21 05:24:33 | Windham, Connecticut, US |
747017 | 747017 | 2022-04-23 | US | Connecticut | Windham | 9015 | 25934 | 302 | 0 | 41.82972709 | -71.98182316 | 2022-04-24 04:20:56 | Windham, Connecticut, US | |
753202 | 753202 | 2020-08-01 | US | Connecticut | Windham | 9015 | 693 | 15 | 0 | 678 | 41.82972709 | -71.98182316 | 2020-08-02 04:34:47 | Windham, Connecticut, US |
754961 | 754961 | 2020-10-28 | US | Connecticut | Windham | 9015 | 1419 | 19 | 0 | 1400 | 41.82972709 | -71.98182316 | 2020-10-29 04:24:49 | Windham, Connecticut, US |
759000 | 759000 | 2021-11-26 | US | Connecticut | Windham | 9015 | 14505 | 224 | 0 | 41.82972709 | -71.98182316 | 2021-11-27 04:22:45 | Windham, Connecticut, US | |
762971 | 762971 | 2020-10-18 | US | Connecticut | Windham | 9015 | 1216 | 17 | 0 | 1199 | 41.82972709 | -71.98182316 | 2020-10-19 04:24:16 | Windham, Connecticut, US |
766981 | 766981 | 2020-12-29 | US | Connecticut | Windham | 9015 | 4989 | 72 | 0 | 4917 | 41.82972709 | -71.98182316 | 2020-12-30 05:22:34 | Windham, Connecticut, US |
771020 | 771020 | 2021-10-23 | US | Connecticut | Windham | 9015 | 13207 | 218 | 0 | 41.82972709 | -71.98182316 | 2021-10-24 04:21:22 | Windham, Connecticut, US | |
775009 | 775009 | 2021-01-12 | US | Connecticut | Windham | 9015 | 6732 | 95 | 0 | 6637 | 41.82972709 | -71.98182316 | 2021-01-13 05:22:15 | Windham, Connecticut, US |
779029 | 779029 | 2021-07-08 | US | Connecticut | Windham | 9015 | 10956 | 195 | 0 | 41.82972709 | -71.98182316 | 2021-07-09 04:21:21 | Windham, Connecticut, US | |
783063 | 783063 | 2021-12-13 | US | Connecticut | Windham | 9015 | 16000 | 235 | 0 | 41.82972709 | -71.98182316 | 2021-12-14 04:22:38 | Windham, Connecticut, US | |
787033 | 787033 | 2020-10-15 | US | Connecticut | Windham | 9015 | 1193 | 17 | 0 | 1176 | 41.82972709 | -71.98182316 | 2020-10-16 04:24:01 | Windham, Connecticut, US |
791045 | 791045 | 2021-02-04 | US | Connecticut | Windham | 9015 | 8529 | 154 | 0 | 8375 | 41.82972709 | -71.98182316 | 2021-02-05 05:22:38 | Windham, Connecticut, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);