johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
203 rows where deaths = 873 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 120
- Russia 12
- Ukraine 8
- Peru 6
- France 5
- Italy 5
- Spain 5
- United Kingdom 5
- Chile 4
- Malaysia 4
- Fiji 3
- Austria 2
- Colombia 2
- Mexico 2
- Netherlands 2
- Pakistan 2
- Australia 1
- Brazil 1
- Bulgaria 1
- Canada 1
- Congo (Kinshasa) 1
- Cyprus 1
- El Salvador 1
- Germany 1
- India 1
- Japan 1
- Nigeria 1
- Philippines 1
- Sweden 1
- Syria 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1075628 | 1075628 | 2022-12-28 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-29 04:21:01 | Dakota, Minnesota, US | |
329625 | 329625 | 2022-12-27 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-28 04:21:04 | Dakota, Minnesota, US | |
219698 | 219698 | 2022-12-26 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-27 04:21:07 | Dakota, Minnesota, US | |
3224155 | 3224155 | 2022-12-25 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-26 04:21:06 | Dakota, Minnesota, US | |
1020069 | 1020069 | 2022-12-24 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-25 04:21:04 | Dakota, Minnesota, US | |
692092 | 692092 | 2022-12-23 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-24 04:21:02 | Dakota, Minnesota, US | |
2181302 | 2181302 | 2022-12-22 | US | Minnesota | Dakota | 27037 | 133417 | 873 | 0 | 44.67172617 | -93.06299363 | 2022-12-23 04:21:04 | Dakota, Minnesota, US | |
3175435 | 3175435 | 2022-12-19 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-20 04:21:04 | Ingham, Michigan, US | |
1629952 | 1629952 | 2022-12-18 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-19 04:21:03 | Ingham, Michigan, US | |
505331 | 505331 | 2022-12-17 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-18 04:21:03 | Ingham, Michigan, US | |
3325903 | 3325903 | 2022-12-16 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-17 04:21:04 | Ingham, Michigan, US | |
544415 | 544415 | 2022-12-15 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-16 04:21:01 | Ingham, Michigan, US | |
349943 | 349943 | 2022-12-14 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-15 04:20:58 | Ingham, Michigan, US | |
348064 | 348064 | 2022-12-14 | Chile | Arica y Parinacota | 76056 | 873 | 0 | -18.594 | -69.4785 | 2022-12-15 04:20:58 | Arica y Parinacota, Chile | |||
309531 | 309531 | 2022-12-13 | US | Michigan | Ingham | 26065 | 81825 | 873 | 0 | 42.59716886 | -84.37472069 | 2022-12-14 04:21:04 | Ingham, Michigan, US | |
307652 | 307652 | 2022-12-13 | Chile | Arica y Parinacota | 75938 | 873 | 0 | -18.594 | -69.4785 | 2022-12-14 04:21:04 | Arica y Parinacota, Chile | |||
1148713 | 1148713 | 2022-12-12 | Chile | Arica y Parinacota | 75871 | 873 | 0 | -18.594 | -69.4785 | 2022-12-13 04:21:01 | Arica y Parinacota, Chile | |||
3552335 | 3552335 | 2022-11-27 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-28 04:21:02 | Bay, Florida, US | |
2100815 | 2100815 | 2022-11-26 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-27 04:21:05 | Bay, Florida, US | |
488306 | 488306 | 2022-11-25 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-26 04:21:11 | Bay, Florida, US | |
3524135 | 3524135 | 2022-11-24 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-25 04:21:06 | Bay, Florida, US | |
3312918 | 3312918 | 2022-11-23 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-24 04:21:09 | Bay, Florida, US | |
1620959 | 1620959 | 2022-11-22 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-23 04:21:06 | Bay, Florida, US | |
3460847 | 3460847 | 2022-11-21 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-22 04:20:47 | Bay, Florida, US | |
1641032 | 1641032 | 2022-11-20 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-21 04:21:05 | Bay, Florida, US | |
2064589 | 2064589 | 2022-11-19 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-20 04:21:08 | Bay, Florida, US | |
1755983 | 1755983 | 2022-11-18 | US | Florida | Bay | 12005 | 54216 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-19 04:21:14 | Bay, Florida, US | |
3026976 | 3026976 | 2022-11-17 | US | Florida | Bay | 12005 | 54039 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-18 04:21:15 | Bay, Florida, US | |
2486687 | 2486687 | 2022-11-16 | US | Florida | Bay | 12005 | 54039 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-17 04:21:11 | Bay, Florida, US | |
292698 | 292698 | 2022-11-15 | US | Florida | Bay | 12005 | 54039 | 873 | 0 | 30.26548745 | -85.62122584 | 2022-11-16 04:21:09 | Bay, Florida, US | |
1880082 | 1880082 | 2022-08-28 | US | Texas | Galveston | 48167 | 112294 | 873 | 0 | 29.40167322 | -94.90469073 | 2022-08-29 04:21:06 | Galveston, Texas, US | |
2099209 | 2099209 | 2022-08-27 | US | Texas | Galveston | 48167 | 112294 | 873 | 0 | 29.40167322 | -94.90469073 | 2022-08-28 04:21:02 | Galveston, Texas, US | |
1535024 | 1535024 | 2022-08-26 | US | Texas | Galveston | 48167 | 112294 | 873 | 0 | 29.40167322 | -94.90469073 | 2022-08-27 04:20:57 | Galveston, Texas, US | |
2831911 | 2831911 | 2022-08-25 | US | Texas | Galveston | 48167 | 112106 | 873 | 0 | 29.40167322 | -94.90469073 | 2022-08-26 04:21:02 | Galveston, Texas, US | |
2855056 | 2855056 | 2022-08-22 | US | New Mexico | Dona Ana | 35013 | 71664 | 873 | 0 | 32.35275771 | -106.8329387 | 2022-08-23 04:20:56 | Dona Ana, New Mexico, US | |
1097993 | 1097993 | 2022-08-03 | Fiji | 67673 | 873 | 0 | -17.7134 | 178.065 | 2022-08-04 04:20:58 | Fiji | ||||
1404918 | 1404918 | 2022-08-02 | Fiji | 67673 | 873 | 0 | -17.7134 | 178.065 | 2022-08-03 04:20:59 | Fiji | ||||
3616956 | 3616956 | 2022-08-01 | Fiji | 67673 | 873 | 0 | -17.7134 | 178.065 | 2022-08-02 04:20:53 | Fiji | ||||
1783581 | 1783581 | 2022-07-29 | Malaysia | Terengganu | 127343 | 873 | 0 | 5.3117 | 103.1324 | 2022-07-30 04:20:42 | Terengganu, Malaysia | |||
1065944 | 1065944 | 2022-07-28 | Malaysia | Terengganu | 127322 | 873 | 0 | 5.3117 | 103.1324 | 2022-07-29 04:20:45 | Terengganu, Malaysia | |||
2335463 | 2335463 | 2022-07-27 | Malaysia | Terengganu | 127290 | 873 | 0 | 5.3117 | 103.1324 | 2022-07-28 04:20:56 | Terengganu, Malaysia | |||
1487653 | 1487653 | 2022-07-26 | Malaysia | Terengganu | 127248 | 873 | 0 | 5.3117 | 103.1324 | 2022-07-27 04:21:04 | Terengganu, Malaysia | |||
2741479 | 2741479 | 2022-07-07 | US | Arkansas | Benton | 5007 | 69610 | 873 | 0 | 36.33644656 | -94.25680817 | 2022-07-08 04:20:56 | Benton, Arkansas, US | |
1200274 | 1200274 | 2022-07-06 | US | Arkansas | Benton | 5007 | 69507 | 873 | 0 | 36.33644656 | -94.25680817 | 2022-07-07 04:20:55 | Benton, Arkansas, US | |
166721 | 166721 | 2022-06-21 | US | Delaware | Sussex | 10005 | 66365 | 873 | 0 | 38.66143781 | -75.39031349 | 2022-06-22 04:20:54 | Sussex, Delaware, US | |
3890452 | 3890452 | 2022-06-06 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-07 04:21:08 | Lexington, South Carolina, US | |
3510221 | 3510221 | 2022-06-05 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-06 04:20:57 | Lexington, South Carolina, US | |
3530298 | 3530298 | 2022-06-04 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-05 04:20:55 | Lexington, South Carolina, US | |
3136384 | 3136384 | 2022-06-03 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-04 04:20:58 | Lexington, South Carolina, US | |
3581459 | 3581459 | 2022-06-02 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-03 04:20:58 | Lexington, South Carolina, US | |
973752 | 973752 | 2022-06-01 | US | South Carolina | Lexington | 45063 | 98224 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-02 05:20:39 | Lexington, South Carolina, US | |
232059 | 232059 | 2022-05-31 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-06-01 04:20:55 | Lexington, South Carolina, US | |
3188824 | 3188824 | 2022-05-30 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-31 04:20:51 | Lexington, South Carolina, US | |
3200973 | 3200973 | 2022-05-29 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-30 04:20:50 | Lexington, South Carolina, US | |
2727851 | 2727851 | 2022-05-28 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-29 04:20:53 | Lexington, South Carolina, US | |
1317032 | 1317032 | 2022-05-27 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-28 04:21:07 | Lexington, South Carolina, US | |
1852824 | 1852824 | 2022-05-26 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-27 04:20:56 | Lexington, South Carolina, US | |
2050700 | 2050700 | 2022-05-25 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-26 04:20:50 | Lexington, South Carolina, US | |
3002138 | 3002138 | 2022-05-24 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-25 04:20:56 | Lexington, South Carolina, US | |
624711 | 624711 | 2022-05-22 | US | South Carolina | Lexington | 45063 | 97534 | 873 | 0 | 33.89665987 | -81.27146426 | 2022-05-26 04:20:50 | Lexington, South Carolina, US | |
2599187 | 2599187 | 2022-05-05 | US | Indiana | St. Joseph | 18141 | 71349 | 873 | 0 | 41.61756781 | -86.29040834 | 2022-05-06 04:21:00 | St. Joseph, Indiana, US | |
3266636 | 3266636 | 2022-05-04 | US | Indiana | St. Joseph | 18141 | 71349 | 873 | 0 | 41.61756781 | -86.29040834 | 2022-05-05 04:20:55 | St. Joseph, Indiana, US | |
1573275 | 1573275 | 2022-05-03 | US | Indiana | St. Joseph | 18141 | 71272 | 873 | 0 | 41.61756781 | -86.29040834 | 2022-05-04 04:20:59 | St. Joseph, Indiana, US | |
464535 | 464535 | 2022-05-02 | US | Indiana | St. Joseph | 18141 | 71272 | 873 | 0 | 41.61756781 | -86.29040834 | 2022-05-03 04:21:00 | St. Joseph, Indiana, US | |
3722165 | 3722165 | 2022-04-25 | Italy | Basilicata | 123751 | 873 | 0 | 40.63947052 | 15.80514834 | 2022-04-26 04:20:51 | Basilicata, Italy | |||
2028733 | 2028733 | 2022-04-24 | Italy | Basilicata | 123502 | 873 | 0 | 40.63947052 | 15.80514834 | 2022-04-25 04:20:56 | Basilicata, Italy | |||
1540827 | 1540827 | 2022-03-31 | US | Georgia | Richmond | 13245 | 49996 | 873 | 0 | 33.35777107 | -82.07026432 | 2022-04-01 04:20:28 | Richmond, Georgia, US | |
161270 | 161270 | 2022-03-29 | US | Texas | Williamson | 48491 | 132485 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-30 04:20:45 | Williamson, Texas, US | |
1439841 | 1439841 | 2022-03-28 | US | Texas | Williamson | 48491 | 132327 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-29 04:20:46 | Williamson, Texas, US | |
879522 | 879522 | 2022-03-27 | US | Texas | Williamson | 48491 | 132240 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-28 04:20:33 | Williamson, Texas, US | |
2166805 | 2166805 | 2022-03-26 | US | Texas | Williamson | 48491 | 132240 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-27 04:20:47 | Williamson, Texas, US | |
1723741 | 1723741 | 2022-03-25 | US | Texas | Williamson | 48491 | 132240 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-26 04:20:23 | Williamson, Texas, US | |
1471358 | 1471358 | 2022-03-24 | US | Texas | Williamson | 48491 | 132197 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-25 04:20:46 | Williamson, Texas, US | |
3025532 | 3025532 | 2022-03-23 | US | Texas | Williamson | 48491 | 132134 | 873 | 0 | 30.64655664 | -97.60048540000001 | 2022-03-24 04:20:43 | Williamson, Texas, US | |
2665655 | 2665655 | 2022-03-04 | Cyprus | 329674 | 873 | 0 | 35.1264 | 33.4299 | 2022-03-05 04:21:10 | Cyprus | ||||
1994818 | 1994818 | 2022-03-01 | US | New Hampshire | Hillsborough | 33011 | 95717 | 873 | 0 | 42.91537785 | -71.7200253 | 2022-03-02 04:21:07 | Hillsborough, New Hampshire, US | |
1298830 | 1298830 | 2022-02-17 | US | Georgia | Clayton | 13063 | 62731 | 873 | 0 | 33.54187245 | -84.35594188 | 2022-02-18 04:21:04 | Clayton, Georgia, US | |
3671531 | 3671531 | 2022-02-15 | France | Guadeloupe | 112668 | 873 | 0 | 16.265 | -61.551 | 2022-02-16 04:21:10 | Guadeloupe, France | |||
2641987 | 2641987 | 2022-02-14 | Russia | Novgorod Oblast | 82470 | 873 | 0 | 58.2843833 | 32.516975699999996 | 2022-02-15 04:21:09 | Novgorod Oblast, Russia | |||
2641632 | 2641632 | 2022-02-14 | France | Guadeloupe | 112668 | 873 | 0 | 16.265 | -61.551 | 2022-02-15 04:21:09 | Guadeloupe, France | |||
185949 | 185949 | 2022-02-13 | France | Guadeloupe | 112668 | 873 | 0 | 16.265 | -61.551 | 2022-02-14 04:20:51 | Guadeloupe, France | |||
315795 | 315795 | 2022-02-12 | France | Guadeloupe | 112668 | 873 | 0 | 16.265 | -61.551 | 2022-02-13 04:21:00 | Guadeloupe, France | |||
233121 | 233121 | 2022-02-11 | France | Guadeloupe | 112668 | 873 | 0 | 16.265 | -61.551 | 2022-02-12 04:21:06 | Guadeloupe, France | |||
979860 | 979860 | 2022-02-01 | US | Hawaii | Honolulu | 15003 | 154279 | 873 | 0 | 21.45803166 | -157.97121819999995 | 2022-02-02 04:21:09 | Honolulu, Hawaii, US | |
2658702 | 2658702 | 2022-01-31 | US | Hawaii | Honolulu | 15003 | 153552 | 873 | 0 | 21.45803166 | -157.97121819999995 | 2022-02-01 04:21:11 | Honolulu, Hawaii, US | |
1141213 | 1141213 | 2022-01-23 | Spain | La Rioja | 77806 | 873 | 0 | 42.2871 | -2.5396 | 2022-01-24 04:21:12 | La Rioja, Spain | |||
2833131 | 2833131 | 2022-01-22 | Spain | La Rioja | 77806 | 873 | 0 | 42.2871 | -2.5396 | 2022-01-23 04:21:13 | La Rioja, Spain | |||
3425249 | 3425249 | 2022-01-21 | Spain | La Rioja | 77806 | 873 | 0 | 42.2871 | -2.5396 | 2022-01-22 04:21:13 | La Rioja, Spain | |||
1960857 | 1960857 | 2022-01-20 | Spain | La Rioja | 77153 | 873 | 0 | 42.2871 | -2.5396 | 2022-01-21 04:21:09 | La Rioja, Spain | |||
1475576 | 1475576 | 2022-01-17 | US | Washington | Snohomish | 53061 | 103791 | 873 | 0 | 48.04615983 | -121.7170703 | 2022-01-18 04:21:04 | Snohomish, Washington, US | |
558250 | 558250 | 2022-01-16 | US | Washington | Snohomish | 53061 | 103791 | 873 | 0 | 48.04615983 | -121.7170703 | 2022-01-17 04:21:08 | Snohomish, Washington, US | |
3843971 | 3843971 | 2022-01-15 | US | Washington | Snohomish | 53061 | 103791 | 873 | 0 | 48.04615983 | -121.7170703 | 2022-01-16 04:21:12 | Snohomish, Washington, US | |
102786 | 102786 | 2022-01-14 | US | Washington | Snohomish | 53061 | 103791 | 873 | 0 | 48.04615983 | -121.7170703 | 2022-01-15 04:21:07 | Snohomish, Washington, US | |
1703380 | 1703380 | 2022-01-03 | US | Texas | Brazoria | 48039 | 71859 | 873 | 0 | 29.18757369 | -95.44563172 | 2022-01-04 04:22:17 | Brazoria, Texas, US | |
1435169 | 1435169 | 2021-12-28 | US | Oklahoma | Unassigned | 90040 | 11448 | 873 | 0 | 36.83532655 | 0.0 | 2021-12-29 03:21:43 | Unassigned, Oklahoma, US | |
2113953 | 2113953 | 2021-12-26 | US | New York | Onondaga | 36067 | 67800 | 873 | 0 | 43.00491923 | -76.19971155 | 2021-12-27 04:21:58 | Onondaga, New York, US | |
1660651 | 1660651 | 2021-12-12 | Russia | Mari El Republic | 27762 | 873 | 0 | 56.576750399999995 | 47.881751200000004 | 2021-12-13 04:22:02 | Mari El Republic, Russia | |||
2195833 | 2195833 | 2021-12-03 | Russia | Karachay-Cherkess Republic | 30329 | 873 | 0 | 43.7368326 | 41.7267991 | 2021-12-04 04:22:18 | Karachay-Cherkess Republic, Russia | |||
3639314 | 3639314 | 2021-11-08 | Canada | Saskatchewan | 78824 | 873 | 0 | 52.9399 | -106.4509 | 2021-11-09 04:21:36 | Saskatchewan, Canada | |||
7801 | 7801 | 2021-10-28 | US | Washington | Pierce | 53053 | 92241 | 873 | 0 | 47.03892768 | -122.14059579999999 | 2021-10-29 04:22:03 | Pierce, Washington, 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]);