johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

453 rows where deaths = 588 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
451397 451397 2022-12-21 Japan Nagano     361415 588 0   36.132134 138.045528 2022-12-22 04:20:56 Nagano, Japan
2951396 2951396 2022-12-20 Japan Nagano     357955 588 0   36.132134 138.045528 2022-12-21 04:21:03 Nagano, Japan
2138202 2138202 2022-12-01 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-12-02 04:21:07 Yellowstone, Montana, US
1966618 1966618 2022-11-30 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-12-01 04:21:03 Yellowstone, Montana, US
2558632 2558632 2022-11-29 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-11-30 04:21:07 Yellowstone, Montana, US
1241706 1241706 2022-11-28 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-11-29 04:21:05 Yellowstone, Montana, US
3553694 3553694 2022-11-27 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-11-28 04:21:02 Yellowstone, Montana, US
2102174 2102174 2022-11-26 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-11-27 04:21:05 Yellowstone, Montana, US
489665 489665 2022-11-25 US Montana Yellowstone 30111 49415 588 0   45.93955949 -108.2691486 2022-11-26 04:21:11 Yellowstone, Montana, US
1622045 1622045 2022-11-22 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-23 04:21:06 St. Louis, Minnesota, US
3461933 3461933 2022-11-21 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-22 04:20:47 St. Louis, Minnesota, US
1642118 1642118 2022-11-20 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-21 04:21:05 St. Louis, Minnesota, US
2065675 2065675 2022-11-19 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-20 04:21:08 St. Louis, Minnesota, US
1757069 1757069 2022-11-18 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-19 04:21:14 St. Louis, Minnesota, US
3028062 3028062 2022-11-17 US Minnesota St. Louis 27137 57786 588 0   47.6048407 -92.46879855 2022-11-18 04:21:15 St. Louis, Minnesota, US
480691 480691 2022-11-08 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-09 04:21:22 Hendricks, Indiana, US
2439841 2439841 2022-11-07 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-08 04:21:21 Hendricks, Indiana, US
1050939 1050939 2022-11-06 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-07 04:21:26 Hendricks, Indiana, US
618963 618963 2022-11-05 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-06 04:21:24 Hendricks, Indiana, US
1023467 1023467 2022-11-04 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-05 04:21:52 Hendricks, Indiana, US
432458 432458 2022-11-03 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-04 04:22:11 Hendricks, Indiana, US
850700 850700 2022-11-02 US Indiana Hendricks 18063 45560 588 0   39.76719009 -86.51037283 2022-11-03 04:22:05 Hendricks, Indiana, US
711551 711551 2022-11-01 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-11-02 04:22:09 Hendricks, Indiana, US
3286000 3286000 2022-10-31 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-11-01 04:22:36 Hendricks, Indiana, US
321033 321033 2022-10-30 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-10-31 04:21:36 Hendricks, Indiana, US
913309 913309 2022-10-29 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-10-30 04:22:14 Hendricks, Indiana, US
1367578 1367578 2022-10-28 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-10-29 04:21:13 Hendricks, Indiana, US
3039433 3039433 2022-10-27 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-10-28 04:22:31 Hendricks, Indiana, US
539853 539853 2022-10-26 US Indiana Hendricks 18063 45461 588 0   39.76719009 -86.51037283 2022-10-27 04:22:01 Hendricks, Indiana, US
3215431 3215431 2022-10-12 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-13 04:22:39 Porter, Indiana, US
3252774 3252774 2022-10-11 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-12 04:22:51 Jackson, Oregon, US
3251280 3251280 2022-10-11 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-12 04:22:51 Porter, Indiana, US
2970033 2970033 2022-10-10 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-11 04:23:05 Jackson, Oregon, US
2968539 2968539 2022-10-10 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-11 04:23:05 Porter, Indiana, US
3100069 3100069 2022-10-09 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-10 04:22:32 Jackson, Oregon, US
3098575 3098575 2022-10-09 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-10 04:22:32 Porter, Indiana, US
4005294 4005294 2022-10-08 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-09 04:21:16 Jackson, Oregon, US
4003800 4003800 2022-10-08 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-09 04:21:16 Porter, Indiana, US
398891 398891 2022-10-07 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-08 04:22:56 Jackson, Oregon, US
397397 397397 2022-10-07 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-08 04:22:56 Porter, Indiana, US
2532008 2532008 2022-10-06 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-07 04:23:08 Jackson, Oregon, US
2530514 2530514 2022-10-06 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-07 04:23:08 Porter, Indiana, US
1814310 1814310 2022-10-05 US Wisconsin Brown 55009 97246 588 0   44.4526553 -88.00411844 2022-10-06 04:21:22 Brown, Wisconsin, US
1813402 1813402 2022-10-05 US Oregon Jackson 41029 51028 588 0   42.43201126 -122.7289309 2022-10-06 04:21:22 Jackson, Oregon, US
1811908 1811908 2022-10-05 US Indiana Porter 18127 44508 588 0   41.45986947 -87.06848888 2022-10-06 04:21:22 Porter, Indiana, US
134284 134284 2022-10-04 US Wisconsin Brown 55009 97189 588 0   44.4526553 -88.00411844 2022-10-05 04:23:06 Brown, Wisconsin, US
2689231 2689231 2022-10-03 US Wisconsin Brown 55009 97131 588 0   44.4526553 -88.00411844 2022-10-04 04:22:55 Brown, Wisconsin, US
2263298 2263298 2022-10-02 US Wisconsin Brown 55009 97033 588 0   44.4526553 -88.00411844 2022-10-03 04:23:11 Brown, Wisconsin, US
2998824 2998824 2022-10-01 US Wisconsin Brown 55009 97033 588 0   44.4526553 -88.00411844 2022-10-02 04:21:23 Brown, Wisconsin, US
857150 857150 2022-09-30 US Wisconsin Brown 55009 97033 588 0   44.4526553 -88.00411844 2022-10-01 04:23:01 Brown, Wisconsin, US
853608 853608 2022-09-30 Japan Gifu     290569 588 0   35.778671 137.055925 2022-10-01 04:23:01 Gifu, Japan
2379076 2379076 2022-09-29 US Wisconsin Brown 55009 96976 588 0   44.4526553 -88.00411844 2022-09-30 04:23:09 Brown, Wisconsin, US
1563627 1563627 2022-09-28 US Wisconsin Brown 55009 96924 588 0   44.4526553 -88.00411844 2022-09-29 04:22:34 Brown, Wisconsin, US
3998170 3998170 2022-09-27 US Wisconsin Brown 55009 96854 588 0   44.4526553 -88.00411844 2022-09-28 04:23:01 Brown, Wisconsin, US
2018888 2018888 2022-09-20 US New Hampshire Rockingham 33015 78019 588 0   42.98499744 -71.12883377 2022-09-21 04:23:22 Rockingham, New Hampshire, US
3572761 3572761 2022-09-19 US New Hampshire Rockingham 33015 77912 588 0   42.98499744 -71.12883377 2022-09-20 04:22:48 Rockingham, New Hampshire, US
421500 421500 2022-09-18 US New Hampshire Rockingham 33015 77873 588 0   42.98499744 -71.12883377 2022-09-19 04:21:49 Rockingham, New Hampshire, US
3375524 3375524 2022-09-17 US New Hampshire Rockingham 33015 77873 588 0   42.98499744 -71.12883377 2022-09-18 04:22:50 Rockingham, New Hampshire, US
2357632 2357632 2022-09-16 US New Hampshire Rockingham 33015 77873 588 0   42.98499744 -71.12883377 2022-09-17 04:20:19 Rockingham, New Hampshire, US
253318 253318 2022-09-08 Japan Kumamoto     309790 588 0   32.608154 130.745231 2022-09-09 04:21:11 Kumamoto, Japan
1680189 1680189 2022-08-29 Australia Western Australia     1128199 588 0   -31.9505 115.8605 2022-08-30 04:21:03 Western Australia, Australia
2852884 2852884 2022-08-22 Japan Shizuoka     378707 588 0   34.916975 138.407784 2022-08-23 04:20:56 Shizuoka, Japan
2495561 2495561 2022-08-15 US Louisiana Rapides 22079 36745 588 0   31.19778499 -92.52997303 2022-08-16 04:20:58 Rapides, Louisiana, US
3649111 3649111 2022-08-14 US Louisiana Rapides 22079 36691 588 0   31.19778499 -92.52997303 2022-08-15 04:20:59 Rapides, Louisiana, US
1970117 1970117 2022-08-13 US Louisiana Rapides 22079 36691 588 0   31.19778499 -92.52997303 2022-08-14 04:20:55 Rapides, Louisiana, US
2889926 2889926 2022-08-12 US Louisiana Rapides 22079 36691 588 0   31.19778499 -92.52997303 2022-08-13 04:20:52 Rapides, Louisiana, US
3909531 3909531 2022-08-11 US Louisiana Rapides 22079 36622 588 0   31.19778499 -92.52997303 2022-08-12 04:20:54 Rapides, Louisiana, US
3545139 3545139 2022-08-08 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-09 04:20:34 Jackson, Michigan, US
1071542 1071542 2022-08-07 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-08 04:21:08 Jackson, Michigan, US
1942130 1942130 2022-08-06 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-07 04:20:54 Jackson, Michigan, US
881929 881929 2022-08-05 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-06 04:20:56 Jackson, Michigan, US
2010340 2010340 2022-08-04 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-05 04:20:52 Jackson, Michigan, US
1099767 1099767 2022-08-03 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-04 04:20:58 Jackson, Michigan, US
1406692 1406692 2022-08-02 US Michigan Jackson 26075 43669 588 0   42.24807035 -84.42258681 2022-08-03 04:20:59 Jackson, Michigan, US
3874190 3874190 2022-07-31 US Oregon Lane 41039 69468 588 0   43.93727035 -122.847753 2022-08-01 04:21:03 Lane, Oregon, US
676944 676944 2022-07-30 US Oregon Lane 41039 69468 588 0   43.93727035 -122.847753 2022-07-31 04:21:02 Lane, Oregon, US
1786143 1786143 2022-07-29 US Oregon Lane 41039 69468 588 0   43.93727035 -122.847753 2022-07-30 04:20:42 Lane, Oregon, US
1068960 1068960 2022-07-28 US Texas Ellis 48139 52342 588 0   32.34894117 -96.79371841 2022-07-29 04:20:45 Ellis, Texas, US
2595653 2595653 2022-07-25 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-26 04:20:58 Berrien, Michigan, US
897768 897768 2022-07-24 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-25 04:20:51 Berrien, Michigan, US
92762 92762 2022-07-23 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-24 04:20:47 Berrien, Michigan, US
901784 901784 2022-07-22 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-23 04:20:53 Berrien, Michigan, US
671920 671920 2022-07-21 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-22 04:21:15 Berrien, Michigan, US
1609883 1609883 2022-07-20 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-21 04:21:10 Berrien, Michigan, US
960516 960516 2022-07-19 US Michigan Berrien 26021 37381 588 0   41.95447397 -86.4131308 2022-07-20 04:20:59 Berrien, Michigan, US
3940698 3940698 2022-06-30 US Colorado Mesa 8077 45601 588 0   39.01787888 -108.469799 2022-07-01 04:21:10 Mesa, Colorado, US
2242377 2242377 2022-06-28 US Tennessee Montgomery 47125 52539 588 0   36.49609412 -87.38550661 2022-06-29 04:20:59 Montgomery, Tennessee, US
2148381 2148381 2022-06-27 US Florida Sumter 12119 24031 588 0   28.70181754 -82.0794267 2022-06-28 04:20:58 Sumter, Florida, US
476182 476182 2022-06-26 US Florida Sumter 12119 24031 588 0   28.70181754 -82.0794267 2022-06-27 04:21:00 Sumter, Florida, US
939557 939557 2022-06-25 US Florida Sumter 12119 24031 588 0   28.70181754 -82.0794267 2022-06-26 04:21:02 Sumter, Florida, US
948433 948433 2022-06-14 US Maryland Harford 24025 41238 588 0   39.55010644 -76.3077594 2022-06-15 04:20:54 Harford, Maryland, US
2236977 2236977 2022-06-12 US Maryland Washington 24043 36107 588 0   39.60835778 -77.82002295 2022-06-13 04:21:14 Washington, Maryland, US
3143175 3143175 2022-06-11 US Maryland Washington 24043 36107 588 0   39.60835778 -77.82002295 2022-06-12 04:20:53 Washington, Maryland, US
1946091 1946091 2022-06-10 US Maryland Washington 24043 36107 588 0   39.60835778 -77.82002295 2022-06-11 04:21:01 Washington, Maryland, US
3159230 3159230 2022-06-09 US Maryland Washington 24043 36094 588 0   39.60835778 -77.82002295 2022-06-10 04:20:55 Washington, Maryland, US
1422697 1422697 2022-06-08 US Maryland Washington 24043 36055 588 0   39.60835778 -77.82002295 2022-06-09 04:20:54 Washington, Maryland, US
1421429 1421429 2022-06-08 Sweden Sormland     63984 588 0   59.0336 16.7519 2022-06-09 04:20:54 Sormland, Sweden
3727811 3727811 2022-06-07 US Maryland Washington 24043 36038 588 0   39.60835778 -77.82002295 2022-06-08 04:20:55 Washington, Maryland, US
3726543 3726543 2022-06-07 Sweden Sormland     63984 588 0   59.0336 16.7519 2022-06-08 04:20:55 Sormland, Sweden
3887945 3887945 2022-06-06 Sweden Sormland     63984 588 0   59.0336 16.7519 2022-06-07 04:21:08 Sormland, Sweden

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);