johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
503 rows where deaths = 669 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756009 | 2756009 | 2022-12-29 | US | Texas | Grayson | 48181 | 31059 | 669 | 0 | 33.62744998 | -96.67753461 | 2022-12-30 04:21:04 | Grayson, Texas, US | |
2753059 | 2753059 | 2022-12-29 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-30 04:21:04 | Papua New Guinea | ||||
1077015 | 1077015 | 2022-12-28 | US | Texas | Grayson | 48181 | 31059 | 669 | 0 | 33.62744998 | -96.67753461 | 2022-12-29 04:21:01 | Grayson, Texas, US | |
1074483 | 1074483 | 2022-12-28 | US | California | Placer | 6061 | 89147 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-29 04:21:01 | Placer, California, US | |
1074065 | 1074065 | 2022-12-28 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-29 04:21:01 | Papua New Guinea | ||||
328480 | 328480 | 2022-12-27 | US | California | Placer | 6061 | 89147 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-28 04:21:04 | Placer, California, US | |
328062 | 328062 | 2022-12-27 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-28 04:21:04 | Papua New Guinea | ||||
218553 | 218553 | 2022-12-26 | US | California | Placer | 6061 | 88806 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-27 04:21:07 | Placer, California, US | |
218135 | 218135 | 2022-12-26 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-27 04:21:07 | Papua New Guinea | ||||
3223010 | 3223010 | 2022-12-25 | US | California | Placer | 6061 | 88806 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-26 04:21:06 | Placer, California, US | |
3222592 | 3222592 | 2022-12-25 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-26 04:21:06 | Papua New Guinea | ||||
1018924 | 1018924 | 2022-12-24 | US | California | Placer | 6061 | 88806 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-25 04:21:04 | Placer, California, US | |
1018506 | 1018506 | 2022-12-24 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-25 04:21:04 | Papua New Guinea | ||||
690947 | 690947 | 2022-12-23 | US | California | Placer | 6061 | 88806 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-24 04:21:02 | Placer, California, US | |
690529 | 690529 | 2022-12-23 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-24 04:21:02 | Papua New Guinea | ||||
2180157 | 2180157 | 2022-12-22 | US | California | Placer | 6061 | 88806 | 669 | 0 | 39.06167234 | -120.7240569 | 2022-12-23 04:21:04 | Placer, California, US | |
2179739 | 2179739 | 2022-12-22 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-23 04:21:04 | Papua New Guinea | ||||
451543 | 451543 | 2022-12-21 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-22 04:20:56 | Papua New Guinea | ||||
2954042 | 2954042 | 2022-12-20 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-21 04:21:03 | Blair, Pennsylvania, US | |
2953685 | 2953685 | 2022-12-20 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-21 04:21:03 | Buncombe, North Carolina, US | |
2951542 | 2951542 | 2022-12-20 | Papua New Guinea | 46557 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-21 04:21:03 | Papua New Guinea | ||||
3176444 | 3176444 | 2022-12-19 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-20 04:21:04 | Blair, Pennsylvania, US | |
3176087 | 3176087 | 2022-12-19 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-20 04:21:04 | Buncombe, North Carolina, US | |
3173944 | 3173944 | 2022-12-19 | Papua New Guinea | 46557 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-20 04:21:04 | Papua New Guinea | ||||
1630961 | 1630961 | 2022-12-18 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-19 04:21:03 | Blair, Pennsylvania, US | |
1630604 | 1630604 | 2022-12-18 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-19 04:21:03 | Buncombe, North Carolina, US | |
1628461 | 1628461 | 2022-12-18 | Papua New Guinea | 46557 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-19 04:21:03 | Papua New Guinea | ||||
506340 | 506340 | 2022-12-17 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-18 04:21:03 | Blair, Pennsylvania, US | |
505983 | 505983 | 2022-12-17 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-18 04:21:03 | Buncombe, North Carolina, US | |
503840 | 503840 | 2022-12-17 | Papua New Guinea | 46557 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-18 04:21:03 | Papua New Guinea | ||||
3326912 | 3326912 | 2022-12-16 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-17 04:21:04 | Blair, Pennsylvania, US | |
3326555 | 3326555 | 2022-12-16 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-17 04:21:04 | Buncombe, North Carolina, US | |
3324412 | 3324412 | 2022-12-16 | Papua New Guinea | 46557 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-17 04:21:04 | Papua New Guinea | ||||
545424 | 545424 | 2022-12-15 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-16 04:21:01 | Blair, Pennsylvania, US | |
545067 | 545067 | 2022-12-15 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-16 04:21:01 | Buncombe, North Carolina, US | |
542924 | 542924 | 2022-12-15 | Papua New Guinea | 46542 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-16 04:21:01 | Papua New Guinea | ||||
350952 | 350952 | 2022-12-14 | US | Pennsylvania | Blair | 42013 | 34158 | 669 | 0 | 40.47961444 | -78.34917412 | 2022-12-15 04:20:58 | Blair, Pennsylvania, US | |
350595 | 350595 | 2022-12-14 | US | North Carolina | Buncombe | 37021 | 67566 | 669 | 0 | 35.61113393 | -82.53305 | 2022-12-15 04:20:58 | Buncombe, North Carolina, US | |
348452 | 348452 | 2022-12-14 | Papua New Guinea | 46457 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-15 04:20:58 | Papua New Guinea | ||||
309036 | 309036 | 2022-12-13 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-14 04:21:04 | Vanderburgh, Indiana, US | |
308040 | 308040 | 2022-12-13 | Papua New Guinea | 46457 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-14 04:21:04 | Papua New Guinea | ||||
1150097 | 1150097 | 2022-12-12 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-13 04:21:01 | Vanderburgh, Indiana, US | |
1149101 | 1149101 | 2022-12-12 | Papua New Guinea | 46457 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-13 04:21:01 | Papua New Guinea | ||||
869951 | 869951 | 2022-12-11 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-12 04:21:01 | Vanderburgh, Indiana, US | |
258481 | 258481 | 2022-12-10 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-11 04:20:50 | Vanderburgh, Indiana, US | |
3937195 | 3937195 | 2022-12-09 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-10 04:21:02 | Vanderburgh, Indiana, US | |
3378527 | 3378527 | 2022-12-08 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-09 04:21:05 | Vanderburgh, Indiana, US | |
1985798 | 1985798 | 2022-12-07 | US | Indiana | Vanderburgh | 18163 | 68018 | 669 | 0 | 38.02658833 | -87.58763124 | 2022-12-08 04:21:07 | Vanderburgh, Indiana, US | |
3599867 | 3599867 | 2022-11-14 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-15 04:21:16 | Florence, South Carolina, US | |
314725 | 314725 | 2022-11-13 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-14 04:21:09 | Florence, South Carolina, US | |
65886 | 65886 | 2022-11-12 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-13 04:21:14 | Florence, South Carolina, US | |
63066 | 63066 | 2022-11-12 | Japan | Kumamoto | 352234 | 669 | 0 | 32.608154 | 130.745231 | 2022-11-13 04:21:14 | Kumamoto, Japan | |||
2930048 | 2930048 | 2022-11-11 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-12 04:20:41 | Florence, South Carolina, US | |
2508884 | 2508884 | 2022-11-10 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-11 04:21:22 | Florence, South Carolina, US | |
2433759 | 2433759 | 2022-11-09 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-10 04:21:16 | Florence, South Carolina, US | |
482415 | 482415 | 2022-11-08 | US | South Carolina | Florence | 45041 | 48221 | 669 | 0 | 34.02361754 | -79.70189312 | 2022-11-09 04:21:22 | Florence, South Carolina, US | |
480369 | 480369 | 2022-11-08 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-09 04:21:22 | Cherokee, Georgia, US | |
2439519 | 2439519 | 2022-11-07 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-08 04:21:21 | Cherokee, Georgia, US | |
1050617 | 1050617 | 2022-11-06 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-07 04:21:26 | Cherokee, Georgia, US | |
618641 | 618641 | 2022-11-05 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-06 04:21:24 | Cherokee, Georgia, US | |
1023145 | 1023145 | 2022-11-04 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-05 04:21:52 | Cherokee, Georgia, US | |
432136 | 432136 | 2022-11-03 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-04 04:22:11 | Cherokee, Georgia, US | |
850378 | 850378 | 2022-11-02 | US | Georgia | Cherokee | 13057 | 72546 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-03 04:22:05 | Cherokee, Georgia, US | |
711229 | 711229 | 2022-11-01 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-02 04:22:09 | Cherokee, Georgia, US | |
3285678 | 3285678 | 2022-10-31 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-11-01 04:22:36 | Cherokee, Georgia, US | |
320711 | 320711 | 2022-10-30 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-31 04:21:36 | Cherokee, Georgia, US | |
912987 | 912987 | 2022-10-29 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-30 04:22:14 | Cherokee, Georgia, US | |
1367256 | 1367256 | 2022-10-28 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-29 04:21:13 | Cherokee, Georgia, US | |
3039111 | 3039111 | 2022-10-27 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-28 04:22:31 | Cherokee, Georgia, US | |
539531 | 539531 | 2022-10-26 | US | Georgia | Cherokee | 13057 | 72470 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-27 04:22:01 | Cherokee, Georgia, US | |
539085 | 539085 | 2022-10-26 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-27 04:22:01 | Vasternorrland, Sweden | |||
1830932 | 1830932 | 2022-10-25 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-26 04:22:19 | Cherokee, Georgia, US | |
1830486 | 1830486 | 2022-10-25 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-26 04:22:19 | Vasternorrland, Sweden | |||
795193 | 795193 | 2022-10-24 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-25 04:21:53 | Cherokee, Georgia, US | |
794747 | 794747 | 2022-10-24 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-25 04:21:53 | Vasternorrland, Sweden | |||
3278272 | 3278272 | 2022-10-23 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-24 04:22:29 | Fayette, Kentucky, US | |
3277648 | 3277648 | 2022-10-23 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-24 04:22:29 | Cherokee, Georgia, US | |
3277202 | 3277202 | 2022-10-23 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-24 04:22:29 | Vasternorrland, Sweden | |||
2269310 | 2269310 | 2022-10-22 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-23 04:22:46 | Fayette, Kentucky, US | |
2268686 | 2268686 | 2022-10-22 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-23 04:22:46 | Cherokee, Georgia, US | |
2268240 | 2268240 | 2022-10-22 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-23 04:22:46 | Vasternorrland, Sweden | |||
1593610 | 1593610 | 2022-10-21 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-22 04:22:53 | Fayette, Kentucky, US | |
1592986 | 1592986 | 2022-10-21 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-22 04:22:53 | Cherokee, Georgia, US | |
1592540 | 1592540 | 2022-10-21 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-22 04:22:53 | Vasternorrland, Sweden | |||
2273326 | 2273326 | 2022-10-20 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-21 04:22:23 | Fayette, Kentucky, US | |
2272702 | 2272702 | 2022-10-20 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-21 04:22:23 | Cherokee, Georgia, US | |
2272256 | 2272256 | 2022-10-20 | Sweden | Vasternorrland | 56120 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-21 04:22:23 | Vasternorrland, Sweden | |||
199661 | 199661 | 2022-10-19 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-20 04:22:59 | Fayette, Kentucky, US | |
199037 | 199037 | 2022-10-19 | US | Georgia | Cherokee | 13057 | 72372 | 669 | 0 | 34.24393976 | -84.47431861 | 2022-10-20 04:22:59 | Cherokee, Georgia, US | |
198591 | 198591 | 2022-10-19 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-20 04:22:59 | Vasternorrland, Sweden | |||
2758322 | 2758322 | 2022-10-18 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-19 04:22:26 | Fayette, Kentucky, US | |
2757252 | 2757252 | 2022-10-18 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-19 04:22:26 | Vasternorrland, Sweden | |||
2026156 | 2026156 | 2022-10-17 | US | Kentucky | Fayette | 21067 | 114538 | 669 | 0 | 38.0368225 | -84.45576892 | 2022-10-18 04:22:42 | Fayette, Kentucky, US | |
2025086 | 2025086 | 2022-10-17 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-18 04:22:42 | Vasternorrland, Sweden | |||
2159864 | 2159864 | 2022-10-16 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-17 04:20:31 | Vasternorrland, Sweden | |||
516061 | 516061 | 2022-10-15 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-16 04:22:39 | Vasternorrland, Sweden | |||
2033118 | 2033118 | 2022-10-14 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-15 04:22:00 | Vasternorrland, Sweden | |||
3753806 | 3753806 | 2022-10-13 | Sweden | Vasternorrland | 56000 | 669 | 0 | 63.4276 | 17.7292 | 2022-10-14 04:22:28 | Vasternorrland, Sweden | |||
396803 | 396803 | 2022-10-07 | US | Arkansas | Washington | 5143 | 76852 | 669 | 0 | 35.976844 | -94.21800746 | 2022-10-08 04:22:56 | Washington, Arkansas, US | |
2529068 | 2529068 | 2022-10-06 | Australia | Western Australia | 1159261 | 669 | 0 | -31.9505 | 115.8605 | 2022-10-07 04:23:08 | Western Australia, Australia |
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]);