johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
688 rows where deaths = 551 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756023 | 2756023 | 2022-12-29 | US | Texas | Hays | 48209 | 76535 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-30 04:21:04 | Hays, Texas, US | |
2754686 | 2754686 | 2022-12-29 | US | Minnesota | Washington | 27163 | 80897 | 551 | 0 | 45.03864533 | -92.88429635 | 2022-12-30 04:21:04 | Washington, Minnesota, US | |
1077029 | 1077029 | 2022-12-28 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-29 04:21:01 | Hays, Texas, US | |
331026 | 331026 | 2022-12-27 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-28 04:21:04 | Hays, Texas, US | |
221099 | 221099 | 2022-12-26 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-27 04:21:07 | Hays, Texas, US | |
3225556 | 3225556 | 2022-12-25 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-26 04:21:06 | Hays, Texas, US | |
1021470 | 1021470 | 2022-12-24 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-25 04:21:04 | Hays, Texas, US | |
693493 | 693493 | 2022-12-23 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-24 04:21:02 | Hays, Texas, US | |
2182703 | 2182703 | 2022-12-22 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-23 04:21:04 | Hays, Texas, US | |
454507 | 454507 | 2022-12-21 | US | Texas | Hays | 48209 | 76254 | 551 | 0 | 30.05669873 | -98.02944344 | 2022-12-22 04:20:56 | Hays, Texas, US | |
351702 | 351702 | 2022-12-14 | US | Virginia | Richmond City | 51760 | 59932 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-15 04:20:58 | Richmond City, Virginia, US | |
311290 | 311290 | 2022-12-13 | US | Virginia | Richmond City | 51760 | 59884 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-14 04:21:04 | Richmond City, Virginia, US | |
1152351 | 1152351 | 2022-12-12 | US | Virginia | Richmond City | 51760 | 59863 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-13 04:21:01 | Richmond City, Virginia, US | |
872205 | 872205 | 2022-12-11 | US | Virginia | Richmond City | 51760 | 59766 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-12 04:21:01 | Richmond City, Virginia, US | |
260735 | 260735 | 2022-12-10 | US | Virginia | Richmond City | 51760 | 59766 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-11 04:20:50 | Richmond City, Virginia, US | |
3939449 | 3939449 | 2022-12-09 | US | Virginia | Richmond City | 51760 | 59766 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-10 04:21:02 | Richmond City, Virginia, US | |
3717575 | 3717575 | 2022-12-06 | US | Virginia | Richmond City | 51760 | 59721 | 551 | 0 | 37.53255773 | -77.47966921 | 2022-12-07 04:20:58 | Richmond City, Virginia, US | |
849601 | 849601 | 2022-11-02 | Japan | Kagoshima | 309000 | 551 | 0 | 31.009484 | 130.430665 | 2022-11-03 04:22:05 | Kagoshima, Japan | |||
710452 | 710452 | 2022-11-01 | Japan | Kagoshima | 308657 | 551 | 0 | 31.009484 | 130.430665 | 2022-11-02 04:22:09 | Kagoshima, Japan | |||
3284901 | 3284901 | 2022-10-31 | Japan | Kagoshima | 308246 | 551 | 0 | 31.009484 | 130.430665 | 2022-11-01 04:22:36 | Kagoshima, Japan | |||
319934 | 319934 | 2022-10-30 | Japan | Kagoshima | 308105 | 551 | 0 | 31.009484 | 130.430665 | 2022-10-31 04:21:36 | Kagoshima, Japan | |||
539244 | 539244 | 2022-10-26 | US | Arkansas | Garland | 5051 | 26096 | 551 | 0 | 34.57692074 | -93.14921604 | 2022-10-27 04:22:01 | Garland, Arkansas, US | |
3753677 | 3753677 | 2022-10-13 | Russia | Ingushetia Republic | 43185 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-14 04:22:28 | Ingushetia Republic, Russia | |||
3214502 | 3214502 | 2022-10-12 | Russia | Ingushetia Republic | 43171 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-13 04:22:39 | Ingushetia Republic, Russia | |||
3250351 | 3250351 | 2022-10-11 | Russia | Ingushetia Republic | 43155 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-12 04:22:51 | Ingushetia Republic, Russia | |||
2967610 | 2967610 | 2022-10-10 | Russia | Ingushetia Republic | 43141 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-11 04:23:05 | Ingushetia Republic, Russia | |||
3097646 | 3097646 | 2022-10-09 | Russia | Ingushetia Republic | 43128 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-10 04:22:32 | Ingushetia Republic, Russia | |||
4002871 | 4002871 | 2022-10-08 | Russia | Ingushetia Republic | 43111 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-09 04:21:16 | Ingushetia Republic, Russia | |||
4002649 | 4002649 | 2022-10-08 | Italy | Valle d'Aosta | 45524 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-09 04:21:16 | Valle d'Aosta, Italy | |||
396468 | 396468 | 2022-10-07 | Russia | Ingushetia Republic | 43095 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-08 04:22:56 | Ingushetia Republic, Russia | |||
396246 | 396246 | 2022-10-07 | Italy | Valle d'Aosta | 45423 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-08 04:22:56 | Valle d'Aosta, Italy | |||
2529585 | 2529585 | 2022-10-06 | Russia | Ingushetia Republic | 43080 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-07 04:23:08 | Ingushetia Republic, Russia | |||
2529363 | 2529363 | 2022-10-06 | Italy | Valle d'Aosta | 45248 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-07 04:23:08 | Valle d'Aosta, Italy | |||
1810979 | 1810979 | 2022-10-05 | Russia | Ingushetia Republic | 43067 | 551 | 0 | 43.11542075 | 45.01713552 | 2022-10-06 04:21:22 | Ingushetia Republic, Russia | |||
1810757 | 1810757 | 2022-10-05 | Italy | Valle d'Aosta | 45120 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-06 04:21:22 | Valle d'Aosta, Italy | |||
130731 | 130731 | 2022-10-04 | Italy | Valle d'Aosta | 44979 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-05 04:23:06 | Valle d'Aosta, Italy | |||
2685678 | 2685678 | 2022-10-03 | Italy | Valle d'Aosta | 44797 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-04 04:22:55 | Valle d'Aosta, Italy | |||
2259745 | 2259745 | 2022-10-02 | Italy | Valle d'Aosta | 44755 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-03 04:23:11 | Valle d'Aosta, Italy | |||
2995271 | 2995271 | 2022-10-01 | Italy | Valle d'Aosta | 44697 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-02 04:21:23 | Valle d'Aosta, Italy | |||
853597 | 853597 | 2022-09-30 | Italy | Valle d'Aosta | 44620 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-10-01 04:23:01 | Valle d'Aosta, Italy | |||
2375523 | 2375523 | 2022-09-29 | Italy | Valle d'Aosta | 44551 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-30 04:23:09 | Valle d'Aosta, Italy | |||
1560074 | 1560074 | 2022-09-28 | Italy | Valle d'Aosta | 44486 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-29 04:22:34 | Valle d'Aosta, Italy | |||
3994617 | 3994617 | 2022-09-27 | Italy | Valle d'Aosta | 44420 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-28 04:23:01 | Valle d'Aosta, Italy | |||
2769601 | 2769601 | 2022-09-26 | US | Colorado | Larimer | 8069 | 100031 | 551 | 0 | 40.66671597 | -105.4625784 | 2022-09-27 04:23:01 | Larimer, Colorado, US | |
2768945 | 2768945 | 2022-09-26 | Italy | Valle d'Aosta | 44336 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-27 04:23:01 | Valle d'Aosta, Italy | |||
1976598 | 1976598 | 2022-09-25 | Italy | Valle d'Aosta | 44330 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-26 04:20:52 | Valle d'Aosta, Italy | |||
2649765 | 2649765 | 2022-09-24 | Italy | Valle d'Aosta | 44305 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-25 04:23:31 | Valle d'Aosta, Italy | |||
384754 | 384754 | 2022-09-23 | US | Arkansas | Sebastian | 5131 | 37219 | 551 | 0 | 35.19605503 | -94.27162713 | 2022-09-24 04:21:40 | Sebastian, Arkansas, US | |
384205 | 384205 | 2022-09-23 | Italy | Valle d'Aosta | 44274 | 551 | 0 | 45.73750286 | 7.320149366 | 2022-09-24 04:21:40 | Valle d'Aosta, Italy | |||
1624820 | 1624820 | 2022-09-22 | US | Arkansas | Sebastian | 5131 | 37205 | 551 | 0 | 35.19605503 | -94.27162713 | 2022-09-23 04:23:13 | Sebastian, Arkansas, US | |
1372721 | 1372721 | 2022-09-21 | US | New York | Broome | 36007 | 53811 | 551 | 0 | 42.15903158 | -75.81326086 | 2022-09-22 04:22:56 | Broome, New York, US | |
3373352 | 3373352 | 2022-09-17 | Japan | Gifu | 280739 | 551 | 0 | 35.778671 | 137.055925 | 2022-09-18 04:22:50 | Gifu, Japan | |||
1888960 | 1888960 | 2022-09-14 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-15 04:21:02 | Arauca, Colombia | |||
372015 | 372015 | 2022-09-13 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-14 04:20:44 | Arauca, Colombia | |||
2394620 | 2394620 | 2022-09-12 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-13 04:20:57 | Arauca, Colombia | |||
3765698 | 3765698 | 2022-09-11 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-12 04:20:58 | Arauca, Colombia | |||
3824273 | 3824273 | 2022-09-10 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-11 04:20:50 | Arauca, Colombia | |||
962730 | 962730 | 2022-09-09 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-10 04:21:10 | Arauca, Colombia | |||
253132 | 253132 | 2022-09-08 | Colombia | Arauca | 16947 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-09 04:21:11 | Arauca, Colombia | |||
3744930 | 3744930 | 2022-09-07 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-08 04:21:02 | Arauca, Colombia | |||
116333 | 116333 | 2022-09-06 | US | Maryland | Frederick | 24021 | 53306 | 551 | 0 | 39.47296601 | -77.39999394 | 2022-09-07 04:20:59 | Frederick, Maryland, US | |
114570 | 114570 | 2022-09-06 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-07 04:20:59 | Arauca, Colombia | |||
2635305 | 2635305 | 2022-09-05 | US | Maryland | Frederick | 24021 | 53254 | 551 | 0 | 39.47296601 | -77.39999394 | 2022-09-06 04:21:02 | Frederick, Maryland, US | |
2633542 | 2633542 | 2022-09-05 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-06 04:21:02 | Arauca, Colombia | |||
2988869 | 2988869 | 2022-09-04 | US | Maryland | Frederick | 24021 | 53254 | 551 | 0 | 39.47296601 | -77.39999394 | 2022-09-05 04:21:01 | Frederick, Maryland, US | |
2987106 | 2987106 | 2022-09-04 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-05 04:21:01 | Arauca, Colombia | |||
2714554 | 2714554 | 2022-09-03 | US | Maryland | Frederick | 24021 | 53254 | 551 | 0 | 39.47296601 | -77.39999394 | 2022-09-04 04:21:22 | Frederick, Maryland, US | |
2712791 | 2712791 | 2022-09-03 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-04 04:21:22 | Arauca, Colombia | |||
1395259 | 1395259 | 2022-09-02 | US | Maryland | Frederick | 24021 | 53254 | 551 | 0 | 39.47296601 | -77.39999394 | 2022-09-03 04:21:04 | Frederick, Maryland, US | |
1393496 | 1393496 | 2022-09-02 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-03 04:21:04 | Arauca, Colombia | |||
3547325 | 3547325 | 2022-09-01 | Colombia | Arauca | 16943 | 551 | 0 | 7.0762 | -70.7105 | 2022-09-02 04:21:07 | Arauca, Colombia | |||
2830732 | 2830732 | 2022-08-25 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-26 04:21:02 | Jasper, Missouri, US | |
2325265 | 2325265 | 2022-08-24 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-25 04:21:13 | Jasper, Missouri, US | |
1253448 | 1253448 | 2022-08-23 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-24 04:20:46 | Monroe, Pennsylvania, US | |
1252674 | 1252674 | 2022-08-23 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-24 04:20:46 | Jasper, Missouri, US | |
2855552 | 2855552 | 2022-08-22 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-23 04:20:56 | Monroe, Pennsylvania, US | |
2854778 | 2854778 | 2022-08-22 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-23 04:20:56 | Jasper, Missouri, US | |
2405524 | 2405524 | 2022-08-21 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-22 04:20:38 | Monroe, Pennsylvania, US | |
2404750 | 2404750 | 2022-08-21 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-22 04:20:38 | Jasper, Missouri, US | |
3800602 | 3800602 | 2022-08-20 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-21 04:20:44 | Monroe, Pennsylvania, US | |
3799828 | 3799828 | 2022-08-20 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-21 04:20:44 | Jasper, Missouri, US | |
2366188 | 2366188 | 2022-08-19 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-20 04:21:01 | Monroe, Pennsylvania, US | |
2365414 | 2365414 | 2022-08-19 | US | Missouri | Jasper | 29097 | 37468 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-20 04:21:01 | Jasper, Missouri, US | |
1163859 | 1163859 | 2022-08-18 | US | Pennsylvania | Monroe | 42089 | 42378 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-19 04:20:54 | Monroe, Pennsylvania, US | |
1163085 | 1163085 | 2022-08-18 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-19 04:20:54 | Jasper, Missouri, US | |
3953183 | 3953183 | 2022-08-17 | US | Pennsylvania | Monroe | 42089 | 42336 | 551 | 0 | 41.05934058 | -75.34031025 | 2022-08-18 04:21:11 | Monroe, Pennsylvania, US | |
3952409 | 3952409 | 2022-08-17 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-18 04:21:11 | Jasper, Missouri, US | |
992911 | 992911 | 2022-08-16 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-17 04:20:59 | Jasper, Missouri, US | |
2496255 | 2496255 | 2022-08-15 | US | New York | Albany | 36001 | 70341 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-16 04:20:58 | Albany, New York, US | |
2495950 | 2495950 | 2022-08-15 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-16 04:20:58 | Jasper, Missouri, US | |
3649805 | 3649805 | 2022-08-14 | US | New York | Albany | 36001 | 70296 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-15 04:20:59 | Albany, New York, US | |
3649500 | 3649500 | 2022-08-14 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-15 04:20:59 | Jasper, Missouri, US | |
1970811 | 1970811 | 2022-08-13 | US | New York | Albany | 36001 | 70244 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-14 04:20:55 | Albany, New York, US | |
1970506 | 1970506 | 2022-08-13 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-14 04:20:55 | Jasper, Missouri, US | |
1968276 | 1968276 | 2022-08-13 | Australia | Western Australia | 1104096 | 551 | 0 | -31.9505 | 115.8605 | 2022-08-14 04:20:55 | Western Australia, Australia | |||
2890620 | 2890620 | 2022-08-12 | US | New York | Albany | 36001 | 70186 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-13 04:20:52 | Albany, New York, US | |
2890315 | 2890315 | 2022-08-12 | US | Missouri | Jasper | 29097 | 37291 | 551 | 0 | 37.20351921 | -94.34050458 | 2022-08-13 04:20:52 | Jasper, Missouri, US | |
2888085 | 2888085 | 2022-08-12 | Australia | Western Australia | 1102537 | 551 | 0 | -31.9505 | 115.8605 | 2022-08-13 04:20:52 | Western Australia, Australia | |||
3910225 | 3910225 | 2022-08-11 | US | New York | Albany | 36001 | 70117 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-12 04:20:54 | Albany, New York, US | |
1348542 | 1348542 | 2022-08-10 | US | New York | Albany | 36001 | 70046 | 551 | 0 | 42.60060306 | -73.97723916 | 2022-08-11 04:20:49 | Albany, New York, 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]);