johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
681 rows where deaths = 427 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753235 | 2753235 | 2022-12-29 | Sweden | Vasterbotten | 62058 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-30 04:21:04 | Vasterbotten, Sweden | |||
1074241 | 1074241 | 2022-12-28 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-29 04:21:01 | Vasterbotten, Sweden | |||
328238 | 328238 | 2022-12-27 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-28 04:21:04 | Vasterbotten, Sweden | |||
218311 | 218311 | 2022-12-26 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-27 04:21:07 | Vasterbotten, Sweden | |||
3225807 | 3225807 | 2022-12-25 | US | Virginia | Loudoun | 51107 | 93642 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-26 04:21:06 | Loudoun, Virginia, US | |
3222768 | 3222768 | 2022-12-25 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-26 04:21:06 | Vasterbotten, Sweden | |||
1021721 | 1021721 | 2022-12-24 | US | Virginia | Loudoun | 51107 | 93642 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-25 04:21:04 | Loudoun, Virginia, US | |
1018682 | 1018682 | 2022-12-24 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-25 04:21:04 | Vasterbotten, Sweden | |||
693744 | 693744 | 2022-12-23 | US | Virginia | Loudoun | 51107 | 93642 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-24 04:21:02 | Loudoun, Virginia, US | |
690705 | 690705 | 2022-12-23 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-24 04:21:02 | Vasterbotten, Sweden | |||
2182954 | 2182954 | 2022-12-22 | US | Virginia | Loudoun | 51107 | 93523 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-23 04:21:04 | Loudoun, Virginia, US | |
2179915 | 2179915 | 2022-12-22 | Sweden | Vasterbotten | 61909 | 427 | 0 | 65.3337 | 16.5162 | 2022-12-23 04:21:04 | Vasterbotten, Sweden | |||
454758 | 454758 | 2022-12-21 | US | Virginia | Loudoun | 51107 | 93403 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-22 04:20:56 | Loudoun, Virginia, US | |
452975 | 452975 | 2022-12-21 | US | Maryland | Howard | 24027 | 61187 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-22 04:20:56 | Howard, Maryland, US | |
2954757 | 2954757 | 2022-12-20 | US | Virginia | Loudoun | 51107 | 93272 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-21 04:21:03 | Loudoun, Virginia, US | |
2952974 | 2952974 | 2022-12-20 | US | Maryland | Howard | 24027 | 61110 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-21 04:21:03 | Howard, Maryland, US | |
2952229 | 2952229 | 2022-12-20 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-21 04:21:03 | Lowndes, Georgia, US | |
3177159 | 3177159 | 2022-12-19 | US | Virginia | Loudoun | 51107 | 93162 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-20 04:21:04 | Loudoun, Virginia, US | |
3175376 | 3175376 | 2022-12-19 | US | Maryland | Howard | 24027 | 60981 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-20 04:21:04 | Howard, Maryland, US | |
3174631 | 3174631 | 2022-12-19 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-20 04:21:04 | Lowndes, Georgia, US | |
3174397 | 3174397 | 2022-12-19 | US | Colorado | Boulder | 8013 | 89098 | 427 | 0 | 40.09313619 | -105.3546767 | 2022-12-20 04:21:04 | Boulder, Colorado, US | |
1631676 | 1631676 | 2022-12-18 | US | Virginia | Loudoun | 51107 | 92926 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-19 04:21:03 | Loudoun, Virginia, US | |
1629893 | 1629893 | 2022-12-18 | US | Maryland | Howard | 24027 | 60896 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-19 04:21:03 | Howard, Maryland, US | |
1629148 | 1629148 | 2022-12-18 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-19 04:21:03 | Lowndes, Georgia, US | |
507055 | 507055 | 2022-12-17 | US | Virginia | Loudoun | 51107 | 92926 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-18 04:21:03 | Loudoun, Virginia, US | |
505272 | 505272 | 2022-12-17 | US | Maryland | Howard | 24027 | 60896 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-18 04:21:03 | Howard, Maryland, US | |
504527 | 504527 | 2022-12-17 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-18 04:21:03 | Lowndes, Georgia, US | |
3327627 | 3327627 | 2022-12-16 | US | Virginia | Loudoun | 51107 | 92926 | 427 | 0 | 39.08990083 | -77.63481877 | 2022-12-17 04:21:04 | Loudoun, Virginia, US | |
3325844 | 3325844 | 2022-12-16 | US | Maryland | Howard | 24027 | 60896 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-17 04:21:04 | Howard, Maryland, US | |
3325099 | 3325099 | 2022-12-16 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-17 04:21:04 | Lowndes, Georgia, US | |
544356 | 544356 | 2022-12-15 | US | Maryland | Howard | 24027 | 60841 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-16 04:21:01 | Howard, Maryland, US | |
543611 | 543611 | 2022-12-15 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-16 04:21:01 | Lowndes, Georgia, US | |
542782 | 542782 | 2022-12-15 | Japan | Oita | 217024 | 427 | 0 | 33.200697 | 131.43324 | 2022-12-16 04:21:01 | Oita, Japan | |||
349884 | 349884 | 2022-12-14 | US | Maryland | Howard | 24027 | 60746 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-15 04:20:58 | Howard, Maryland, US | |
349139 | 349139 | 2022-12-14 | US | Georgia | Lowndes | 13185 | 35771 | 427 | 0 | 30.83568832 | -83.27056716 | 2022-12-15 04:20:58 | Lowndes, Georgia, US | |
309472 | 309472 | 2022-12-13 | US | Maryland | Howard | 24027 | 60697 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-14 04:21:04 | Howard, Maryland, US | |
309424 | 309424 | 2022-12-13 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-14 04:21:04 | St. Landry, Louisiana, US | |
1150533 | 1150533 | 2022-12-12 | US | Maryland | Howard | 24027 | 60606 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-13 04:21:01 | Howard, Maryland, US | |
1150485 | 1150485 | 2022-12-12 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-13 04:21:01 | St. Landry, Louisiana, US | |
870387 | 870387 | 2022-12-11 | US | Maryland | Howard | 24027 | 60533 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-12 04:21:01 | Howard, Maryland, US | |
870339 | 870339 | 2022-12-11 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-12 04:21:01 | St. Landry, Louisiana, US | |
258917 | 258917 | 2022-12-10 | US | Maryland | Howard | 24027 | 60533 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-11 04:20:50 | Howard, Maryland, US | |
258869 | 258869 | 2022-12-10 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-11 04:20:50 | St. Landry, Louisiana, US | |
3937631 | 3937631 | 2022-12-09 | US | Maryland | Howard | 24027 | 60533 | 427 | 0 | 39.25305293 | -76.93126208 | 2022-12-10 04:21:02 | Howard, Maryland, US | |
3937583 | 3937583 | 2022-12-09 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-10 04:21:02 | St. Landry, Louisiana, US | |
3378915 | 3378915 | 2022-12-08 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-09 04:21:05 | St. Landry, Louisiana, US | |
3377362 | 3377362 | 2022-12-08 | Japan | Aomori | 218065 | 427 | 0 | 40.781541 | 140.828896 | 2022-12-09 04:21:05 | Aomori, Japan | |||
1986186 | 1986186 | 2022-12-07 | US | Louisiana | St. Landry | 22097 | 26521 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-08 04:21:07 | St. Landry, Louisiana, US | |
3715709 | 3715709 | 2022-12-06 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-07 04:20:58 | St. Landry, Louisiana, US | |
2416414 | 2416414 | 2022-12-05 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-06 04:21:03 | St. Landry, Louisiana, US | |
720022 | 720022 | 2022-12-04 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-05 04:20:58 | St. Landry, Louisiana, US | |
2818311 | 2818311 | 2022-12-03 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-04 04:20:56 | St. Landry, Louisiana, US | |
835167 | 835167 | 2022-12-02 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-03 04:21:02 | St. Landry, Louisiana, US | |
2137697 | 2137697 | 2022-12-01 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-02 04:21:07 | St. Landry, Louisiana, US | |
2136189 | 2136189 | 2022-12-01 | Japan | Yamaguchi | 196829 | 427 | 0 | 34.20119 | 131.573293 | 2022-12-02 04:21:07 | Yamaguchi, Japan | |||
1966113 | 1966113 | 2022-11-30 | US | Louisiana | St. Landry | 22097 | 26450 | 427 | 0 | 30.59724262 | -92.00135806 | 2022-12-01 04:21:03 | St. Landry, Louisiana, US | |
2557636 | 2557636 | 2022-11-29 | US | Illinois | Sangamon | 17167 | 72147 | 427 | 0 | 39.75836914 | -89.65872023 | 2022-11-30 04:21:07 | Sangamon, Illinois, US | |
3312242 | 3312242 | 2022-11-23 | Japan | Nagano | 290938 | 427 | 0 | 36.132134 | 138.045528 | 2022-11-24 04:21:09 | Nagano, Japan | |||
1620283 | 1620283 | 2022-11-22 | Japan | Nagano | 286610 | 427 | 0 | 36.132134 | 138.045528 | 2022-11-23 04:21:06 | Nagano, Japan | |||
482295 | 482295 | 2022-11-08 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-09 04:21:22 | Somerset, Pennsylvania, US | |
2441445 | 2441445 | 2022-11-07 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-08 04:21:21 | Somerset, Pennsylvania, US | |
1052543 | 1052543 | 2022-11-06 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-07 04:21:26 | Somerset, Pennsylvania, US | |
620567 | 620567 | 2022-11-05 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-06 04:21:24 | Somerset, Pennsylvania, US | |
1025071 | 1025071 | 2022-11-04 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-05 04:21:52 | Somerset, Pennsylvania, US | |
1022374 | 1022374 | 2022-11-04 | Japan | Miyagi | 289389 | 427 | 0 | 38.446859 | 140.927086 | 2022-11-05 04:21:52 | Miyagi, Japan | |||
434062 | 434062 | 2022-11-03 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-04 04:22:11 | Somerset, Pennsylvania, US | |
852304 | 852304 | 2022-11-02 | US | Pennsylvania | Somerset | 42111 | 21378 | 427 | 0 | 39.97172723 | -79.02699593 | 2022-11-03 04:22:05 | Somerset, Pennsylvania, US | |
2760503 | 2760503 | 2022-10-18 | US | Wisconsin | Rock | 55105 | 51594 | 427 | 0 | 42.67151616 | -89.071479 | 2022-10-19 04:22:26 | Rock, Wisconsin, US | |
2758073 | 2758073 | 2022-10-18 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-19 04:22:26 | Vigo, Indiana, US | |
2028337 | 2028337 | 2022-10-17 | US | Wisconsin | Rock | 55105 | 51566 | 427 | 0 | 42.67151616 | -89.071479 | 2022-10-18 04:22:42 | Rock, Wisconsin, US | |
2027767 | 2027767 | 2022-10-17 | US | Tennessee | Williamson | 47187 | 72126 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-18 04:22:42 | Williamson, Tennessee, US | |
2025907 | 2025907 | 2022-10-17 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-18 04:22:42 | Vigo, Indiana, US | |
2162545 | 2162545 | 2022-10-16 | US | Tennessee | Williamson | 47187 | 72106 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-17 04:20:31 | Williamson, Tennessee, US | |
2160685 | 2160685 | 2022-10-16 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-17 04:20:31 | Vigo, Indiana, US | |
518742 | 518742 | 2022-10-15 | US | Tennessee | Williamson | 47187 | 72101 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-16 04:22:39 | Williamson, Tennessee, US | |
516882 | 516882 | 2022-10-15 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-16 04:22:39 | Vigo, Indiana, US | |
2035799 | 2035799 | 2022-10-14 | US | Tennessee | Williamson | 47187 | 72086 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-15 04:22:00 | Williamson, Tennessee, US | |
2033939 | 2033939 | 2022-10-14 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-15 04:22:00 | Vigo, Indiana, US | |
3757048 | 3757048 | 2022-10-13 | US | Wisconsin | Outagamie | 55087 | 61415 | 427 | 0 | 44.41578887 | -88.46565023 | 2022-10-14 04:22:28 | Outagamie, Wisconsin, US | |
3756487 | 3756487 | 2022-10-13 | US | Tennessee | Williamson | 47187 | 72061 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-14 04:22:28 | Williamson, Tennessee, US | |
3754627 | 3754627 | 2022-10-13 | US | Indiana | Vigo | 18167 | 33088 | 427 | 0 | 39.42944561 | -87.39169027 | 2022-10-14 04:22:28 | Vigo, Indiana, US | |
3217312 | 3217312 | 2022-10-12 | US | Tennessee | Williamson | 47187 | 72030 | 427 | 0 | 35.89099229 | -86.89281867 | 2022-10-13 04:22:39 | Williamson, Tennessee, US | |
2970248 | 2970248 | 2022-10-10 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-11 04:23:05 | Orangeburg, South Carolina, US | |
3100284 | 3100284 | 2022-10-09 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-10 04:22:32 | Orangeburg, South Carolina, US | |
4005509 | 4005509 | 2022-10-08 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-09 04:21:16 | Orangeburg, South Carolina, US | |
399106 | 399106 | 2022-10-07 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-08 04:22:56 | Orangeburg, South Carolina, US | |
2532223 | 2532223 | 2022-10-06 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-07 04:23:08 | Orangeburg, South Carolina, US | |
1813617 | 1813617 | 2022-10-05 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-06 04:21:22 | Orangeburg, South Carolina, US | |
133591 | 133591 | 2022-10-04 | US | South Carolina | Orangeburg | 45075 | 27687 | 427 | 0 | 33.4391073 | -80.79886287 | 2022-10-05 04:23:06 | Orangeburg, South Carolina, US | |
2772348 | 2772348 | 2022-09-26 | US | Virginia | Newport News | 51700 | 44734 | 427 | 0 | 37.08166899 | -76.51754109 | 2022-09-27 04:23:01 | Newport News, Virginia, US | |
2019076 | 2019076 | 2022-09-20 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-21 04:23:22 | New Hanover, North Carolina, US | |
3572949 | 3572949 | 2022-09-19 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-20 04:22:48 | New Hanover, North Carolina, US | |
421688 | 421688 | 2022-09-18 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-19 04:21:49 | New Hanover, North Carolina, US | |
3375712 | 3375712 | 2022-09-17 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-18 04:22:50 | New Hanover, North Carolina, US | |
2357820 | 2357820 | 2022-09-16 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-17 04:20:19 | New Hanover, North Carolina, US | |
3988977 | 3988977 | 2022-09-15 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-16 04:21:19 | New Hanover, North Carolina, US | |
1891494 | 1891494 | 2022-09-14 | US | North Carolina | New Hanover | 37129 | 59752 | 427 | 0 | 34.25758282 | -77.87075626 | 2022-09-15 04:21:02 | New Hanover, North Carolina, US | |
2396434 | 2396434 | 2022-09-12 | US | Michigan | Eaton | 26045 | 31431 | 427 | 0 | 42.59599185 | -84.83740035 | 2022-09-13 04:20:57 | Eaton, Michigan, US | |
2395493 | 2395493 | 2022-09-12 | US | Florida | Columbia | 12023 | 24305 | 427 | 0 | 30.22509788 | -82.62160164 | 2022-09-13 04:20:57 | Columbia, Florida, US | |
3767512 | 3767512 | 2022-09-11 | US | Michigan | Eaton | 26045 | 31431 | 427 | 0 | 42.59599185 | -84.83740035 | 2022-09-12 04:20:58 | Eaton, Michigan, 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]);