johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
485 rows where deaths = 802 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1018355 | 1018355 | 2022-12-24 | Japan | Kumamoto | 429731 | 802 | 0 | 32.608154 | 130.745231 | 2022-12-25 04:21:04 | Kumamoto, Japan | |||
454788 | 454788 | 2022-12-21 | US | Virginia | Prince William | 51153 | 122021 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-22 04:20:56 | Prince William, Virginia, US | |
1631706 | 1631706 | 2022-12-18 | US | Virginia | Prince William | 51153 | 121413 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-19 04:21:03 | Prince William, Virginia, US | |
507085 | 507085 | 2022-12-17 | US | Virginia | Prince William | 51153 | 121413 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-18 04:21:03 | Prince William, Virginia, US | |
3327657 | 3327657 | 2022-12-16 | US | Virginia | Prince William | 51153 | 121413 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-17 04:21:04 | Prince William, Virginia, US | |
546169 | 546169 | 2022-12-15 | US | Virginia | Prince William | 51153 | 121273 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-16 04:21:01 | Prince William, Virginia, US | |
351697 | 351697 | 2022-12-14 | US | Virginia | Prince William | 51153 | 121131 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-15 04:20:58 | Prince William, Virginia, US | |
2418275 | 2418275 | 2022-12-05 | US | Virginia | Prince William | 51153 | 120240 | 802 | 0 | 38.70916224 | -77.48713689 | 2022-12-06 04:21:03 | Prince William, Virginia, US | |
1239684 | 1239684 | 2022-11-28 | Japan | Shizuoka | 570136 | 802 | 0 | 34.916975 | 138.407784 | 2022-11-29 04:21:05 | Shizuoka, Japan | |||
3551672 | 3551672 | 2022-11-27 | Japan | Shizuoka | 568710 | 802 | 0 | 34.916975 | 138.407784 | 2022-11-28 04:21:02 | Shizuoka, Japan | |||
2485996 | 2485996 | 2022-11-16 | Japan | Hiroshima | 492663 | 802 | 0 | 34.605309 | 132.788719 | 2022-11-17 04:21:11 | Hiroshima, Japan | |||
294671 | 294671 | 2022-11-15 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-16 04:21:09 | Butler, Pennsylvania, US | |
3599701 | 3599701 | 2022-11-14 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-15 04:21:16 | Butler, Pennsylvania, US | |
314559 | 314559 | 2022-11-13 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-14 04:21:09 | Butler, Pennsylvania, US | |
311895 | 311895 | 2022-11-13 | Japan | Hiroshima | 489053 | 802 | 0 | 34.605309 | 132.788719 | 2022-11-14 04:21:09 | Hiroshima, Japan | |||
65720 | 65720 | 2022-11-12 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-13 04:21:14 | Butler, Pennsylvania, US | |
2929882 | 2929882 | 2022-11-11 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-12 04:20:41 | Butler, Pennsylvania, US | |
2508718 | 2508718 | 2022-11-10 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-11 04:21:22 | Butler, Pennsylvania, US | |
2433593 | 2433593 | 2022-11-09 | US | Pennsylvania | Butler | 42019 | 52712 | 802 | 0 | 40.91152759 | -79.91351055 | 2022-11-10 04:21:16 | Butler, Pennsylvania, US | |
3253641 | 3253641 | 2022-10-11 | US | West Virginia | Kanawha | 54039 | 56023 | 802 | 0 | 38.33860077 | -81.52857054 | 2022-10-12 04:22:51 | Kanawha, West Virginia, US | |
2970900 | 2970900 | 2022-10-10 | US | West Virginia | Kanawha | 54039 | 55973 | 802 | 0 | 38.33860077 | -81.52857054 | 2022-10-11 04:23:05 | Kanawha, West Virginia, US | |
3100936 | 3100936 | 2022-10-09 | US | West Virginia | Kanawha | 54039 | 55973 | 802 | 0 | 38.33860077 | -81.52857054 | 2022-10-10 04:22:32 | Kanawha, West Virginia, US | |
4006161 | 4006161 | 2022-10-08 | US | West Virginia | Kanawha | 54039 | 55973 | 802 | 0 | 38.33860077 | -81.52857054 | 2022-10-09 04:21:16 | Kanawha, West Virginia, US | |
399758 | 399758 | 2022-10-07 | US | West Virginia | Kanawha | 54039 | 55973 | 802 | 0 | 38.33860077 | -81.52857054 | 2022-10-08 04:22:56 | Kanawha, West Virginia, US | |
3765953 | 3765953 | 2022-09-11 | Malta | 114265 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-12 04:20:58 | Malta | ||||
3824528 | 3824528 | 2022-09-10 | Malta | 114251 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-11 04:20:50 | Malta | ||||
962985 | 962985 | 2022-09-09 | Malta | 114228 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-10 04:21:10 | Malta | ||||
253387 | 253387 | 2022-09-08 | Malta | 114206 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-09 04:21:11 | Malta | ||||
3745185 | 3745185 | 2022-09-07 | Malta | 114195 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-08 04:21:02 | Malta | ||||
114825 | 114825 | 2022-09-06 | Malta | 114172 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-07 04:20:59 | Malta | ||||
2633797 | 2633797 | 2022-09-05 | Malta | 114151 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-06 04:21:02 | Malta | ||||
2987361 | 2987361 | 2022-09-04 | Malta | 114135 | 802 | 0 | 35.9375 | 14.3754 | 2022-09-05 04:21:01 | Malta | ||||
3777229 | 3777229 | 2022-08-30 | US | Virginia | Chesterfield | 51041 | 88966 | 802 | 0 | 37.37373208 | -77.5868014 | 2022-08-31 04:20:57 | Chesterfield, Virginia, US | |
1683825 | 1683825 | 2022-08-29 | US | Virginia | Chesterfield | 51041 | 88851 | 802 | 0 | 37.37373208 | -77.5868014 | 2022-08-30 04:21:03 | Chesterfield, Virginia, US | |
3647589 | 3647589 | 2022-08-14 | Japan | Kyoto | 357005 | 802 | 0 | 35.253815 | 135.443341 | 2022-08-15 04:20:59 | Kyoto, Japan | |||
1086834 | 1086834 | 2022-08-09 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-10 04:20:57 | Bibb, Georgia, US | |
3544249 | 3544249 | 2022-08-08 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-09 04:20:34 | Bibb, Georgia, US | |
1070652 | 1070652 | 2022-08-07 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-08 04:21:08 | Bibb, Georgia, US | |
1941240 | 1941240 | 2022-08-06 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-07 04:20:54 | Bibb, Georgia, US | |
881039 | 881039 | 2022-08-05 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-06 04:20:56 | Bibb, Georgia, US | |
2010662 | 2010662 | 2022-08-04 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-08-05 04:20:52 | St. Louis City, Missouri, US | |
2009450 | 2009450 | 2022-08-04 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-05 04:20:52 | Bibb, Georgia, US | |
1100089 | 1100089 | 2022-08-03 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-08-04 04:20:58 | St. Louis City, Missouri, US | |
1098877 | 1098877 | 2022-08-03 | US | Georgia | Bibb | 13021 | 41423 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-04 04:20:58 | Bibb, Georgia, US | |
1407014 | 1407014 | 2022-08-02 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-08-03 04:20:59 | St. Louis City, Missouri, US | |
1405802 | 1405802 | 2022-08-02 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-03 04:20:59 | Bibb, Georgia, US | |
3619052 | 3619052 | 2022-08-01 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-08-02 04:20:53 | St. Louis City, Missouri, US | |
3618725 | 3618725 | 2022-08-01 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-08-02 04:20:53 | Ingham, Michigan, US | |
3617840 | 3617840 | 2022-08-01 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-02 04:20:53 | Bibb, Georgia, US | |
3873532 | 3873532 | 2022-07-31 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-08-01 04:21:03 | St. Louis City, Missouri, US | |
3873205 | 3873205 | 2022-07-31 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-08-01 04:21:03 | Ingham, Michigan, US | |
3872320 | 3872320 | 2022-07-31 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-08-01 04:21:03 | Bibb, Georgia, US | |
676286 | 676286 | 2022-07-30 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-07-31 04:21:02 | St. Louis City, Missouri, US | |
675959 | 675959 | 2022-07-30 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-07-31 04:21:02 | Ingham, Michigan, US | |
675074 | 675074 | 2022-07-30 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-07-31 04:21:02 | Bibb, Georgia, US | |
1785485 | 1785485 | 2022-07-29 | US | Missouri | St. Louis City | 29510 | 66408 | 802 | 0 | 38.63555736 | -90.24349225 | 2022-07-30 04:20:42 | St. Louis City, Missouri, US | |
1785158 | 1785158 | 2022-07-29 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-07-30 04:20:42 | Ingham, Michigan, US | |
1784273 | 1784273 | 2022-07-29 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-07-30 04:20:42 | Bibb, Georgia, US | |
1067521 | 1067521 | 2022-07-28 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-07-29 04:20:45 | Ingham, Michigan, US | |
1066636 | 1066636 | 2022-07-28 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-07-29 04:20:45 | Bibb, Georgia, US | |
2337040 | 2337040 | 2022-07-27 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-07-28 04:20:56 | Ingham, Michigan, US | |
2336155 | 2336155 | 2022-07-27 | US | Georgia | Bibb | 13021 | 40986 | 802 | 0 | 32.80904227 | -83.70489165 | 2022-07-28 04:20:56 | Bibb, Georgia, US | |
1489230 | 1489230 | 2022-07-26 | US | Michigan | Ingham | 26065 | 72293 | 802 | 0 | 42.59716886 | -84.37472069 | 2022-07-27 04:21:04 | Ingham, Michigan, US | |
673770 | 673770 | 2022-07-21 | US | Washington | Yakima | 53077 | 76324 | 802 | 0 | 46.45738486 | -120.7380126 | 2022-07-22 04:21:15 | Yakima, Washington, US | |
1611733 | 1611733 | 2022-07-20 | US | Washington | Yakima | 53077 | 76324 | 802 | 0 | 46.45738486 | -120.7380126 | 2022-07-21 04:21:10 | Yakima, Washington, US | |
1609978 | 1609978 | 2022-07-20 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-21 04:21:10 | Dakota, Minnesota, US | |
962366 | 962366 | 2022-07-19 | US | Washington | Yakima | 53077 | 76163 | 802 | 0 | 46.45738486 | -120.7380126 | 2022-07-20 04:20:59 | Yakima, Washington, US | |
960611 | 960611 | 2022-07-19 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-20 04:20:59 | Dakota, Minnesota, US | |
958791 | 958791 | 2022-07-19 | Germany | Bremen | 231103 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-20 04:20:59 | Bremen, Germany | |||
3213753 | 3213753 | 2022-07-18 | US | Washington | Yakima | 53077 | 76163 | 802 | 0 | 46.45738486 | -120.7380126 | 2022-07-19 04:20:58 | Yakima, Washington, US | |
3211998 | 3211998 | 2022-07-18 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-19 04:20:58 | Dakota, Minnesota, US | |
3210178 | 3210178 | 2022-07-18 | Germany | Bremen | 230358 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-19 04:20:58 | Bremen, Germany | |||
3407173 | 3407173 | 2022-07-17 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-18 04:20:59 | Dakota, Minnesota, US | |
3405353 | 3405353 | 2022-07-17 | Germany | Bremen | 229216 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-18 04:20:59 | Bremen, Germany | |||
2153373 | 2153373 | 2022-07-16 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-17 04:21:15 | Dakota, Minnesota, US | |
2151553 | 2151553 | 2022-07-16 | Germany | Bremen | 229216 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-17 04:21:15 | Bremen, Germany | |||
2420606 | 2420606 | 2022-07-15 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-16 04:21:05 | Dakota, Minnesota, US | |
2418786 | 2418786 | 2022-07-15 | Germany | Bremen | 229216 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-16 04:21:05 | Bremen, Germany | |||
3430681 | 3430681 | 2022-07-14 | US | Minnesota | Dakota | 27037 | 121344 | 802 | 0 | 44.67172617 | -93.06299363 | 2022-07-15 04:20:53 | Dakota, Minnesota, US | |
3428861 | 3428861 | 2022-07-14 | Germany | Bremen | 227986 | 802 | 0 | 53.0793 | 8.8017 | 2022-07-15 04:20:53 | Bremen, Germany | |||
3110504 | 3110504 | 2022-07-13 | US | Illinois | Madison | 17119 | 76931 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-14 04:20:57 | Madison, Illinois, US | |
630927 | 630927 | 2022-07-12 | US | Illinois | Madison | 17119 | 76827 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-13 04:20:58 | Madison, Illinois, US | |
1212571 | 1212571 | 2022-07-11 | US | Illinois | Madison | 17119 | 76715 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-12 04:20:51 | Madison, Illinois, US | |
2790053 | 2790053 | 2022-07-10 | US | Illinois | Madison | 17119 | 76461 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-11 04:20:46 | Madison, Illinois, US | |
143006 | 143006 | 2022-07-09 | US | Illinois | Madison | 17119 | 76461 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-10 04:20:54 | Madison, Illinois, US | |
1418106 | 1418106 | 2022-07-08 | US | Illinois | Madison | 17119 | 76461 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-09 04:20:59 | Madison, Illinois, US | |
2742031 | 2742031 | 2022-07-07 | US | Illinois | Madison | 17119 | 76326 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-08 04:20:56 | Madison, Illinois, US | |
1200826 | 1200826 | 2022-07-06 | US | Illinois | Madison | 17119 | 76226 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-07 04:20:55 | Madison, Illinois, US | |
3967569 | 3967569 | 2022-07-05 | US | Illinois | Madison | 17119 | 76125 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-06 04:20:58 | Madison, Illinois, US | |
3079080 | 3079080 | 2022-07-04 | US | Illinois | Madison | 17119 | 75908 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-05 04:20:45 | Madison, Illinois, US | |
1768362 | 1768362 | 2022-07-03 | US | Illinois | Madison | 17119 | 75908 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-04 04:20:54 | Madison, Illinois, US | |
3366348 | 3366348 | 2022-07-02 | US | Illinois | Madison | 17119 | 75908 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-03 04:20:59 | Madison, Illinois, US | |
594677 | 594677 | 2022-07-01 | US | Illinois | Madison | 17119 | 75908 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-02 04:21:16 | Madison, Illinois, US | |
3941078 | 3941078 | 2022-06-30 | US | Illinois | Madison | 17119 | 75796 | 802 | 0 | 38.83042506 | -89.90422563 | 2022-07-01 04:21:10 | Madison, Illinois, US | |
165899 | 165899 | 2022-06-21 | Cote d'Ivoire | 82805 | 802 | 0 | 7.54 | -5.5471 | 2022-06-22 04:20:54 | Cote d'Ivoire | ||||
1763182 | 1763182 | 2022-06-20 | Cote d'Ivoire | 82743 | 802 | 0 | 7.54 | -5.5471 | 2022-06-21 04:20:56 | Cote d'Ivoire | ||||
3269368 | 3269368 | 2022-06-19 | Cote d'Ivoire | 82724 | 802 | 0 | 7.54 | -5.5471 | 2022-06-20 04:21:01 | Cote d'Ivoire | ||||
3509087 | 3509087 | 2022-06-05 | US | Minnesota | Anoka | 27003 | 102823 | 802 | 0 | 45.27476015 | -93.24604565 | 2022-06-06 04:20:57 | Anoka, Minnesota, US | |
3529164 | 3529164 | 2022-06-04 | US | Minnesota | Anoka | 27003 | 102823 | 802 | 0 | 45.27476015 | -93.24604565 | 2022-06-05 04:20:55 | Anoka, Minnesota, US | |
3135250 | 3135250 | 2022-06-03 | US | Minnesota | Anoka | 27003 | 102823 | 802 | 0 | 45.27476015 | -93.24604565 | 2022-06-04 04:20:58 | Anoka, Minnesota, 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]);